wildcard search scripting and UI

[sammarcow]

I need the equivalent of the following mssql search in a GlideRecord, or a way to do this in the UI

select *

from user

where title like '*chief*officer*'

In the above example records from table user having title "Chief Technology Officer" would be returned but records with title "Officer and Chief Advisor" would not.

If there is a way to provide a regex to a query that would also work.    

Message was edited by: William Sammarco grammar corrected

Message was edited by: William Sammarco added alternate solution path

[Kalaiarasan Pus]

In the filter Title > contains > Chief OR Title > Contains > Officer

[sammarcow]

This would return "Officer and Chief Advisor"

[Kalaiarasan Pus]

If you want to use this in gliderecord, form this condition on UI

Right click on the filter link, and select 'Copy Query'. Now you can use this query in encodedQuery of GlideRecord query.

[sammarcow]

This would return "Officer and Chief Advisor"