Definitely! I must stress, that it should search ALL fielddata with a few exeptions. Example; No reason to search in integer or float values if the search string doesn't have a digit, for instance. The tricky part will be the result list.

I have a plugin concept called "FindIt" on the shelf for awhile, but so far no time to do it. Any plugin developer could do this easily. Maybe DJ will jump on it. Also it would be a really cool addition to Database Query.

As an alternative, one could write a standalone tool on top of the exported XML, since all the data is already in text form there. Just loop on the profiles with simple string search of the text, and spit out the profileID matches - but then no way to flag the found profile. So it seems a plugin is best, unless Ken puts it in DVDP.

Quoting DJ Doena:

Quote:
Quoting mediadogg:

Quote:
Maybe DJ will jump on it.

Not this time

Darn. You are sooooo good at it.    Anyways, I'll keep "FindIt" on the drawing pad until I see whether Mark (DB Query) or Ken (you know who) picks it up. Actually, I guess I could add the function to either BulkEdit or MyTools - much easier than releasing and supporting another plugin. How would that be? Should I wait awhile to see if Ken does it?

If someone wants to come up with a list of fields that should be searched, I can look into adding it to my plugin. How's this for a start?

Title
Original Title
Sort Title
Overview
Notes
Tags
Cast
Crew
Genres
Other Features
Easter Eggs

Then perhaps add a column to the output displaying which fields the search word was found in.

Quoting Mark Harrison:

Quote:
If someone wants to come up with a list of fields that should be searched, I can look into adding it to my plugin. How's this for a start? [...]

What about Studios/MCs?


Quoting Mark Harrison:

Quote:
Ok, I've got it halfway done.  Not bad for 15 minutes! I'll finish it up later tonight.

Yay, I'm dying to try it out!   

It seems to me that such a broad search base would not give much in terms of useful results...but maybe. Taking the OP's suggestion Francois, for example, makes me ask which Francois, there is more than a few and that doesn't include the role by that name or even the Movie Title. Not sure i get why such a broad based search would be of much usefulness.

Skip

Got it done earlier this afternoon, but had a birthday party to attend.

Skip, I agree that I don't see the usefulness, but I can say that about a lot of the stuff in my plugin.  Still, if someone else finds it useful, I'm happy to add it.  And in this case it was about 75-90 minutes of work.  Doesn't hurt that I already had the framework built to search through database fields and return the results!

mediadogg, as has always been the case, you can save the results.  In addition to the option to save to a Flag Set, you can select rows with the mouse or right click and choose Select All Rows.  From there hit the Copy icon on the toolbar or right click and choose Copy.  Then you can paste it into something like Excel.  That's been there since version 1.0 I think.

Finally, here's a preview!



The screenshot is a little cut off, but here are the fields it's currently searching:

Title
Original Title
Sort Title
Overview
Notes
Tags
Cast
Crew
Genres
Other Features
Easter Eggs

More fields can very easily be added if someone can make a good case for them.

One final bit of trivia.  If you tell the plugin not to load cast & crew (which increases the speed greatly), it seems the plugin still reads the director.  No other cast or crew are returned by the SDK.  Not sure if it's always been that way or not, but I found it interesting! I could code around it, but that seems silly.  Strange that if you don't ask for the cast & crew you still get the director.

Quick work and good job! 

I assume you can flag the found profiles and save a flag set, right? Also, a UPC column might be useful as part of the output display.