I have a queue in a WF where documents come in based on a doc type. We call it the Routing queue. These docs come in from another part of a rather large organization. On a timer (every 30 min) the docs are routed to another queue in the WF.
The problem is that some supervisors are requesting a history and/or a count of what's coming into the Routing queue on any given day. All they would need is a hit list with keyword SSN being listed. I'm looking into writing some SQL for a custom query to see if I can do this. Other posts recommend not to do this in a custom query, instead using the Reporting module which has yet to be deployed in our part of the organization.
I'm new to writing SQL queries in OnBase. I noticed the interface provides me with the From, Where, and Order By clauses. So I don't know how the 'Select what' part is configured. I'd appreciate any thoughts, especially from folks who have gone through something like this. I do have a copy of the DB Reporting Guide.
Thanks.
