Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Database Query question
Author Message
DVD Profiler Unlimited Registrantjamestech
Registered: October 11, 2010
United States Posts: 172
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I don't do these kind of searches hardly ever but I wanted to find out how many Cameron Diaz movies I own. I opened Database Query and I am stuck here. vv





I'd appreciate some help on this, thanks in advance!
Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies
DVD Profiler Unlimited RegistrantStar ContributorAce_of_Sevens
Registered: December 10, 2007
Reputation: High Rating
Posts: 2,873
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
For something like this, i would think it would be easier to just use the filter function in the program than run a database query.
DVD Profiler Unlimited RegistrantStar Contributorbbbbb
on steroids
Registered: March 14, 2007
Posts: 5,609
Posted:
PM this userDirect link to this postReply with quote
Quoting jamestech:
Quote:
I opened Database Query and I am stuck here.

I would have thought that this is a Plugins question.

Quote:
I'd appreciate some help on this, thanks in advance!

You're welcome.
Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect]
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,739
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Its even easier than that. Just go to the cast section of any movie with Cameron Diaz and double-click on the actor. Then all her movies in your collection will show up in a list.

BulkEdit also has a QuickSearch (Alt-F9) that will find any string that exists in the database XML and flag the DVDs. But you don't need that here, just putting in a shameless plug. 
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,282
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
That ought to work.  As long as you've loaded the Cast & Crew when the plug-in starts.  If you don't check that box, you'll get no results.

Still, as they've mentioned, there are easier ways to find this unless you're set on using the plugin.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next