Hello community,
I wanted to let customer select products available in his region.
I have User object type defined in Assets and have JiraUser attribute what stores Jira user and have Office text attribute.
I have Offices object type, and as many objects as we have offices/regions.
I have Products object type and it has multi-valued Availability as reference to Offices object(s).
So, some product might be available in multiple regions and reporter when submits the form should see only products available to him, since theoretically we know what Office he belongs to.
Is that possible to write AQL what filters Products objects based on reporter’s office?
Thank you,
Nick
