Purchase Picklist Query
RecTrac 3.1.10.09.00
Problem
When working in Touch Screen Management and when setting up a Purchase Picklist button, how do you craft a Picklist Query?
Solution
To set up your Picklist Query, use the following format: fieldname command value (examples: inventorycode matches "bread" or receiptnumber = 1234)
To test your Picklist Query:
- Navigate to DB Inquiry (Management, System Management, Misc section – DB Query).
- Select the table that represents the items being sold and identify the field names you want to use there.
- Enter your Picklist Query in the Query box and view the results.
The below example displays inventory items with code containing the letters b-r-e-a-d.
inventorycode matches "bread"
Command examples:
= or eq (exact value match)
<> or ne (does not match exact value/not equal to),
matches (partial match, wildcarding may be necessary)
> or gt (greater than)
< or lt (less than)
>= or ge (greater than or equal to)
<= or le (less than or equal to)