Format tab options

Use the Format tab to specify the order in which tags and data are returned and how the results of the query are presented.

The retrieval options you choose determine what appears on the Criteria tab. For more information on this tab, see Criteria Tab.

The retrieval options are as follows.

• Value based criteria (narrow tables): Data values are returned if they match certain criteria applied to the Value or vValue column. For example, if any possible value > 5000. You can also specify quality criteria for the value. For example, if the data quality for any possible value = Good.

• Tag based criteria (wide tables): Data values are returned if they match certain criteria applied to the column for a tagname. For example, if Tagname1 > 5000.

The presentation options are as follows:

• Narrow query format: In this format, there is one row for single tag's value for a particular timestamp.

• Wide query format: In this format, there is one row for one or more tag values for a single timestamp, thus providing a "wide" view of the data. To use the wide query format, you must specify the timestamp and one or more tagnames as the column names in the query syntax. The results will contain a column for the timestamp and columns for the value of each specified tag at that timestamp.