https://connect.hyland.com/t5/nuxeo-forum/how-to-query-latest-version-of-file-which-is-neither-in-trash/m-p/324247#M11248 <P>Hi,</P> <P>You can see it in Misc table, column lifecyclestate. For deleted documents it is "deleted".</P> <P>Best regards.</P> Tue, 08 Jul 2014 08:38:00 GMT Vincent_B 2014-07-08T08:38:00Z https://connect.hyland.com/t5/nuxeo-forum/how-to-query-latest-version-of-file-which-is-neither-in-trash/m-p/324246#M11247 <P>Hi all,</P> <P>Does any table in PostgreSQL has file marked/indicated as Trash?</P> <P>Anyone has way to query the latest version of file which is neither in trash nor deleted via PostgreSQL?</P> <P>Thanks.</P> <P>Regards, OKM</P> Fri, 04 Jul 2014 05:10:32 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-query-latest-version-of-file-which-is-neither-in-trash/m-p/324246#M11247 okm_ 2014-07-04T05:10:32Z https://connect.hyland.com/t5/nuxeo-forum/how-to-query-latest-version-of-file-which-is-neither-in-trash/m-p/324247#M11248 <P>Hi,</P> <P>You can see it in Misc table, column lifecyclestate. For deleted documents it is "deleted".</P> <P>Best regards.</P> Tue, 08 Jul 2014 08:38:00 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-query-latest-version-of-file-which-is-neither-in-trash/m-p/324247#M11248 Vincent_B 2014-07-08T08:38:00Z