Re: OnBase Query Request: Does anyone have a query that shows the document types that have not been used? If so please share:

Hyland Community

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.

1 ACCEPTED ANSWER

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)

7 REPLIES 7

[deleted]

I just realized you were responding to Gabe's post and not mine. Sorry. I would recommend using the simple query I posted,

@Roger Linhart - Yes.

Hyland Connect