I would want to get active alarms for a specific View in my LCA, and tried using the “Get Alarms” data source and filter it based on View, but that data source does not have the column “Views”. Not available in select as well.
Is there a way to add this column or do we need to write a new GQI for it.Capture.JPG
Hi Hari,
There is a similar question about this topic:
Get alarms for filtered elements by view
I believe it should cover your use case.
Hope it helps.
Hi Hari,
Between Get Alarms and Get View Relation you can use the columns ‘Element ID’ and ‘Child ID’ for the join operator respectively.
Between Get View Relation and Get View you can use the columns ‘View ID’ and ‘View ID’ for the join operator respectively.
Please let me know if this helps, otherwise I can add some screenshots with the GQI query.
Hi Obregon,
Thanks for the response.
I find that the “Child ID” column in “Get View Relations” is actually the Service ID inside that View and “Element ID” in “Get Alarms” is the Element ID inside that service, so join is not working here
Pls let me know if we need to write a custom adhoc datasource for this
Hi Hari,
Indeed, if you are planning to filter based on alarms linked to services, you will need to use an ad-hoc data source. In the following question there is an answer with a summary of adhoc data sources that you can take a look to develop your adhoc data source:
https://community.dataminer.services/question/how-to-create-adhoc-data-source-for-retrieving-alarms-low-code-app-gqi/
Hope it helps.
Hi Miguel,
The above topic is somewhat similar to my question, but i see we could not join either the “Get View Relation” and “Get Alarms” or “Get Views” and “Get Alarms” because there is no common columns between them. Any suggestions on this