The Solomon Directory has built in filtering tools that let you do basic jobs well. For example, if you want to find every address that contains the word "street" you simply type into the filter input at the top of the address column and, hey presto, a filter is applied to your data.

What if you are looking for something a little more complex, like every address that does not include "street"? This is where advanced filtering "operators" come in. Operators are commands that you type in and which tell the database how to handle your query. We plan to build an interface that means you can use these without the need to this guide but, for the time being, below is a description of each. 

Number Operators:

<  = less than the number you enter
Example: < 10000 would return any value below 9,999.

<= = less than or equal to the number you enter
Example: < 10000 would return any value below 10,000.

>  = greater than the number you enter
Example: > 10000  would return any value above 10,001.

>= = greater than or equal to the number you enter
Example: < 10000 would return any value above 10,000.

String Operators: 

$eq = is equal to the text string you enter
Example: $eq big business plc would return values that exactly match "big business plc".

$ne = is not equal to the text string you enter
Example: $ne big business plc would return values that do not exactly match "big business plc".

$inc = includes the text string you enter
Example: $inc big would return values that include "big".

$ninc = does not include the text string you enter
Example: $ninc big would return values that do not include "big".

General Use Operators (will work with numbers and text strings):

$nemp = not empty
Example: $nemp would return everything that contains a value.

$isemp = is empty
Example: $isemp would return everything that does not contain a value.

To use any of these operators you simply type them in before your filter input. 

Did this answer your question?