Using the My MATRIXX Search Field

Use the My MATRIXX search field to search for any object of the price plan that you have created for your MATRIXX implementation. You can search for a specific object by name (myProduct) or by the object field values (myProduct with type=offer). The search field offers auto-completion to help search for MATRIXX object types by name (for example, BalanceClass), object type name, and one or more of its field values. The following examples illustrate the My MATRIXX search capabilities.

You use the My MATRIXX search field to search for:
  • Default MATRIXX objects, such as BalanceClass or CurrencyCode. MATRIXX tags the most common object types for searching.
  • The name of any object you have created, such as the name of an offer or bundle.
  • A specific object field value.

To start the search, start typing the name of an object or field in the search field. A list of available options is presented and updated as you type. Highlight an entry from the list using the up or down arrow, and select it with a left mouse click. You can start the search by pressing Return, or selecting the search icon.

You can also narrow the search further by using the list of operators that is offered by the search field, for example, =, !=, <, <=, >, >=, <>, and ~. Refine the search as necessary, and then start the search by pressing Return or selecting the search icon.

Search Examples lists some general types of searches that you can use. The search terms can include field names or MATRIXX object tags. MATRIXX object tags appear in the list when you start to enter a search term.
Table 1. Search Examples
Example Search Term Description
offer Find all the objects that have the text offer somewhere in them, irrespective of the case of the text. The text strings an offer overage, oFFeRed for data, and Offer38 is next would all match.
@Refer Find all the objects with a tag name that is LIKE Refer. See the discussion about using SQL LIKE queries for more information.
!Reference Find all objects that do not have a Reference tag.
ObjectId = 1 Find all objects with an ObjectId of 1.
!Reference = Matrixx-11 Find all objects that do not have a Reference equal to Matrixx-11. This search term would not match an object with these tags: Reference:String=Matrixx-1 and Reference:String=Matrixx-11. Notice the difference between this result and that in the next statement.
  • Reference <> Matrixx-11
  • Reference != Matrixx-11
 Find all objects with Reference tags other than Matrixx-11. This search term would match an object with the following tags: Reference:String=Matrixx-1 and Reference:String=Matrixx-11. Notice the difference between this result and that in the previous statement.
TS > "2010-01-31T08:00:00" Find all objects whose last modified TimeStamp is greater than Jan 31, 2010 at 8:00 AM. Internally, timestamps are stored as numbers within a numeric column, but the data indexing layer understands that they are timestamps and has special support for allowing a TimeStamp string to be passed along in the query.
  • Name ~ "offer"
  • Name * "offer"
  • Name ~ offer
  • Name * offer
All these terms search the name field for strings LIKE offer. See the discussion about using SQL LIKE queries for more information.
@ref ~ "offer" Find all objects where there is a tag name that is a LIKE reference whose value is LIKE offer.
MatrixSize > 1000 Find all decision tables with more than 1000 matrices.
NormalizerCount > 4 Find all decision tables with more than 4 normalizers.