How can I browse notifications in Relational Datasets?
I want to see just time and subject in WebPart.
Is there any query to PI database?
The above solution will give you the name, start and end time for notifications and event frames if you are using PI Notifications 2016 R2 or newer. If you are using older PI Notifications I would consider just upgrading now.
We created a custom Active X object to use ProcessBook for showing notifications in a display but I don't have the details for how this is done in the background. I assume this solution will not work if we upgrade to the newest PI Notifications.
Today I wouldn't reccomend creating new solutions to the old PI Notifications since there are a lot of changes in the newer version and your solution might not work after you upgrade.
If you have the newest Notifications installed you can easly just query for the event frames genereated by the notification:
SELECT Name, StartTime, EndTime
SELECT TOP 100 *
ORDER BY StartTime DESC
ORDER BY StartTime
This is using PI OLEDB Enterprise.
Thanks Andre, this works...
But how to show notification time and subject (not Event Frame)?
Thanks, I'll test this after system upgrade.
Retrieving data ...