Home : Multi Facility Query
Q14237 - INFO: Multi Facility Query

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. 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/5/2014 1:20 PM.
Last Modified on 1/23/2020 5:19 PM.
Last Modified by Scott Dorner.
Article has been viewed 4149 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article