You are here: All Help Topics > CaseWare Working Papers > Interface > Filter dialog | Advanced Filter tab

Filter Dialog | Advanced Filter Tab

Build or modify a complex filter expression.

Modifying a Simple Filter Using CaseView Functions Comparing Values Combining expressions

Use comparison operators to create comparative filters:

Symbol	Description	Example
=	Equal to	type='F' - shows only CaseView documents.
<>	Not equal to	type<>'F' - shows all documents with the exception of CaseView documents.
>	Greater than	lineno>64 - shows all documents which have a line number value in the database greater than 64.
<	Less than	lineno<64 - shows all documents which have a line number value in the database less than 64.
>=	Greater than or equal to	lineno>=64 - shows all documents which have a line number value in the database greater than or equal to 64.
<=	Less than or equal to	lineno<=64 - shows all documents which have a line number value in the database less than or equal to 64.
!	Not	!signoffchk() - shows all documents with valid sign off.

You can generate multiple simple filters, copy their contents from the Advanced tab, and assemble them, creating a combined expression with the following commands:

Symbol	Description	Example
&&	And	*type=''&&annotation('T')** - shows all documents which are external and which contain Tickmarks.
\|\|	Or	*type=''\|\|annotation('T')** - shows all documents which are external or which contain tickmarks (or both).
(..)	Brackets	*(type=''&&(annotation('T')\|\|annotation('C')))** - shows all documents which are external and which contain either tickmarks or commentary text

Notes

Clearing Use Advanced Filter removes the current custom built advanced filter. If editing an existing simple filter, clearing Use Advanced Filter reverts the filter to the original.