PI SQL Client

Showing 24

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 3 months ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

1 VOTE

PI SQL Commander's Template-Specific Data Model Wizard should include a search/filter to make locating templates in the template selection step easier.

PI SQL Commander's Template-Specific Data Model Wizard should include a search/filter to make locating templates in the template selection step easier. Currently for AF databases with many templates, a user has to use a scroll bar in order to find...

Bethany Jewett 6 months ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

1 VOTE

PI SQL Client to support all types of ResultSets

Currently the PI SQL Client JDBC only supports reading the resultset in a forward manner (ResultSet.TYPE_FORWARD_ONLY). We would like to have the feature to support all types of Result sets like ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SC...

Diwakar Hariharan 9 months ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

2 VOTE

Access AFTables with RTQP

Add possibility to read AFTables using RTQP Engine

Carlo Pedroli about 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

1 VOTE

Table-Valued Function

Currently it is not possible to define filter definitions for Table-Value functions.With DataLink I'm able to define to build an average for a process value by using a defined filter method. e.g. calculating an average current of an engine while t...

Christian Benitz over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

48 VOTE

Expose Event Frame Annotations in PI SQL DAS (RTQP Engine)

I would like the ability to access event frame annotations using PI SQL Client, in the same way as in PI OLEDB Enterprise.

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 12 Declined

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 Admin's to generat...

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

10 VOTE

Allow Direct PI Data Archive Server exposure

Extend the capability of PI SQL Client to connect directly to PI Data Archive Server

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 2 Declined

21 VOTE

PI SQL Client to make use of the RecordedValue method and Retrieval Modes for the GetValue transposed function

When making use of the GetValue transposed function when creating a new Template specific Data Model, we can see that under the hood it makes us of the AF SDK call AFData.InterpolatedValue method to capture the data at a specified timestamp provid...

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 No Status

2 VOTE

Let PI SQL Client access SQL Tables

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 Declined

Please enter your email address

FILTER BY CATEGORY