Report Query Options
To enhance reporting capabilities, Denali includes querying functionality in several of the reports. This query ability allows you to report information based on specified search criteria. Keep in mind that depending on the integration settings for the module, some query options might appear differently or be unavailable. Refer to Setting Up the General Ledger Relationship with Other Modules for more information on how your integration settings might affect the query ability for reports.
In the report window, the fields on the Search For tab provide a means to further define your report query. For example, in the GL Audit Trail Report window the Search For fields have the options of Amount, Batch Number, User ID, or Module. One way to search for specific Batch Number information for this report is to select contains from the operand (query option) drop-down list and enter a portion of the batch information. Depending on the report, different search options are available.
The query fields (comparison operator) have the options of equal to, not equal to, greater than, greater than or equal to, less than, less than or equal to, and contains. The information in this table explains the differences of each query option (operand).
Operand  
Field  
equal to
The information returned is equal to the entered value or the selected field’s value.
not equal to
The information returned is not equal to the entered value or the selected field’s value.
greater than
The information returned is greater than the entered value or the selected field’s value.
greater than or equal to
The information returned is greater than or equal to the entered value or the selected field’s value.
less than
The information returned is less than the entered value or the selected field’s value.
less than or equal to
The information returned is less than or equal to the entered value or the selected field’s value.
contains
The information returned contains the information in the Search For field.
Once you select the search for option(s) and desired comparison operator(s), enter the amount to use for comparison. If you leave the criteria fields blank, the report will not appear with the enhanced query data. If the report does not provide the information you’re looking for, you can select the Reset button to reset the query options to the default settings and try different query parameters.
Published date: 04/08/2020