Filter
Top Products
Text-In Query Examples
Document 800-00918 Rev E 135
12/07
B
Text-In Query Examples
Query Example I
123456
123456789012345678901234567890123456789012345678901234567890
Item Unit price Qty amount
==============================================
Coke | $ 2.20 | 1(s) | $ 2.20
Fanta | $ 2.20 | 1(s) | $ 2.20
Hotdog | $ 3.50 | 3(s) | $ 10.50
Pepsi | $ 1.95 | 1(s) | $ 1.95
==============================================
total : $ 16.85
Thank you~~
In the above text-in data, you can find that the comparison value is located at 17th (Unit
price, $ mark will be ignored automatically), 28th (Qty) and 40th (amount) characters
(including spaces) from the left. In this case, you can enter 17, 28, and 40 in each
Column field.
For example, if you want to search for Coke with a Qty (Quantity) of more than 1 and
Hotdog with an amount totaling over $8, the following search condition can be set.
Figure B-1 Query Example 1