Is there a way to get the users security team owner of a record as a literal condition in a Query?

Question:

know it’s possible to return the USERID in a query builder condition using :USERID and setting the condition to use the value as a literal. Is there a similar way to return the SECCODEID?

 

Answer:

:userid == the ID of the Current User.

When you refer to SeccodeID, what ID do you want to return?
The User’s Security Team?
If so, use :ownerid


Now, if you are referring to the User’s Default Owner as setup on the Options, use a Literal and enter the following:
(SELECT OPTIONVALUE FROM USEROPTIONS WHERE CATEGORY = ‘General’ AND NAME = ‘InsertSecCodeID’ AND USERID = :userid)

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!