Smart Query
Home Page
Categories: Functional
Author: Dyxon
With the "Smart Query" add-on, records for which there are no records in the table attached can be found quickly in a very simple way (not exists join).
It is also possible to use placeholders to search in date fields. Date value filters in batch jobs can thus be set in relation to the execution date.
Queries can be saved for all users, thus the same query doesn't have to be created for every user.
Features
* Easy to use: The tool is integrated into the standard filter mask. For any linked table, the mode can be changed from „exists join" to „not exists join".
* The "not exists join" setting is saved, just as all other filter settings.
* Access rights: It is possible to restrict the access to the tool to certain users.
* Date filters with placeholders: Search for current date, beginning or end of current month, period, quarter or year. Search in relation to “placeholder date” (+- x days or months).
* In case of batch jobs, placeholders are saved in the query and replaced with the corresponding date in every run.
* Save queries for all users. All users can select these queries in addition their own saved queries.
* Select saved queries on the report dialog form; there's no need to open the query selection form.
Examples of use
* Find clients for which no contact person has been entered into the system (see illustration).
* Search for items without record in the bar code table.
* Fins items without stock on hand, or without transactions within a certain timeframe
* View sales orders without positions.
* Find suppliers from whom nothing has ever been ordered.
* Easy search for overdue deliveries (today -10 days) with placeholder “d-10..d”.
* Adding a filter to your favourites in order to display sales orders with delivery date up to “today +10 days” without having to modify the filter every day.
Built for AX 2009 |
Built for AX 4 |
Built for AX 3 |
Tool |