08-22-2012 07:47 AM
I would like to create a query that lists which scan queues contain a specific document type. Looking at the database mrg and the tables using sql server management studio, I'm having a difficult time finding the right tables columns. Any suggestions will be appreciated.
08-22-2012 07:55 AM
Hi Sharon,
This should do it:
SELECT hsi.scanqueue.queuename, hsi.doctype.itemtypename
FROM hsi.doctype INNER JOIN
hsi.scanqueuexit ON hsi.doctype.itemtypenum = hsi.scanqueuexit.itemtypenum INNER JOIN
hsi.scanqueue ON hsi.scanqueuexit.queuenum = hsi.scanqueue.queuenum
ORDER BY hsi.scanqueue.queuename, hsi.doctype.itemtypename
Thanks
Anthony
08-22-2012 08:03 AM
That worked perfectly! Thanks!
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.