Advanced search value range

[klaric]

Hi all,
I've installed Enhanced Search Extension because I was looking for a date range and value range search. Date range worked like a charm, but I cannot figure out how to set up the value range search. I have a custom field called "Transactions number" with different values. Is it possible to search all the accounts with number of transactions 20-60 for example?
thanks

[raym2x]

You should define a non_db field for the minimum and maximum value. Then override function create_list_query() in the module's bean.

[kenshiro]

Hi all,
I've installed Enhanced Search Extension because I was looking for a date range and value range search. Date range worked like a charm, but I cannot figure out how to set up the value range search. I have a custom field called "Transactions number" with different values. Is it possible to search all the accounts with number of transactions 20-60 for example?
thanks

Hi,

If "Transactions number" is numeric you can use the BETWEEN numeric operator.

[klaric]

Thank you both for the help, I've managed to create numeric base fields and perform search with numeric operators. there is still no value range as I don't have the full version installed but this will do the trick.