Managing Master Data with webMethods OneData 10.5 | Managing Master Data with webMethods OneData | webMethods OneData User’s Guide | Filtering Data in OneData | Filtering in OneData | Search Operators
Search Operators
OneData uses standard SQL search operators to perform basic and advanced queries. The following table describes the advanced filtering options.
Table 5. Search Operators Table
Data Type
To return records where the field (column) value…
Use filter….
Case- Sensitive
Contains any value
Contains no value
String No
Does not match a value
Matches an exact value
Exact Phrase Match
Contains multiple values
All of the Words
Contains a single value
One of the words. Word order does not matter.
Wildcard search
% (For example, T% returns all rows where the specified column contains T plus any characters.
String Parent Field
Does not contain the specified value
NOT IN. Only for parent object filters.
Numeric and Date N/A
Matches an exact value
Does not equal
Is less than/before
Is greater than/after
Is less than or equal
Is greater than or equal
Is between a range (not inclusive)
Select check box and enter beginning and ending value.
As of date
Only for temporal objects.
Is true
Select check box
In filters, the relational columns, such as, foreign-keys, may be configured to display values in either a lookup (pop-up window) or in a list box. If the column filter displays as a lookup, you can select multiple values as search criteria. However, if the column filter is a list box, you can only select one value to apply in the filter.
Specify din the format Personalize > Preferences.
* To apply a filter on records
1. On the Menu toolbar, click Manage > Manage Data.
2. Navigate to the object you want to edit or view and select it.
Note: Ensure that advanced filtering is enabled on the Shortcut toolbar.
3. Enter search criteria in the relevant fieldTable 5.
*Narrow the results for an and query by entering the required criteria in multiple fields. OneData returns search results for records that meet all of the specified criteria.
*Create a complex query in the Explicit “Where” Clause field. Use the column selector and arrows to add a column to the query.
*In reference columns that are defined as a lookup, you can select multiple values from the lookup to create an or search condition. Select the filter values and click Save Values to add the values to the query. Click Clear Value to deselect entries.
Tip: Click Save Filter to save the filter for future use (not available in Default mode).
*The # symbol beside a column indicates that a filter must be specified in the field.
4. Click Apply Filter.
OneData returns the records that meet the specified criteria. In Nova mode, for network recursive objects, the number of records that meet the specified filter criteria is also displayed beside the object name in the tree view.

Copyright © 2011-2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.