Hello Experts,
I have an array set up with a list of different site codes, for example:
SiteA01
SiteB01
SiteB02
SiteC01
...and so on
I also have an action to pull rows from a SQL server and I want to add a condition to find all rows where any of the array values are present anywhere my "summary" column. The summary column is varchar and the content varies from row to row. Here are a few examples:
Update firmware on SiteC01.hostname.com
2hr downtime for UPS maintenance
WLC update at SiteA01
siteb01 switch upgrade
I would only expect to capture rows 1, 3 and 4 in this case.
Can anyone advise if it is possible to use an expression in the contains condition to achieve this?
