06-08-2018 10:51 AM
Query Request: Anyone has a query that shows the document types that have not been used? If so please share:
Still learning the DB and what data is where.
06-08-2018 11:36 AM
This will do the trick:
SELECT DT.itemtypenum, DT.itemtypename
FROM hsi.doctype DT
WHERE DT.itemtypenum not in ( SELECT DISTINCT hsi.itemdata.itemtypenum from hsi.itemdata)
06-08-2018 11:39 AM
06-08-2018 11:43 AM
06-08-2018 11:48 AM
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.