We would like to have the
LIKE operator from the
WHERE clause in NRQL  updated to allow for more enhanced search capabilities.
In other query languages, like Transact-SQL  there is support for wildcard literals . It would streamline queries to be able to do similar in NRQL. Bonus points for actual Regular Expression support that extends beyond the wildcard literal example.
Current Query Example:
SELECT count(*) FROM SystemSample FACET entityName WHERE ( hostname LIKE 'ws%' OR hostname LIKE 'ls%' )
Requested Enhancement Example:
SELECT count(*) FROM SystemSample FACET entityName WHERE hostname LIKE '[lw]s%'
New Relic Edit
- I want this too
- I have more info to share (reply below)
- I have a solution for this
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.