Query form
On the query fields tab, you specify the query filters for the particular product. You only need to specify those fields by which you want to limit your query.The
button on the left returns statistics and sample values for the given field.
The
comparator selection box allows you to specify "equals," "greater than," "greater than or equal to," etc.The "LIKE" and "NOT LIKE" comparison operators provide text comparison and wildcards.
Wildcards can be either Unix style ('?' for one character match, '*' for multi-character match) or SQL style ('_' for one character match, '%' for multi-character match).
If no wildcards are specified in the LIKE or NOT_LIKE query text, the system will wrap the text with multi-character match wildcards on each end.
The LIKE comparison operator is also useful for date/time and floating point data type queries. For example, you can query for date LIKE 2004-12-26 to match anything on Dec. 26th, 2004, or date LIKE 2005-10% to match Oct., 2005. Or floatValue LIKE 42.%.
The actual query value is entered in the text box. For fields where format is significant, the format of the query must match the format of the input XML documemnt. The field help button will return sample values which can indicate the format of the values.
The
button lets you add additional constraints on each field, thereby supporting ranges and bounding boxes.The
button removes that additional constraint row.You may optionally choose to have all versions of matching products returned in the result set. The normal mode is to only return the latest version of any product.
You may also specify how many results are to be returned per page.
Query results are listed in a separate window, allowing you to refine your query and resubmit.