10-28-2021 01:24 PM
Has anyone written a query or know what tables/columns indicate when a document has more than one version or revision?
10-29-2021 05:17 AM
From <https://community.hyland.com/forum/threads/53006-find-documents-with-1-revision>
SELECT
hsi.itemdata.itemnum,
hsi.itemdata.itemname,
hsi.itemdata.itemtypegroupnum,
hsi.itemtypegroup.itemtypegroupname,
hsi.itemdata.itemtypenum,
hsi.doctype.itemtypename,
hsi.itemdata.maxdocrev,
hsi.itemdata.maxdocrev + 1 AS [RevNbr]
FROM
hsi.itemdata
INNER JOIN hsi.itemtypegroup ON hsi.itemdata.itemtypegroupnum = hsi.itemtypegroup.itemtypegroupnum
INNER JOIN hsi.doctype ON hsi.itemdata.itemtypenum = hsi.doctype.itemtypenum
WHERE
(maxdocrev <> 0)
ORDER BY
itemtypegroupnum,
RevNbr
10-28-2021 01:32 PM
Hi Roger,
I would start with REVNOTETABLE.
10-28-2021 01:57 PM
Hi All
A simpler approach is using itemdata. Look a the column maxdocrev. If the value is > 0 the there are revisions.
Good Luck
10-29-2021 05:17 AM
From <https://community.hyland.com/forum/threads/53006-find-documents-with-1-revision>
SELECT
hsi.itemdata.itemnum,
hsi.itemdata.itemname,
hsi.itemdata.itemtypegroupnum,
hsi.itemtypegroup.itemtypegroupname,
hsi.itemdata.itemtypenum,
hsi.doctype.itemtypename,
hsi.itemdata.maxdocrev,
hsi.itemdata.maxdocrev + 1 AS [RevNbr]
FROM
hsi.itemdata
INNER JOIN hsi.itemtypegroup ON hsi.itemdata.itemtypegroupnum = hsi.itemtypegroup.itemtypegroupnum
INNER JOIN hsi.doctype ON hsi.itemdata.itemtypenum = hsi.doctype.itemtypenum
WHERE
(maxdocrev <> 0)
ORDER BY
itemtypegroupnum,
RevNbr
05-08-2023 03:30 AM
Hello, how to check in the database who and when performed the revision ?
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.