The Quality check PI has a check for broken series (missing) in the sequence
You CAN NOT add a column to the real Series table (internal), so you have no way to mark a series complete. You can only mark Books.
You need a 'read' column for your books(I use a timestamp, others us T/F, still others with Family use a Tag of
whom )
You might read the descriptions of the plugins by
DaltonST,
He has some PI that does rather complex queries. You might find one there.
Or this Serrch may do the trick
Code:
series: true and #read:false
then sort the
results by series