Widget Query for Muted Nodes w/ Search

Question

Hello, 
 Found some good posts but not exactly what i need. The top custom query works but i want to utilize the bottom "Search" option so that in the search window i can type in a full or martial server name, etc and it will list all based on the "like" syntax. Do i need to assign some variable to = ${SEARCH_STRING} ? If so can someone provide an example?

Seashore · Answer

This could be an example for the first part: 
 SELECT
 T2.Caption
FROM Orion.AlertSuppression AS T1
Inner JOIN Orion.nodes as T2 ON T1.EntityUri=T2.Uri
ORDER BY 
 T2.Caption ASC 
 and adding a version for the search box, it could look like this: SELECT
 T2.Caption
FROM Orion.AlertSuppression AS T1
Inner JOIN Orion.nodes as T2 ON T1.EntityUri=T2.Uri
WHERE
 T2.Caption LIKE '%${SEARCH_STRING}%'
ORDER BY 
 T2.Caption ASC