15 Posts
Toadie
8 years ago
5
Topic

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.

Get a VIP membership
4229 Posts
Kadministrator
8 years ago
2
Level 1

Hi,

where do you find seblod searches with comma? You need to set Matching mode to one of Numeric settings.

15 Posts
Toadie
8 years ago
1
Level 2

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?

4229 Posts
Kadministrator
8 years ago
0
Level 3

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

15 Posts
Toadie
8 years ago
1
Level 1

Thanks for the answer.

do you have an example for me we I had to do it then, exactly?

4229 Posts
Kadministrator
8 years ago
0
Level 2

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
Get a Book for SEBLOD