Data Grid Setup Properties - Data Binding tab

Displays the available tables and views of SQL Server database.

Tip

: In the search box, enter text to quickly filter the column names.

Adds the selected column to the data grid object.

Use the

Shift

or

Ctrl

key to select multiple columns.

Adds all columns of the selected table or view to the data grid object.

Removes the selected columns from the data grid object.

Use the

Shift

or

Ctrl

key to select multiple columns.

Shows the name of the selected column.

Shows the data type of the selected column.

Tip

: The following column types are not supported: hierarchy, geography, and geometry.

Double-click the cell to create a filter of the selected column.

If the data type is

datetime

,

datetime2

,

smalldatetime

,

date

, or

time

, you can select

Set as time period on toolbar

to show it on the toolbar and dynamically set the time period at runtime.

Only the records that meet the filter criteria are displayed on the data grid object.

Tip

: To filter cells with empty values, use

Equals ''

. Data types

text

and

ntext

don't support

Equals

or

Not equal to

filters in SQL Server databases.

Sorts the selected column. You can apply multiple sorting orders at the same time. A number is displayed besides the sorting order and indicates the sorting level.

Sort precedence is determined by the sorting level. For example, if you want to sort by

Severity

and then

TicksTimeStamp

, apply the first sort to Severity and the second sort to TicksTimeStamp.

Select

X

to remove the sorting.

Configures the maximum rows to show on the data grid object.

The maximum capacity is 50,000.

Shows the time and date according to the time zone of your local computer.

Tip

: It's recommended to select this check box when

datetime

,

datetime2

, and

smalldatetime

data types are logged as Coordinated Universal Time (UTC) in the database.

Depending on the selected data source, it displays the available tags of data log models, DataLogPro, or the FactoryTalk Historian SE server.

Tip

:

Adds the selected tag to the data grid object.

Use the

Shift

or

Ctrl

key to select multiple tags.

Adds all tags to the data grid object.

Removes the selected tags from the data grid object.

Use the

Shift

or

Ctrl

key to select multiple tags.

Shows the name of the selected tag.

Shows the data type for a tag.

If the data source is data log model, the options are

Numeric

or

String

. Select the correct data type of a tag for it to show on the data grid object.

Double-click the cell to create a filter of the selected tag value.

Only the records that meet the filter criteria are displayed on the data grid object.

Tip

:

To filter cells with empty values, use
Equals ''
.
To filter special characters % * [ ] in string tags, enclose the special character with brackets ([]). For example, to filter abc*, enter
abc[*]
in the filter.

Sorts the selected tag values. You can apply multiple sorting orders at the same time. A number is displayed besides the sorting order and indicates the sorting level.

Sort precedence is determined by the sorting level. For example, if you want to sort by

Tag1

and then

Tag2

, apply the first sort to Tag1 and the second sort to Tag2.

Select

X

to remove the sorting.

Sets the time period for when the tags are recorded. The object will show the tags recorded during that period.

Sorts the overall tag values by time in the ascending or descending order.

Shows the interpolated data generated at a certain time interval.

During the historical data querying, there may be intervals with no raw data in the database. Rather than values from actual historical records, interpolated values are mathematically interpolated at a given interval, and thus not actual archived data.

Configures the maximum number of records returned by the data log or historian server. After being filtered and sorted, the records shown on the data grid will be less than or equal to the configured number.

The maximum capacity is 50,000.