To limit data by date and time, perform the following steps in the Limit Time Range field:

1. Type a Start Time using an absolute or relative time. Start time is the earliest or oldest time.
2. Type an End Time using an absolute or relative time. End time is the latest or newest time.

An absolute timestamp is an actual date and time (for example, 04/15/2023 9:00). A relative timestamp is days from today (date only; time specification not supported) designated using date and time wildcards. T represents today at midnight; T-1 is yesterday at midnight; T+1 is today up to the current time.

See Date and Time Wildcards for more information about using these types of wildcards.

To include all values or to limit the data to only the last n values for each point, selected the desired radio button in the Limit Value Count field:

• Click Export all values

- or -

• Click Only export n values from oldest to newest for each point and type a number for n.

• If the Limit time range option is unbounded, the oldest values will be exported.
• If the Limit time range option has a bound, the oldest values from that range will be exported.

Use this option to limit the operation to selected point tags.

The Limit Points field of the dialog box contains two lists:

• A table of all available points in the selected VHS
• A list of the point tags on which the operation will be limited either by inclusion or exclusion

To limit data by point tag

1. Click Select VHS to chose the desired VHS and click OK. All available points in the selected VHS will be listed in the table. If you select a VHS other than the source VHS, the source will be changed and the list of points in that service will be displayed in the table.
2. Double click on any point in the top list to add it to the lower list, or select a point and click Add.
3. Double click on any point in the lower list to remove it, or select a point and click Remove.
4. Click Reset to clear the included points list.
5. Select Exclude Point List to exclude any selected points from the lower list (but not remove them from the list).
6. Select Continue from this tag by Short ID to select points from a specific point forward. The range is based on the Short Point ID. For example, if you select point ID 00000100, all points with an ID >100 would be included in the selection.

Use the Include and Excude filters to limit the point tags list based on long point tag wildcards.

If you want to use wildcards to determine the list of point tags on which to perform an operation, use the Long Point Tag Wildcard Limiting option. The key identifier here is Long Point Tag and the correct tag string format to use is the Long Tag String format or Site.Service:LongID.

To limit point tags using a wildcard criteria, do the following:

1. In the Include box type a semicolon-separated list of point tags in Site.Service:LongID format using the wildcard character (*).
2. In the Exclude box type a semicolon-separated list of point tags in Site.Service:LongID format using the wildcard character (*).
3. Click Fetch Points to populate the point tag list using the specified filters.

Usage Notes

• Both filters are semicolon delimited.

• The Include list specifies a wildcarded list of long point tags to include. All tags that meet the Include criteria will be included in the point tag list. For example, MYSITE.UIS:AR*; MYSITE.UIS:MES* would return points with a Long Point Tag starting with MYSITE.UIS:ARROW_, MYSITE.UIS:ARROYO_, MYSITE.UIS:MESA_, MYSITE.UIS:MESQUITE_

• The Exclude list specifies a wildcarded list of long point tags to exclude in the same format. All tags that meet the Exclude criteria will be excluded from the point tag list.

• If you have already added points to the points tag list, they won't be removed when you click Fetch Points. Any wildcarded points will be added to the list. If you only want points that match the wildcard criteria, first Reset to clear the list.

• You can specify both an Include filter and an Exclude filter. The following rules determine if a long point tag is included in the point tag list:

1. If a tag matches the include filter, the tag will be included.
2. If a tag matches the exclude filter, the tag will be excluded.
3. If no filters are specified, all tags will be included.
4. If a tag matches both an include and exclude filter, the tag will be excluded.

• As soon as one of these rules “matches,” the wildcard limiting will stop processing the remainder of the rules.