Create task when the organization data updated for a user

[Subash]

Users table don't have the organization data he belongs to. So we cannot able to generate task using the user update rule when the user's organization got updated.

how to create task when user's organization data is updated?

[rushikeshvartak]

You can use users Customproperty [use preprocessor] when users organization is updated then you can use user update rule

[Subash]

Hi,

Where should i use the preprocessor?

[rushikeshvartak]

During data import from trusted source

[Subash]

Thanks for the information!

I will try this out.

[Subash]

 Could you please validate the below query. I tried to update customproperty field for all the users. Is it the right way to provide the dynamic value for username (username=$u.username).

Select c.customername as OrganizationName from customer c where c.customerkey IN (select cu.customerkey from customer_users cu where userkey IN (select u.userkey from users u where username=$u.username))

[Subash]

Hi 

Can i use (username=$loggedInUser.id) instead of the (username=$u.username) to pick the usernames dynamically.

[rushikeshvartak]

where are you trying to use above query ?

[Subash]

I am creating an attribute in global configurations and using this query there.

[rushikeshvartak · Accepted solution]

The supported binding variables are ${requestor} ,${requestee}, $(loggedInUser), and the user objects are exposed (for example: $(user.id))

You should use ${user.username}

Refer : https://saviynt.freshdesk.com/support/solutions/articles/43000663622-onboarding-users-using-access-r...