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

[Deepak Kumar5]

You can add filter with and condition.

Title start with-Chief

and Contains - Officer

[sammarcow]

Thanks Deep, this is somewhat accurate, but would not return examples such such "Acting VP And Chief Technology Officer", which would in the SQL provided.  

[Deepak Kumar5]

Then this is not available through UI. We have only start with or contain available not the order.

You can create a script and then query on the table with 'contains'.

Then you have to check the order that have order[Chief ] <order [Officer]

[sammarcow]

Thank you, makes sense.   This is a standard SQL search lacking the abillity to be processed through ServiceNow.   How can I put in a request for this?

[Kalaiarasan Pus]

Are you sure this won't work for your case? Did you give it a try?