Redwood: Refine Search Using Match Item Number and Additional Filter Operators
You can search and find the exact item number and quickly filter search results using new filter operators.
Search Using Match Item Number Filter
You can search for the exact item number or multiple item numbers (entered separated by space characters) using the Match Item Number filter option. This filter option is always displayed as the first filter under the Search field. After you enter the item number that you want to search and click the Match Item Number filter, the new query engine performs the search based on the Item Number attribute and ignores other attributes that have been enabled for keyword search. The query engine matches the complete item number that’s part of the index data.
Item numbers that have special characters including embedded spaces, asterisks (*), or double quotes (") must be wrapped in doubled quotes ("). For example, to search for an item number called Spark Plug, you must enter "Spark Plug" in the Search field since it has space as the special character between two words.
You can use other filter options with the Match Item Number search to narrow your search results. For example, if you query items and you use child organizations, a search for an item number will return a row for each organization that contains the item. You can use the Organization filter to filter the results based on the master organization.
If item numbers include a prefix or a specific set of characters at the beginning to indicate a type of item, you can perform a prefix search to search all items with that prefix. For example, if the item number is 152-1234, then 152 is the prefix to indicate that the item is a server. You can use the prefix search to search for all item numbers that start with 152 by adding an asterisk to the end of the string.
Here's a list of operators that you can use with the Match Item Number filter.
| Operator | Description |
|---|---|
| Space | Acts as a separator when searching for multiple item numbers. |
| Asterisk (*) | When used at the end of search term, signifies a prefix query. |
| Double quotes (") | Wraps the item number with special characters. |
The following screenshot shows the search performed for a single item number using the Match Item Number filter option.
Match Item Number Search
The following screenshot shows the search performed for multiple item numbers using the Match Item Number filter option.
Multiple Item Search Using Match Item Number
Search Using Filter Operators
Filters used for attributes with list of values now have operators that can be applied to an attribute to refine the search. The operators are listed in the following table:
| Operator | Description |
|---|---|
| Is one of |
Select rows with one or more values when filtering. |
| Is not one of | Exclude rows with one of more values when filtering. |
| Is blank |
Select rows with the attribute value is blank. |
| Is not blank | Select rows with existing attribute value. |
Example Use Cases:
- Is one of: Show all rows where the Currency attribute value is USD.
- Is not one of: Show all rows where the Lifecycle attribute value isn't Design or Prototype to find rows that are released for commercialization.
- Is blank: Show all rows where the Temperature Characteristic attribute value is null, that is, filter search for attribute values that aren’t populated.
- Is not blank: Show all rows where the Product Type attribute has a value.
The following screenshot shows the filter operators for the Currency filter.
Select Filter Operator For Currency Filter
This feature benefits your business by the following:
- Reduces multiple interactions of search and filters to find an item by matching the complete item number.
- Searches for multiple item numbers by pasting the item numbers directly in the Search field and returns only the item numbers you enter.
- Quickly narrows down search results by using the operators on attributes that use list of values.
Here's the demo of these capabilities:
Steps to Enable
You don't need to do anything to enable this feature.
Tips And Considerations
- The Match Item Number filter is a permanent filter and can't be removed. This filter won’t appear in the View.
- Item numbers that contain spaces, asterisks, or double quotes must have double quotes added surrounding the item number.
Key Resources
- Refer to the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
Access Requirements
Users who are assigned a configured job role that contains this duty role can access this feature:
- Product Search (ORA_EGI_PRODUCT_SEARCH_DUTY)
This duty role was available prior to this update.