The smart safe transaction table has two possible eventcode values DECL and VER
a VER transaction can relate to one or DECL transactions.
The verifyid column in a DECL transaction points to the VER transaction for that row, if any.
I was to select ALL DECL rows where the verifyid column is 0 or if it's not zero the postingdate in the related VER transaction is earlier than a given date
I get this far and go blank
select * from view_expandedsmartsafetrans where eventcode = 'DECL' and verifyid = 0
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.