Using SQL LIKE Queries
My MATRIXX uses the SQL LIKE operator to perform partial string matching.
Given a sequence ABC, a SQL LIKE query matches any value that includes that sequence of characters anywhere within it. So it matches ABC rate plan, price ABC plan, and rate price ABC. My MATRIXX uses LIKE queries for many purposes, and they are all case-insensitive (upper vs lower case does not matter).
Except where otherwise noted, all My MATRIXX LIKE queries are SQL LIKE queries.
The following are search examples that build on the searches listed in the discussion about using the My MATRIXX search field.
Note: The AND operator takes precedence over the OR (OR or |) operator.
This search example finds all the Bundle or Offer objects changed since March 1, 2017 at 8:00 AM:
TS > "2017-03-01T08:00:00" AND Type = Bundle OR TS > "2017-03-01T08:00:00" AND Type = Offer
This search example finds all the Bundle,
Offer, and CatalogItem objects with a
tag Segment = Consumer. Because all template fields are
indexed, any object with a Segment field that has a value of
Consumer matches:
Type = Bundle AND Segment = Consumer OR Type = Offer AND Segment = Consumer \
OR Type = CatalogItem AND Segment = Consumer
This search example finds all the Bundle, Offer, and CatalogItem objects with the string Consumer in
the description:
Type = Bundle AND Desc ~ "[Consumer]" OR Type = Offer AND Desc ~ "[Consumer]" \
OR Type = CatalogItem AND Desc ~ "[Consumer]"