Hi guys,

I was playing around with some new explorer templates and noticed some of my contents (mainly TV series) data have most of (if not all) the cast listed under 'leading role'.
I have it set up for 6 leading roles and 999 supporting so I'm not sure why this happened. It's not overly important but I'd like to try to fix it if I can.
What I'd like to know is the best way to re-organise them.

However, it is important to me to maintain the order in which they were downloaded. So, for instance, if there were 9 people listed under 'leading role' I would want those last 3 moved to the TOP of the supporting role list, as opposed to the bottom like when you use the 'move to supporting role' option.
If this can't be done simply enough then, as I said, it's not a big deal and I'll just leave them as is. But I thought I might as well throw up the question just in case.

A bit of searching showed up this sqlupdate thing and I was wondering if that's what I'd be wanting but I don't know anything about it, let alone how to use it.

As a side note, is there a way I can easily identify which records have more than 6 entries under leading roles?

Thanks in advance,
DB

I'm afraid you can't use the SQLUpdate program to do this.



You can use the SQLUpdate add-on to mark these records:

1. Open the Contents View, and choose Contents => Mark => Unmark all (or press Ctrl+F8). This will unmark all contents records.

2. Download and run http://www.fnprg.com/dl/sqlupdate.exe

3. Click the ... button and select your database file.

4. Run this SQL update query


5. Now, choose List => Marked Records to only show the marked records.

Thanks for that, Fredrik.

It marked over 1500 records so they'll be staying as is.

It was mainly just to organise them for easier display on an explorer template but I've just used some ifs and counts to get the desired effect.

Thanks again!