Ideas

Showing 38 of 5194

Return row number from PI SQL Client calls

It would be useful to be able to access a specific row from a PI SQL Client call. For example if I query muiltiple attributes indicating some KPI ordered from highest to lowest returning 1000 rows, I might want to show only the top 10. The TOP fun...

Simon J. Dyson over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

9 VOTE

Allow the SDK connection priority for the RTQP Engine to be configurable

The RTQP Engine is currently only able to connect to the Primary Data Archive to retrieve data, regardless of the SDK Priority settings. The “PreferPrimary” connection priority is hardcoded into the RTQP engine and cannot be modified. For users wh...

Derek Wong over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 2 No status

8 VOTE

Add support for nested SELECT statements in PI SQL (RTQP)

The current version of PI DAS (RTQP Engine) does not support nested SELECT statements. This is a rather dire oversight, given that the older PI OLEDB Enterprise query engine does support nested SELECT statements. A very useful application of nes...

Guest over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 No status

7 VOTE

Provide a PI SQL Commander Lite Standalone Download

Currently, PI SQL Commander Lite is bundled with PI SQL Client, PI OLEDB Enterprise, and PI ODBC Driver. It is a very useful tool for PI OLEDB Provider, which does not bundle it. To use it, another provider needs to be installed to obtain PI SQL...

Guest over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 2 No status

3 VOTE

RTQP 2023 SP1 SQL database execution script to be made available for download from customer portal

We might still need the SQL script because when the installer failed to run successfully for some reason, the SQL scripts won't be present. AF SQL database execution script used to be available to download from customer portal until version 2018 S...

Ee Sheing Lee almost 2 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 No status

5 VOTE

Add element reference information to to RTQP tables.

In OLEDB Enterprise, we could find element references by type. Currently, this information is not exposed in RTQP. It would be helpful to be able to identify which type of reference an element is using. One use case is for PI Adm...

Brent Bregenzer over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 Declined

5 VOTE

Enable SSO on PI SQL client to connect and authenticate to PI SQL DAS(RTQP engine)

Currently PI SQL clients only support Kerberos & basic authentication. Enabling SSO on PI SQL client to connect and authenticate to PI SQL DAS(RTQP engine) would make PI data accessible from anywhere.

Sayan_Chowdhury over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

5 VOTE

Alert user when the interface discards values

Example: When using a distribution tag, the number of tags returned and number of values sent to PI can be mismatched, due to missing aliases or data that does not need to be collected. It would be helpful to identify what values are droppe...