search for the price range

[effa]

I have a search layout with many fields that may be used for search.

I need to add search for the price range. I.e. I have a field named "price" and if I switch to find mode and enter smth like: 100...150 in there it works. However I need to make it more user-friendly: add 2 fields to search layout with price range: FROM and TO.

 

I tried to make smth like:

Enter Find Mode []
Set Field [db::price; db::start_price & "..." & db::end_price]
Perform Find []

However it does not work.

How can I script this properly?

[eos]

If the two search fields are not defined with global storage, their values are not available after you've entered Find mode.

 

You either need to capture the field values into variables before you enter Find mode, then use the variables to define the search range, or (preferably) use global fields and refer those.