AX2467

Validating filters

When you are entering a filter criteria statement into an Axiom dialog, you can validate the filter to ensure that it uses correct syntax.

Filter validation is available in the various dialogs throughout the system, such as:

• Security Management
• Open Table in Spreadsheet
• GetData Function Wizard
• Copy Table Data

The validation feature only validates the filter syntax; it does not validate the logic of the filter or ensure that it will return the desired data. For example, it would detect if you misspelled a column name and allow you to correct it.

If the syntax is correct, the message "Filter is valid" appears in the dialog.

If the syntax has errors, the message "Filer is invalid" appears in the dialog. You can click this link to bring up a Filter Error message box that contains more information about the error. In the Filter Error message box, click Show Details to see the specific error message.