This content has been marked as final. Show 2 replies
About the first question, we can use the column of gsmSignatureDocs.GroupSequence, while current sequence values are stored in specSummary.ActiveSigDocGroupSequence. So a query sql like
select * from specSummary s inner join gsmSignatureDocs sig on s.pkid = sig.fkParent and s.ActiveSigDocGroupSequence = sig.GroupSequence
could be used to get all active signature documents.
And the second, yes, number 0 stands for current active signature documents.
Please backup your database before running any sql scripts.