This dialog allows you to define a logical condition that is part of the filter you are defining in the sampling dialog. It is reached by clicking ... in that dialog. Depending on which ... button you clicked, the filter condition dialog allows you to add a new condition, or edit an existing one.
The following options are available:
Final condition: This box displays the condition that will be created when you click OK. Click clear to remove the condition you have defined so far, so you can start defining it from scratch.
Available Fields: In this box, double-click a field, or drag and drop it, to move it to the condition box.
Condition: This box displays the field on which your condition will operate.
Starts with: Select this if you want to specify records where the contents of the selected field begin with specific characters. Enter the characters in the box below. Select case sensitive if you want an exact match based on the case of the characters you enter.
Example: assuming the FirstName field is selected, ja will return James, Jamie, Jane, etc.
This operator is available only for string fields.
Starts not with: Select this if you want to specify records where the contents of the selected field do not begin with specific characters. Enter the characters in the box below. Select case sensitive if you want to exclude only those records that match the case of the characters you enter.
Example: assuming the FirstName field is selected, ja will return all records except those beginning with ja (James, Jamie, Jane, etc.).
This operator is available only for string fields.
Ends with: Select this if you want to specify records where the contents of the selected field end with the specified characters. Enter the characters in the box below. Select case sensitive if you want an exact match based on the case of the characters you enter.
Example: assuming the Email field is selected, askia.com will return all records with addresses at askia.com.
This operator is available only for string fields.
Ends not with: Select this if you want to specify records where the contents of the selected field do not end with the specified characters. Enter the characters in the box below. Select case sensitive if you want to exclude only those records that match the case of the characters you enter.
Example: assuming the Email field is selected, askia.com will return all records except those with addresses at askia.com.
This operator is available only for string fields.
Contains: Select this if you want to specify records where the contents of the selected field include specific characters. Enter the characters in the box below. Select case sensitive if you want an exact match based on the case of the characters you enter.
Example: assuming the FirstName field is selected, an will return Anne, Anna, Jane, etc.
This operator is available only for string fields.
Contains not: Select this if you want to specify records where the contents of the selected field do not include the specified characters. Enter the characters in the box below. Select case sensitive if you want to exclude only those records that match the case of the characters you enter.
Example: assuming the FirstName field is selected, and an will return all records except those including ja (Anne, Anna, Jane, etc.).
This operator is available only for string fields.
Is: Select this if you want to specify records where the contents of the selected field exactly match the specified characters. Enter the characters in the box below. Select case sensitive if you want an exact match based on the case of the characters you enter.
Example: assuming the FirstName field is selected, william will return only records where the first name is William.
This operator is available only for string fields.
Is not: Select this if you want to specify records where the contents of the selected field do not match the specified characters. Enter the characters in the box below. Select case sensitive if you want to exclude records based on the case of the characters you enter.
Example: assuming the FirstName field is selected, william will return all records except those where the first name is William.
This operator is available only for string fields.
Is NULL: Select this if you want to specify records where the contents of the selected field is null (empty). This operator is available for string, memo, numeric, and boolean fields.
Is not NULL: Select this if you want to specify records where the contents of the selected field is not null (not empty). This operator is available for string, memo, numeric, and boolean fields.
Is TRUE: Select this if you want to specify records where the contents of the selected field is true. This operator is available only for boolean fields.
Is FALSE: Select this if you want to specify records where the contents of the selected field is false. This operator is available only for boolean fields.
between: Select this if you want to specify records where the contents of the selected field fall within a specific range. Enter the low and high bounds of the range in the boxes below.
Example: if you enter 2 and 10, records with values between 2 and 10 (inclusive) in the selected field will be returned.
This operator is available only for numeric fields.
not between: Select this if you want to specify records where the contents of the selected field fall outside of a specific range. Enter the low and high bounds of the range in the boxes below.
Example: if you enter 2 and 10, records with values between 2 and 10 (inclusive) in the selected field will not be returned, and all other records will be.
This operator is available only for numeric fields.
equal to: Select this if you want to specify records where the contents of the selected field exactly match a specific value. Enter the value in the box below.
Example: if you enter 2, records with a value of 2 in the selected field will be returned.
This operator is available only for numeric fields.
not equal to: Select this if you want to specify records where the contents of the selected field do not match a specific value. Enter the value in the box below.
Example: if you enter 2, records with a value of 2 in the selected field will not be returned, and all other records will be.
This operator is available only for numeric fields.
greater than: Select this if you want to specify records where the contents of the selected field are greater than a specific value. Enter the value in the box below.
Example: if you enter 2, records with values greater than 2 in the selected field will be returned.
This operator is available only for numeric fields.
greater than or equal to: Select this if you want to specify records where the contents of the selected field are greater than or equal to a specific value. Enter the value in the box below.
Example: if you enter 2, records with values of 2 or greater in the selected field will be returned.
This operator is available only for numeric fields.
less than: Select this if you want to specify records where the contents of the selected field are less than a specific value. Enter the value in the box below.
Example: if you enter 2, records with values less than 2 in the selected field will be returned.
This operator is available only for numeric fields.
less than or equal to: Select this if you want to specify records where the contents of the selected field are less than or equal to a specific value. Enter the value in the box below.
Example: if you enter 2, records with values of 2 or less in the selected field will be returned.
This operator is available only for numeric fields.