As a PI SQL Framework end user, I need to be able to distinguish between event frames generated by PI Batch Interfaces from different sites or data sources by filtering my query on the name of an event frame extended property.
PI Batch Interfaces store the unique ID of the data source as the name of an extended property in the event frames they generate. When multiple PI Batch Interfaces write to the same AF Database, the extended property name can be used to distinguish between event frames from different data sources or sites.2 votes
As a PI SQL Client OLEDB user, I would like to have the TIME(), DATE(), LOCALDATE() and TOLOCALDATE() functions available in order to construct datetimes for my queries.
These functions were available in PI OLEDB Enterprise, but are not available in PI SQL Client OLEDB.13 votes
Please add PI TagMedian function in AF analysis like PI TagAvg and PI TagMean. Currently Median function is available but it cannot be applied for archive values of PI Tags during particular time range5 votes
Planned for 2018 R2. The Median function will support analytics array introduced with the 2018 release.
- Don't see your idea?