[SOLVED] Searching Checkbox

[Trebek]

I recently created a custom field that is a checkbox.  When I went to advanced search and searched it allowed me to view any with a checkmark by searching -1.  How can I search for movies though that do not have a checkmark?

[nostra]

Set the value to 0 or use IS NULL

[deazo]

 Hi Nostra,

 I take this opportunity to ask you a "side" question regarding the checkbox.
 Would it be possible to batch edit a group of movies to tick that custom item checkbox to all of them?
 I think it's not possible right now. Is it on your TO DO list or is it just not technically possible?
 Thanks and sorry for posting that in this thread, I just thought it was not worth a new thread.

 D.

[buah]

Multiple editing is allowed only for some fields and as I can recall, it was told that it'll be significantly improved in v1. You can do it right now by exporting entries to Excel, adding a column with the chekcbox with value -1, and then to reimport to PVD.

[CAD]

yes mutiple selecting is posible.
select multiple movies from movie list on left hand side (right click) and select seen/not seen, owned/not owned.
Can you rename skin values and use these as your custom field?

[nostra]

You can't change custom field value for multiple records in the current version of the program, but this functionality is planned for the version 1.0

[Trebek]

Set the value to 0 or use IS NULL

I tried both of these methods today and when I used 0 no movies appeared.  I then tried IS NULL and got the error stating "conversion error from string 'is null' Overflow occurred during data type conversion.  Error Code: 14"
Does this mean there are too many unchecked movies or am I still not doing it right.  I am kind of assuming it's the latter.

[nostra]

Could be a bug. I will check and will let you know in a couple of hours.

[nostra]

What I meant with IS NULL is:
Click on the label with "=" sign and select IS NULL from the context menu...

[Trebek]

What I meant with IS NULL is:
Click on the label with "=" sign and select IS NULL from the context menu...

It worked!  Thank you very much for helping me with that.

[CAD]

What I meant with IS NULL is:
Click on the label with "=" sign and select IS NULL from the context menu...

Hi Nostra, this one pops up all the time - new users don't know that this is  a selectable field.
As a user improvement maybe you could put a frame or something around it, to highlight that it is user selectable?

[nostra]

s a user improvement maybe you could put a frame or something around it, to highlight that it is user selectable?

Yes, you are right. I'll add some bevels or smth in version 1.