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: Plugins Page: 1  Previous   Next
Query question
Author Message
DVD Profiler Unlimited RegistrantJLYoung
Royale with cheese
Registered: May 13, 2007
United States Posts: 97
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Does anyone know which settings on the latest Database Query will tell me which cast/crew that have at least X roles (at least 1) that do not have a headshot?  I am trying to track down which cast members I need to track down headshots for.
DVD Profiler Unlimited RegistrantStar Contributorsurfeur51
Since July 3, 2003
Registered: March 29, 2007
Reputation: Great Rating
France Posts: 4,479
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
To do that, I run Database Query loading headshots, then:

Cast  : Field=Name  Query=Top X people  Return top=10000, Run Query

Select All Rows, copy and paste in Excel  -> Sort by Headshots, delete names with Yes.
Images from movies
DVD Profiler Unlimited RegistrantJLYoung
Royale with cheese
Registered: May 13, 2007
United States Posts: 97
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Perfect!  Thank you for the quick reply. 
    Invelos Forums->DVD Profiler: Plugins Page: 1  Previous   Next