NovaZyg
Administrator
When all else fails.. Read the instructions.
Posts: 789
Gender: 
|
Chris,
The Queries that the system can do are in the form of lookups (or Grids) the Grids can be customized by the end user. I.e. add, remove or change the order of fields. Add or remove Sorts (indexes). It cannot make new indexes the index must already exist.
During a lookup you can specify up to 10 of your own Filters per lookup. Filters do not get saved so this is not a static query builder. But you can print the results of the query. Filter operators are =, <>, >, <, >=, <=, and $ (sub string). A Totals button was added to the Query screen as well but has not been added to the Print yet. Also this is a drill down query. You can drill from one file to the next based on file links that again, can be set up by the users (default links are sent out with our post).
Example: Inventory lookup shows Item numbers, Description, UOH, etc. The sort order can be set to Description, or User defined or Item Number etc. You can filter for description $ RED this will show all items that have the letters RED in the description. Then from there you can add more filters to show UOH > 100. That will filter the list to show items that contain RED and have a UOH > 100. From there you can press Print to print the data, or press Totals to get totals. Then you can Drill Down to BOM. This will show you the BOM of the part you drilled down from. From there you can Drill down again to somewhere else or drill back up to the Inventory. And so on, and so on.
Hope this helps.
|
Pages: 1
Functionality of Query Module (Read 990 times)
