how to query latest version of file which is neither in trash nor deleted?

Hi all,

Does any table in PostgreSQL has file marked/indicated as Trash?

Anyone has way to query the latest version of file which is neither in trash nor deleted via PostgreSQL?

Thanks.

Regards, OKM

0 votes

1 answers

1668 views

ANSWER



Hi,

You can see it in Misc table, column lifecyclestate. For deleted documents it is “deleted”.

Best regards.

1 votes