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.
Can 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.
- Create View to contain both key identifier of your primary table + whatever else data you need for your validation
- Create Metadata for View
- Create Metadata to Relation the view to your primary table
- Create business rule with validation against the view.
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!
Please mark OP as answered.