filter

Data can be filtered.
solr syntax can be used, but use human display names for the fields

Use AND or OR in uppercase to combine multiple criteria.
Multiple filter tags are supported. They will be combined with AND.

The tag belongs inside a table tag or a lookup tag

    <table>
        <filter>

    <lookup>
        <filter>

Example: One criteria

    <filter>name:"school"</filter>        

Example: Criteria using OR

    <filter>type:"s" OR type:"e"</filter>        

Example: Criteria using AND

    <filter>type:"documentary" AND release_year:"2006"</filter>

Example: Criteria using AND - multi tag

This is equivalent to using 1 tag with AND:

    <filter>type:"documentary"</filter>
    <filter>release_year:"2006"</filter>

Example: Find non value rows

Shorthand for finding rows that does not have any value for a field
Note This is different from rows with an empty string.

    <filter>personid:nil</filter>

We insert the proper solr syntax for this

Note Best practice is to use “ “ for the filter values, so that special characters does not alter the query.

Use lowercase when possible