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.
Thanks - this was very helpful. For NPD items, I also had to bring in the Activities and Projects tables to filter out deleted activities and projects that were on hold, completed, or terminated. But it seems to be working well for now! Thx