Help with Search - Floating Point Number

nynaevelan · 04-12-2011, 10:13 AM

Hi:

I am trying to create a saved search based on a floating point number custom column. I tried #price:false and #price:<0 but neither choice gives me the results I am looking for. How do I do a search on this type of column in order to get the books that do not have any data in this field??

Nyn

theducks · 04-12-2011, 10:20 AM

Have you tried combinations like:
not #price:true, not #price:>.01
(I had a similar issue with Tri-state, where I wanted to find both blank and false. chaley put me right

)

nynaevelan · 04-12-2011, 10:29 AM

I just tried them both and both gives me the ones with no price plus all the ones with a price of zero.

theducks · 04-12-2011, 10:45 AM

Quote:

Originally Posted by nynaevelan

I just tried them both and both gives me the ones with no price plus all the ones with a price of zero.

I don't use that kind of field, so I don't have a test bed to try ideas on

There are additional terms to use with a (Not) search:
you could try with a 0 value instead of the penny I chose

BTW If you sort the #price column, doesn't the blanks float to one end and the 0's to the other?

Starson17 · 04-12-2011, 11:09 AM

I'd break it into pieces. Does
#price:"=0"
find all the zero price entries?
(or perhaps it should be #price:"=0.0")

If so, adding a not should remove them.
not #price:"=0"

Does
#price:false
give you empty only?

nynaevelan · 04-12-2011, 11:52 AM

Quote:

Originally Posted by Starson17

I'd break it into pieces. Does
#price:"=0"
find all the zero price entries?

gives me all the zeroes

Quote:

Originally Posted by Starson17

Does
#price:false
give you empty only?

gives me the empties and the zeroes

But I am able to use #price:"<.1" and not #price:"=0" in the search box but when I try to save it as a saved search, it doesn't give me any results. I think there is something going on with saved searches because I've had other problems with them in the last couple of releases, but I have been too lazy to research what is causing the problems.

theducks · 04-12-2011, 12:09 PM

Quote:

Originally Posted by nynaevelan

gives me all the zeroes

gives me the empties and the zeroes

But I am able to use #price:"<.1" and not #price:"=0" in the search box but when I try to save it as a saved search, it doesn't give me any results. I think there is something going on with saved searches because I've had other problems with them in the last couple of releases, but I have been too lazy to research what is causing the problems.

Are you giving them a simple Text (no symbols) name? eg: NoPrice

nynaevelan · 04-12-2011, 12:16 PM

Quote:

Originally Posted by theducks

Are you giving them a simple Text (no symbols) name? eg: NoPrice

Yes the name is Edit.Fix Price.

Do you think the space is causing a problem, I have a few of them that I have a space in??

theducks · 04-12-2011, 12:24 PM

Quote:

Originally Posted by nynaevelan

Yes the name is Edit.Fix Price.

Do you think the space is causing a problem, I have a few of them that I have a space in??

No real clue

The 'period' would be my guess

nynaevelan · 04-12-2011, 12:27 PM

Quote:

Originally Posted by theducks

No real clue

The 'period' would be my guess

I hope not, because I need that period to use the hierarchies. I will research it to determine what steps I am taking and what problems arise to see if there are any tickets out there. But this problem first...

theducks · 04-12-2011, 01:19 PM

Quote:

Originally Posted by nynaevelan

I hope not, because I need that period to use the hierarchies. I will research it to determine what steps I am taking and what problems arise to see if there are any tickets out there. But this problem first...

You mis-understood.
A period in the NAME of a filter or saved Search

nynaevelan · 04-12-2011, 01:44 PM

Quote:

Originally Posted by theducks

You mis-understood.
A period in the NAME of a filter or saved Search

That's what I mean, the name of my saved search is Edit.Fix Price, with this naming convention it puts the saved search in a sub-category of Edit. My lookup name is price and my column name is Price. Are we talking about the same thing??

theducks · 04-12-2011, 02:14 PM

I think one of the Dev's needs to step up to this plate

Starson17 · 04-12-2011, 03:17 PM

Quote:

Originally Posted by nynaevelan

gives me the empties and the zeroes

But I am able to use #price:"<.1" and not #price:"=0" in the search box

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

Code:

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?

user_none · 04-12-2011, 04:23 PM

Since it has a space, try using quotes around it.

04-12-2011, 10:13 AM	#1
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Help with Search - Floating Point Number Hi: I am trying to create a saved search based on a floating point number custom column. I tried #price:false and #price:<0 but neither choice gives me the results I am looking for. How do I do a search on this type of column in order to get the books that do not have any data in this field?? Nyn

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
search for series number	speakingtohe	Calibre	4	08-29-2010 01:21 PM
New Floating Kindle Case from M-Edge	anurag	News	24	01-08-2010 07:09 AM
Floating City with pictures!	shousa	Deals and Resources (No Self-Promotion or Affiliate Links)	6	04-01-2008 09:20 AM

04-12-2011, 10:20 AM	#2
theducks Well trained by Cats Posts: 29,792 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Have you tried combinations like: not #price:true, not #price:>.01 (I had a similar issue with Tri-state, where I wanted to find both blank and false. chaley put me right )

04-12-2011, 10:29 AM	#3
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	I just tried them both and both gives me the ones with no price plus all the ones with a price of zero.

04-12-2011, 11:09 AM	#5
Starson17 Wizard Posts: 4,004 Karma: 177841 Join Date: Dec 2009 Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T	I'd break it into pieces. Does #price:"=0" find all the zero price entries? (or perhaps it should be #price:"=0.0") If so, adding a not should remove them. not #price:"=0" Does #price:false give you empty only?

04-12-2011, 02:14 PM	#13
theducks Well trained by Cats Posts: 29,792 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	I think one of the Dev's needs to step up to this plate

04-12-2011, 04:23 PM	#15
user_none Sigil & calibre developer Posts: 2,488 Karma: 1063785 Join Date: Jan 2009 Location: Florida, USA Device: Nook STR	Since it has a space, try using quotes around it.

Advert

Advert