KB-26869: Alarm filter in an SQL query.

Question:

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\%

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *