KB-26869: Alarm filter in an SQL query.

In the application, I have the following folder structure for alarms:

alarms\general\se01\switch01
                   \switch02
                   \…
                   \switch20

How can I set up the return all alarms from all switches of a certain substation in an SQL query?

Solution:

To do so, you must use the “%” character. For example, if you want to know the alarms from substation “se01“, use:

alarms\general\se01\%