I’m baffled! Running a simple PageView query against one of our custom attributes (search_query) and not getting accurate results… clearly!
Using the query “SELECT * from PageView where search_query like ‘%lname=|%’”
This should return results that have nothing in the “lname” parameter. However the results being shown to me in the query builder has results like “lname=ralston|”, but should only be returning results with an empty lname parameter (ex. “lname=|”).
Why is this query not matching correctly?