Sage Software MAS 500 Welding System User Manual


 
Ad Hoc Queries
Ad Hoc queries allow the user to define fast, simple queries that may also have a
parent/child relationship with other queries. The resulting data from Ad Hoc queries is stored
in the SalesLogix database, but in an XML format. This prevents the data from being used to
create SalesLogix groups, or other SalesLogix functions that require the data to reside in
individual fields. The data from Ad Hoc queries is viewed view the Query Data Viewer
described in the next section.
Ad Hoc Query Data Viewer
The results of the Ad Hoc queries are stored in the SalesLogix database in an XML format,
and the Ad Hoc queries with the Account Reference parent are displayed in the ERP Data
tab.
To view the data stored by these queries the user can double click on any one of the items
listed and the Ad Hoc Query Data Viewer will open.
The Ad Hoc Query Data Viewer displays all of the available XML data for the selected
account. The root queries are displayed on individual tabs in the viewer. Parent/Child data is
displayed in the Query Data Viewer in a hierarchical view.
Page 34 of 45