Work Queue Joins and Filters
I'm trying to replicate the structure of a few work queues one of our users creates, but I can't find where the underlying queries (that I assume generate the work queue data) are stored in the Aspire SQL Server database. I've found a table (dbo.[LookupUserDetail]) that lists out the table names and column names for the fields that make up different work queues, but there is no information regarding how those tables are joined together or if there are any records being filtered out. I haven't found any location that lists out SQL code and I can't figure out how the dbo.[WorkQueue*] tables work together.
Is there any guidance someone can provide when it comes to working with work queues in the Aspire SQL Server DB?