Hi All
I am looking into a LCA but the elements i need to use are across different protocol versions, currently if i have 2 versions I am creating 2 queries to extract the alarms into 2 tables, however i wondered if there was a way I could do it in one query, if not can I use 2 queries on one table?
Hi Ryan,
You could filter the column Protocol using a regular expression:
Protocol A|Protocol B
Hope it helps.
Also, I need to get the alarm table/specific params in the alarm table that aren't alarmed on the alarm template of the elements, so how do I go from Get elements to that because get parameters where requires a specific protocol version to be defined
Hi Ryan,
If you want to filter by version, one option is to first apply a column manipulation and then apply the filter. With column manipulation, you can concatenate values from different columns.
For this specific case, you could concatenate the protocol name and the protocol version, for example: ProtocolName/ProtocolVersion. Then you can apply the filter (regex) as follows:
Protocol A/1.0.0.1|Protocol A/1.0.0.2
Hi Miguel,
That works to retrieve the elements of those specific versions, however from there how do i then look at retrieving a table parameter in those versions?
Thats the one bit i seem unable to work out
Hi Miguel, Will this work with column protocolversion?
Its the same protocol just different versions