User update rule - Need information to use any other tables other than users

[prachi]

Hi,

Is it possible to use another tables other than users in user update rule using the inner or sub queries?

Query will be like - 

a.customproperty2 = (select customproperty1 from customer where customerkey=a.customer)

[DixshantValecha]

Hi @prachi,

Thank you for reaching out to the Saviynt forums. We appreciate your inquiry and would like to inform you that our team is currently reviewing your request. Rest assured, we will diligently assess your query and provide you with updates as soon as they become available. Your patience is greatly appreciated.

[DixshantValecha]

Hi @prachi,

We kindly request additional details pertaining to your business use case. Your comprehensive insights will assist us in better understanding your specific requirements and tailoring our solutions.

[rushikeshvartak]

Try below query 

a.customproperty2 in (select customproperty1 from Customer where customerkey=a.customer)

[rushikeshvartak]

@prachi Did it resolved your issue?