What is "TE" in the PIPoint exdesc attribute value of "P1=TE"?

I know that this is passing a parameter value to the SQL query, and I can see where the parameter is being substituted into the query (via "?"), but I am not sure what "TE" is. Is this an alias for some value, and if so where is the alias stored?

Based on the query, I would expect this to be a datetime value.

Parents

0 Community User over 1 year ago

Hi (Missing Content) ,
The definition for the RDBMS placeholders can be found from here.
Placeholders for replaceable parameters (aveva.com)
What placeholders can be used with the PI Interface for RDBMS?

TE - stands for Timestamp End. Used in recovery mode.

RDBMS splits time range into several smaller chunks when backfilling. Using TE in this case is generally more favorable. If using T1=TS as your backfill query, RDBMS interface will query the same set of data with only the start of each interval updating (for example, intervals will be done as *-48h to *, *-47h to *, *-46h to *, etc.). Using TE will give you *-48h to *-47h, *-47h to *-46h instead.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Community User over 1 year ago

Hi (Missing Content) ,
The definition for the RDBMS placeholders can be found from here.
Placeholders for replaceable parameters (aveva.com)
What placeholders can be used with the PI Interface for RDBMS?

TE - stands for Timestamp End. Used in recovery mode.

RDBMS splits time range into several smaller chunks when backfilling. Using TE in this case is generally more favorable. If using T1=TS as your backfill query, RDBMS interface will query the same set of data with only the start of each interval updating (for example, intervals will be done as *-48h to *, *-47h to *, *-46h to *, etc.). Using TE will give you *-48h to *-47h, *-47h to *-46h instead.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data