Using Query Viewer to Search for and Run Queries in BFS
Definitions
- Query = A request for information from a database
- Record = A table in a database, similar to an excel spreadsheet
- Field = A column on a record
- Criteria = Filtering the data that will be returned in the query results
- Run = View the results or output of the query
1) Navigation
- From the BFS Home Page, click the 'Reporting Tools' tile
2) Search
- From the Reporting Tools page, click the 'Query' folder to access Query Viewer
- At the top of the Query Viewer page is the query search section
- Type the name of the query you wish to run in the search field (which is labeled 'begins with')
Let's use the example query: GLS_KK_ACTIVITY_LOG_TOTALS
- Click the 'Search' button
3) Run
Once you've located a query, you can run the report using one of three methods:
- HTML: Click the 'HTML' link to view the report on a separate tab or window in your browser
- Excel: Click the 'Excel' link to download the report as an Excel file
- XML: Click the 'XML' link to download the report as an XML file
This is a screenshot example of what you will see if you choose to run the output of the query as an HTML page (Run to HTML).
- It is possible to download the query results as an Excel spreadsheet from this page as well, by clicking the 'Excel Spreadsheet' link
