Hardcode city of the requestee in ARS request

[Community_User]

Originally posted on September 22 2021 at 08:50 UTC

 Hi,

I would like to know, how we can print the city of the person for whom the request has been raised.

City, username, requestor these all things i need to print in a dynamic attribute.

Please help me with a detailed dynamic attribute if possible. iee what all options i need to select.

Thanks,

Shubham

[Community_User · Accepted solution]

Originally posted on September 22 2021 at 14:14 UTC

Shubham,

You could create a dynamic attribute say d_city,map it to a city attribute in the user table. 

Choose 'single select from SQL query' as your attribute type and the value a simple select statement such as Select city as ID from users where userkey=${user.id}

Regards,

Avinash Chhetri

[Community_User]

Originally posted on September 29 2021 at 07:02 UTC

Hi Avinash, thank you for your reply.

Please confirm how can we map that too a user id?

as far as i know, we can only map attributes to a account column, not on an identity.

Regards,

Shubham

[Community_User]

Originally posted on September 29 2021 at 15:08 UTC

Shubham,

Please  ignore mapping it to the user table, I confused mysel with the endpoint vs user dynamic attributes.

However, the soluton I provided to use the SQL query should work.

Regards,

Avinash Chhetri

[Community_User]

Originally posted on October 5 2021 at 12:25 UTC

 Got it, Thank you