I noticed that today the nrql matching on a LIKE clause appears to have changed, as in: doesn’t work as documented.
I have a couple of search-to-conversion funnels on webshops running which worked perfectly until yesterday (2021-4-22)
But as of today queries like:
FROM PageView select funnel(session, where pageUrl like '%/search/%' AS 'search')
stopped matching pageUrl values such as
above query is just a part of the actual query.
the query-builder suggests that
LIKE '%/something/%' only match queries with a percentage char in the actual URL whereas according to the NRQL docs a LIKE clause should behave just like the ANSI_SQL equivalent.
could it be that a regression was introduced in the query-parser? Or has the syntax for LIKE clauses changed without updating the documentation?