Be able to use RTQP to access PI Points and Config strings (DA Directly)
Use case:
create a dashboard that lets me know the amount of bad data (tags) mapped to our AF.

(eg. “Bad Input”, “Calc Failed”, etc)

Our system has numerous tags and it is impossible to monitor them one by one.

The RTQP engine has allowed us to query massive amount of AF Attributes to get their current values easily.

Some AF attributes have been excluded in our system. For that case, we are not interested whether or not the values are bad.

Hence I would like to know if I can filter out any AF Attributes that are ‘excluded’ in my query.

The resulting query will give me current values of the attributes that are bad.

Without knowing the tag names, it is impossible to rectify those bad inputs. We would need to open up AF again and trace the AF path to find out the tag names.

It also limits our ability to deep dive on root cause using the same query. (eg. Multiple tags from the same interface are showing bad inputs – this is impossible without knowing the tag names).

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 provided in the transposed function. This method does make use of any Retrieval Modes.

It would be good for this GetValue transposed function to make use under the hood of the AF SDK call AFData.RecordedValue method instead since this method offers the possibility of using Retrieval Modes like "AtOrBefore" which is really useful to capture the last archived value before the timestamp provided.

This would provide a more faithful aspect of the behavior of the process.

When you create a template-specific event view, event frames based on derived templates are also returned. However, attributes which are overridden in the derived template return empty. This means more complicated queries using UNION ALL must be used.

As a user, when I use a derived template with an overridden attribute, it is often because I need to change the way that attribute is calculated in a subset of cases. However, I still want to be able to create a view easily for all of this data.

For example, I have a "Batch" template with "Pounds Produced". However, for a specific case, the "Pounds Produced" calculation needs to be different. I still want to easily be able to create an event view for all my batches.

Example Scenario:

We want to know the Specific Electricity Consumption (kWh/mt) over a time period (selected by users).

Specific Electricity Consumption = (Electricity Consumption(kWh)) / (Raw Feed Consumed(mt))

Where, Electricity Consumption (kWh) and Raw Feed Consumed (mt) are both attributes with PIPoint data reference, using value retrieval method: TimeMethod = Time Range; TimeRangeMethod = Total; EventWeighted

Then, Specific Electricity Consumption is attribute with Formula data reference, simply: A=Electricity Consumption; B=Raw Feed Consumed;[A/B]

So, on PI Vision, it can display the specific electricity consumption with the correct values. However, if we query through PI Web API for our own webpage, it is not able to do so.

For the specific electricity consumption attribute, we are only allowed to use GetValue and GetInterpolatedValue, which does not provide us the correct value.

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 Commander Lite indirectly.

The version of PI SQL Commander Lite that is bundled with each provider is the latest version of PI SQL Commander Lite at the time of the provider's release. This means that the latest versions of each provider could have different versions of PI SQL Commander Lite bundled with them.

Manageability of PI SQL Commander Lite would be easier if it were a standalone download.