nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

Hi,

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

Best regards.

All comments

Hi,

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

Best regards.