Help with Search - Floating Point Number

[nynaevelan]

Originally Posted by Starson17

I set up a floating point field, and like you #price:"=0.0" gave both empties and the zeroes. So

not #price:"=0.0"

gave me everything that had an entry. I assume that's what you wanted, so your problem lies in the saved search.

I'd suspect the combo of a space and a hierarchical period as causing your problem. Have you tried simply saving without a space in the name?

Actually I am trying to set it up to find the empties to make sure I have entered the price for each book. Now I have to try user_none's suggestion to see why it is not working as a saved search.

[chaley]

Currently, num_col:true and num_col:false are equivalent to num_col:!=0 and num_col:=0. This was done because ratings (which are really integer columns) require that behavior. However, that behavior is wrong for non-ratings numeric columns.

I have changed search to implement the following:

- ratings columns: zero is indistinguishable from not set. Searching for false will find books without a non-zero rating. Searching for true will find all books with a non-zero rating. Searching for =0 is the same as searching for false. Searching for !=0 is the same as searching for true.

- non-ratings columns: zero is distinguished from not set. Searching for false will find books with no value. Searching for true will find books with a value, including the value of zero. Searching for =anything will find books that exactly match "anything". Searching for !=anything will find books with no value or a value not equal to "anything". Searching for <anything (>anything) will find books that have a value less than (greater than) anything, but will not find books that have no value.

These changes will be in the next release.


As regards the saved search issue: I cannot duplicate it. I have a custom column named #myfloat. I entered the search

#myfloat:"<10.1" and not #myfloat:"=0"

It works. I then created a saved search named "A.Foo Bar" and turned on hierarchies in searches. Expanding "A" and clicking on "Foo Bar" resulted in the same answer as I got when I entered the search. To further test, I used the green arrow button to copy the saved search text to the search box, got what I expected to see, and got the same answer.