Quoting northbloke:

Quote:
Is there any chance you could add an "is blank" option to the querys?
So we can find fields that are empty (for example, sort title etc.)

Edit: I notice it's available on some fields (missing SRP), I just thought it'd be nice to have it on more of them.

Ok, I started working on this and I think you're going to have to be more specific.  It doesn't make sense on all fields, so there's no reason to add it everywhere. For example, is there a good reason to be able to find all empty Notes or Edition or Original Title?  I can't honestly think of a good reason.  That's not to say there isn't a good reason.  I just don't want to start adding this in everywhere unless it makes good sense to do so.

And as for Sort Title, I just tried to remove a sort title from a profile, and the program automatically puts one back in for me.  I tried creating a new title without a sort title and the program automatically put one in for me.  So I don't think there's a good reason to add a query for missing sort titles.  Unless you can think of one of course.

If you let me know exactly which fields you need this for, I'm happy to do what I can.

Quoting Broven:

Quote:
Don't ask me how I managed, but I have had a blank sort title field every now and then.  Of course, they are pretty obvious when you sort the collection alphabetically, as they appear at the top of the list.

I don't know how you do it either.  But the fact that it can happen is enough to convince me.  Version 1.2 (due out tonight I hope) will look for blank sort titles.  Of course I have none in my collection and don't know how to create them.  So I can't actually test it.   But it won't be the first feature I was unable to test.

Quote:
BTW, I love what you've done with this plug-in. 

Yes, I noticed a large number of contributions from you earlier in the week fixing uncredited cast.  I'm guessing you used the plug-in to find all those?

Quoting NewEnglander:

Quote:
Mark, to create a profile with a blank sort title, do the following.

Edit a profile. Click on Personal Information. Delete the current sort title. Click ok.

Edit the profile, there is no sort title.

If you do it from the General Information section, it will keep re-adding the sort title.

Thanks!  That did the trick.  And I can now confirm that the query to find empty sort titles works just fine.  Unless something else comes up, look for version 1.2 later tonight.

Quoting Mark Harrison:

Quote:
Quoting ruineddaydreams:

Quote:
well I guess we know who the average users are - even if they are hiding....

Yep, they're in hiding.  Of course they helped me realize where I needed to dumb things down (no offense to anyone hiding in a bag).  So there's no reason for them to hide.

I'm not in hiding but rather I've been sitting back and watching all of the fine suggestions and creativity that are coming in now. I think I said plenty enough during the beta.  I'll freely admit to being one of those that didn't know what Mark was talking about when he said 'regular expressions'. 

Quoting Mark Harrison:

Quote:
Quoting Broven:

Quote:
Don't ask me how I managed, but I have had a blank sort title field every now and then.  Of course, they are pretty obvious when you sort the collection alphabetically, as they appear at the top of the list.

I don't know how you do it either.  But the fact that it can happen is enough to convince me.  Version 1.2 (due out tonight I hope) will look for blank sort titles.  Of course I have none in my collection and don't know how to create them.  So I can't actually test it.   But it won't be the first feature I was unable to test.

You can get them too if you use the PDA version of the program to add new titles to your collection and then you sync to your desktop. The new profiles don't get the sort title for some reason. It's a bug.

Quoting Mark Harrison:

Quote:
Ok, version 1.2 is now up on my site.  The releases are on the Download page.

Enjoy

Great job Mark, just playing with the plug-in now.

Strange bug I have come across. All profiles with Ireland as the country of origin show up when you choose 'all profiles that don't have a country of origin'. Bizarre!
Did the Irish upset you 

Rich

Quoting Pistol Pete:

Quote:
Quoting richierich:

Quote:
Strange bug I have come across. All profiles with Ireland as the country of origin show up when you choose 'all profiles that don't have a country of origin'. Bizarre!
Did the Irish upset you 

Rich

Same thing with Estonia 

Same thing with Philippines.

These are new countries of origin since I last built my list of countries of origin.  And that dates back to the CSV Export plug-in (which is wrong also).  Since I wasn't aware that Ken added these at some point in the past year or so, they weren't included.

Thanks for finding these.  They'll be in the next version.

You've already given me one heart attack, Mark, Are you going for two.

Skip

Playing with the plugin, I thought of someting that I don't think is possible.

I ran a query by purchase place, then was wondering, how much money I have spent per location. Would be nice to run a query on that. Mark?