Hi Dojo!
I would like to know if there's a way to display the element alarms within a specific view in a table. The "Get Element" query can retrieve the element alarms, but I haven't found a parameter to link it with the view or view ID.
While the alarms table can filter based on view, I need to achieve this through a query so that I can represent it in a column and bar component. Basically, I want to do the same thing as the alarm report but with the ability to filter by view.
Thank you!
Hi Yahya,
You could use the data source 'Get View Relations'. This data source will provide the View ID and the IDs of the child components (e.g. elements in the view). You could use this together with the data source 'Get Views' to display View name linked to an element (using join operators).
P.S.1 Keep in mind that an element can be included in multiple views.
P.S.2 Keep an eye on the performance of the GQI query. In order to get the view name, quite a few join operators are required.
Hope it helps.