I have a small problem but this has great impact.
I have a text field which is stored decimal. So with point. And we live now times in Europe and because you do it with a comma. ^^
We can represent the value as a comma in the list (Table).
And in the search field working with commas input.
Thank you already for your help.
Hi,
where do you find seblod searches with comma? You need to set Matching mode to one of Numeric settings.
I've done everything.
an example:
The following values are in the database. Field Seach has Numeric > or =
2.85
10.15
3.00
7.05
5.00
Now I'm searching for 7,55 the result is
10.15
7.05
that's wrong.
Am I doing something wrong?
Problem is that search is done using mysql and mysql only considers numbers with dots as decimal. You could use
http://www.seblod.com/store/extensions/19157
to do a search and replace on searched number so that , is replaced with . before it is used in query
Thanks for the answer.
do you have an example for me we I had to do it then, exactly?
Sorry, no example, I can only give you general direction but you will need to create final solution on your own. If you need detailed solution you can use
http://www.seblod.com/store/services
Another option is that you tell your users to use dot notation in search, there is a plugin to force them to enter dot separated numbers (decimals):
http://www.seblod.com/store/extensions/1866