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

[okm_]

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

[Vincent_B · Accepted solution]

Hi,

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

Best regards.