Multi Facility Query allows data to be retrieved from multiple facility databases. Data can be viewed on the screen, copied to the clipboard, or exported to Excel.
Only Super Users and Managers with the Use Multi Facility Query (if Manager) User Setting are allowed to access Multi Facility Query.
Example: Show all results for regulatory parameters for Facilities in New Mexico:
1. Set the Date Range
2. Set the Output Format to Narrow. (see examples below of the different output formats)
3. Choose the Facilities Where Clause Option.
4. Click Add Criteria, choose Field SITESTATE, operator "=", and value to NM and click OK. This will build the WHERE clause that will query the OPSROOT.FACILITY and FACILITY_I Table.
5. Click Add Criteria in the Variables section. Choose GlobalGroup, operator "=", and value of 'REG'. Note: See Variable Edit, Global Ids for information on setting up the Variable Global fields.
6. Click Get Results.