User assigment in unity life cycles

[ANA_MARIA_SOLAN]

Hi,

I am currently facing an issue while trying to retrieve information regarding the "Assigned to Users" in our Unity Life Cycle. In the first instance, the "Ownernum" field displays as 0, but when I retrieve the document in the Unity client, a user assignment is present. (as you can see in both images)

I also attempted to use the workitemlcxassignment table, but it returned no results:

Could you please advise if there’s a way to retrieve the assigned user information through a SQL query?

Thank you in advance for your assistance.

Best regards,

[Brendan_O_Brien · Accepted solution]

What load balance method are you using? If "Match Keyword to User Name", there will be no assignment reflected in workitemlcxassignment.

[ANA_MARIA_SOLAN]

Yes, it is using a match keyword to User Name. Is there a way to see it?

I do not want to use the keyword tables because in each queue it uses a different keyword, and it will be quite difficult to make all the joins.

[Brendan_O_Brien]

I'm afraid those assignments aren't captured in any of the WF tables. The only way to capture them would be to pull the keyword values. I know because I just went through this during the process of trying to create an assignment dashboard. Hyland confirmed that "Match Keyword to User Name" is not truly an "assignment" from a database perspective. I started down the path of writing SQL to pull in the keyword values to create an "assignment" that way, but with the number of document types - and the fact that we had some queues that were using true, "Rules Based" assignments, I ended up converting all of my "Match Keyword to User Name" load-balanced queues to "Rules Based" queues.

[ANA_MARIA_SOLAN]

It’s unfortunate that it’s not possible to capture the assignments that way,

Thank you so much for detailed explanation.