SQL Query to get the User Cal in a workflow

0

Hi Andreia,

I wanted to test it, but for some reason my UserCals table is empty. So take the following suggestions with a grain of salt, since I couldn't test them.
1. JOIN UsersCal <- there is an s missing, it should be UsersCals
2. If {WFCONCOL:1858} is a user/choose field, you should use "Database field name - Id"
3. I don't see the reason for using the CacheOrganizationStructure. Without knowing the data I would guess, that this should return the same data:
SELECT UCL_BpsID
FROM WFElements
JOIN UsersCals as A ON A.UCL_BpsID = 'ID OF USER'
where WFD_ID = '{WFD_ID}'

4. If you are executing this on the Task Assignment Workflow, you could simply use the Login option for the field from the Values tab
SELECT UCL_BpsID
FROM UsersCals
where UCL_BpsID = 'ID OF USER'

The numbers in the images refer to the numbers above.
If you are having trouble with choose fields/sql statements you could spend a few minutes here:
https://daniels-notes.de/posts/2021/series-expert-guide-part-4#querying-chooseperson-fields
https://daniels-notes.de/posts/2021/series-expert-guide-part-3#creating-the-sql-statement

I hope there is some helpful information here and in the posts.

I'm not sure way you need this at all. My only idea is, that you are running out of Cals and you need to release one. But that's not the question here anyway. :)


Best regards,
Daniel

Hi Andreia,
The UsersCals table is only applicable in WEBCON APPS Subscriptions. The Licensing model is a little bit different than the rest of the BPS installation types.
If you need some help with your Subscription, please issue a ticket on our Support Platform (https://support.webcon.com).

Best regards,
Tomasz

Hi Daniel and Tomasz

Yes, after fixing the query I don't get any results so I believe it's not available for me.

Thank you for your help and if needed I will revert in the Webcon Support to fix this!


Kind regards!