Personal Video Database

English => Support => Topic started by: Trebek on August 20, 2010, 12:56:30 am

Title: [SOLVED] Searching Checkbox
Post by: Trebek on August 20, 2010, 12:56:30 am

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?

Title: Re: Searching Checkbox
Post by: nostra on August 20, 2010, 01:28:36 am

Set the value to 0 or use IS NULL

Title: Re: Searching Checkbox
Post by: deazo on August 20, 2010, 11:33:52 am

 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.

Title: Re: Searching Checkbox
Post by: buah on August 20, 2010, 11:52:23 am

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.

Title: Re: Searching Checkbox
Post by: CAD on August 20, 2010, 02:50:23 pm

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?

Title: Re: Searching Checkbox
Post by: nostra on August 20, 2010, 06:17:38 pm

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

Title: Re: Searching Checkbox
Post by: Trebek on August 20, 2010, 07:06:56 pm

Quote from: nostra on August 20, 2010, 01:28:36 am

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.

Title: Re: Searching Checkbox
Post by: nostra on August 20, 2010, 07:21:02 pm

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

Title: Re: Searching Checkbox
Post by: nostra on August 21, 2010, 01:30:08 am

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

Title: Re: Searching Checkbox
Post by: Trebek on August 21, 2010, 01:33:47 am

Quote from: nostra on August 21, 2010, 01:30:08 am

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.

Title: Re: Searching Checkbox
Post by: CAD on August 21, 2010, 01:40:02 am

Quote

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?

Title: Re: Searching Checkbox
Post by: nostra on August 21, 2010, 02:58:40 pm

Quote

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.