AdvancedRecordSearch
Query:
iVend Retail– Advanced Record Search
What is the Advanced Record Search feature on Search Screens?
Response:
The Advanced Record Search provides an easy and straightforward way of searching against multiple columns to locate data by typing the filter criteria in the panel editor and highlighting the search results.
Note: The search panel is displayed above the grid consisting a search box and control buttons and can be triggered using the Ctrl+F keyboard shortcut.
Let us try searching for a Product using the “Advanced Record Search” feature and use it to our advantage.
Log into the iVend Management Console and navigate to: Operations > Inventory > Product – the Product Search window appears.
Figure – Product Search Scree
In its simplest form, a search criterion consists of a single word. If you want to search for a string containing a space character, specify this string in quotation marks. Without quotation marks, words separated by the space character are treated as individual conditions.
Note: You can search against a specific column by preceding a search string with the column's display name plus a colon character.
ColumnDisplayName:SearchString (Note: no space in between)
Instead of the complete name, it is possible to partially specify the display name, using the initial characters of a column's display name. A search will be performed against the first column whose display name starts with the specified substring. If you want to search against a column whose display caption contains space characters, specify the column's display caption in quotation marks.
If the search string contains multiple conditions separated by space characters, and at least one condition defines a search against a specific column, only records that match all of these conditions are shown (i.e., the conditions are combined by the AND logical operator). If there is no column specification, records that match at least one of these conditions are shown (i.e., the conditions are combined by the OR logical operator).
Precede a condition with "+" to display only records that match this condition. The "+" specifier allows you to implement the logical AND operator. There should be no space character between the "+" sign and the condition.
Precede a condition with "-" to exclude records that match this condition from the result set. There should be no space between the "-" sign and the condition.
Examples
· Select records that contain the "shoes" string in any search column.
Shoes
Figure – Product Search Screen
· Select records that contain either "adidas" OR "men" OR "shoes" strings in any search column.
Adidas Men Shoes
Figure – Product Search Screen
· Select records that contain "Mens Adidas" in any search column.
Mens Adidas
Figure – Product Search Screen
· Select records that contain both "shoes" AND "Mens Addidas" in search columns.
"Mens Addidas “+”shoes"
Figure – Product Search Screen
· Select records that contain "Bag" in the "Description" column AND also contain "Luggage" in any column.
Description:Bag Luggage
Figure – Product Search Screen
· Select records that contain "Men" OR "jean" in any column however exclude records that contain "shoes" in any column. Therefore, records having "Men" or "Jean" and having "Shoes" in the same records will be filtered out.
Men jean -shoes
Figure – Product Search Screen
· Select records that contain "Bag" in the "Product Group" column (or column starting with Product) AND "case" in the "Description" column (or any column starting with "desc").
Product:Bag Desc:case
Figure – Product Search Screen
· Select records that contain "Bag" in any search column however exclude records that contain "case" in the "Description" column (or any column starting with "desc").
Bag -Desc:case
Figure – Product Search Screen
Keyboard Operations
Ctrl + F - Invokes the Find Panel.
Esc - Closes the Find Panel.
Down Arrow - Moves focus from the Find Panel to the grid's data area.
Note:
· Searches performed using a Find Panel are case insensitive.
· When searching, the system filters records and displays only those records that contain the entered search string. If you clear the search string and perform a clean search again, all the records are displayed again.