Niagara Browser Access Guide

Download 3.76 Mb.

View original pdf

Page	132/165
Date	05.02.2022
Size	3.76 Mb.
	#58172

1 ... 128 129 130 131 132 133 134 135 ... 165

Niagara Browser Access Guide
microsoft visio tutorial

Notes • Clicking on an archive’s name is the same as clicking on “text/html.”• Links “text/plain” and “text/comma-separated-values” are also identical.•
Chapter 7 Application DatabaseUsing the SQL Query FormNiagara Release Niagara Browser Access Guide Revised: August 15, 2002 7–7
/appdb/queryForm

7–6
U
SING
THE
ARCHIVE I
NDEX
The URL to access archives (only) in the appdb is:
http:///archive/index
(where

is the IP address or host name of your Web Supervisor).
Hit ENTER after typing this URL in the address bar of your browser.
This produces the archive index, as shown in Figure 7-5
. It includes all archives, but
not the four alert and event tables.
Note
You must have “admin-read” privileges to view this index. Otherwise, you just see a blank page with Archive Index at the top.
Figure 7-5
Archive index lists all archives in the appdb by STATION.SWID.
Archives are list alphabetically by “STATION.SWID.” Click on a link to see data Figure 7-5
). Use the browser Back button to return to the index.
Notes
•
Clicking on an archive’s name is the same as clicking on “text/html.”
•
Links “text/plain” and “text/comma-separated-values” are also identical.
•
Links “application/x-tridium-datax” are for future use. Such a link typically produces a download box to save as a file, but there is no current use for it.
Note that archives are often quite big. The output results may take several seconds and produce a large HTML page. The oldest data is at the topmost recent data at bottom.
Note
Archives with more than 2500 records display a warning. Seethe Tip on page If you want to import a table’s data into a spreadsheet such as Microsoft Excel, you can select “text/plain” and follow the procedure on page 5-15
, starting with step
3.

Chapter 7 Application Database
Using the SQL Query Form
Niagara Release Niagara Browser Access Guide Revised: August 15, 2002
7–7
Using the SQL Query Form
HTTP access to the appdb includes a query form, in which you can enter custom queries into the appdb using standard SQL syntax. Typically, this is useful only if you have some previous SQL experience.
Note
SQL details are outside the scope of this document. More detailed information can be found in the Niagara Framework SQL Tutorial manual, available as a link from a Web Supervisors Help Index. Refer to the Help Index section on page 8-7.
O
PENING
THE
SQL QUERY F
ORM
The URL for accessing the appdb SQL query form is:
http:///appdb/queryForm
(where

is the IP address or host name of your Web Supervisor).
Hit ENTER after typing this URL in the address bar of your browser.
This produces the SQL query form, as shown in Figure 7-6
Note
No special user rights are required to access this form, only a valid station username and password. However, be aware that SQL statements can be issued that remove data or entire tables from the appdb. Use this feature with caution.
Figure 7-6

Download 3.76 Mb.

Share with your friends:

1 ... 128 129 130 131 132 133 134 135 ... 165