A change has been made to how exports can be qualified. A new set of qualifiers have been added that allow for a greater range of options when trying to qualify exports. These options work in conjunction with the existing ‘is’/’is not’ drop down. The new options are:
- Equal to NULL (Equal to Zero for numeric fields) – Will look for fields that have a null value (are blank) or have a value of zero for numeric fields.
- Equal to – Will provide a single text field to enter a value. This will return only records with an exact match to what you have entered..
- In between – Will provide a from and to field. Enter the values you are looking for results between. The entered values are included in the results that are being matched.
- Greater than – Will provide a single text field. Enter the value you wish to find higher values than into this field. The entered value is not included in the results that are being matched.
- Greater than or equal to – Will provide a single text field. Enter the value you wish to find the value of or higher values than into this field. The entered value are included in the results that are being matched.
- Less than – Will provide a single text field. Enter the value you wish to find lower values than into this field. The entered value is not included in the results that are being matched.
- Less than or equal to – Will provide a single text field. Enter the value you wish to find the value of or lower values than into this field. The entered value are included in the results that are being matched.
- Any one of – This will allow a number of values to be entered. If any of the entered values are found that record will be returned. When using this qualifier select the button with the three dots to launch the Qualifier selection screen.
- The Qualifier Selection screen has the following fields and buttons:
- Text field – Enter a value that will be matched.
- Add – Select this to add additional values to be matched.
- Remove – Select this to remove a value from those to be matched.
- Ok – Save the entered values
- Cancel – Cancel any unsaved changes
As a result of these changes any existing stored exports will have there qualifiers updated in the following way.
- Both the From and To fields are currently blank – It will be set to the ‘Equal to Null’/ ‘Equal to Zero’ option.
- Both the From and To fields are filled in with the same value – It will be set to the ‘Equals to’ option and the field filled in with the value that was originally in both fields.
- Only the From field has a value filled in – It will be set to the ‘Greater than or equal to’ option and the value that was in the From field will be used.
- Only the To field has a value filled in – It will be set to the ‘Less than or equal to’ option and the value that was in the To field will be used.
- Both the From and To fields are filled in with different values – It will be set to the ‘In between’ option and the values in the To and From field will remain in the To and From fields.