I’m trying to write an expression in a business rule that checks the currently logged in user (User_log_in.person_id) against a team table. However, the team table is not a “related table” to the one used in the rule. Can an expression reference a table that the business rule/process is not related to?
Best answer by Dhanushki Pahathkumbure
It is possible to use user_log_in in your expression, which then is referenced to the person record of the person presently logged in. But if you are trying to use any other table as an operand in your expression whose value maybe used, then it has to be a related table.
+15It is possible to use user_log_in in your expression, which then is referenced to the person record of the person presently logged in. But if you are trying to use any other table as an operand in your expression whose value maybe used, then it has to be a related table.
+21Can an expression reference a table that the business rule/process is not related to?
No you cant use. it should be related to the referenced table
Hi Ipsen,
We generally solve these types of issues by building & relating a custom view in our database.
We find that whenever the target for business rule input or validations are more than 1 relation away; views are your friend!
Hope this helps.
-Rudy
Thank you all for responding to this question. I was able to find a way around by creating a metadata relationship to the Team table and it’s working great. I was hoping to accomplish it using BR expressions to make it simple but I understand now that the expressions rely on related tables.
Thanks again everyone!
+17Please mark OP as answered.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
