We need a solution to grab the new email address of the user. Currently it is pi

sudhirp804 over 10 years ago

We need a solution to grab the new email address of the user. Currently it is picking old email address of the user example abc@myworld.com and it should pick or the grab the new email address like abc@myworldwide.com
Currently in our process model we pick email address from process variable which picks the old email address. What we required some expression which will grab the new email address of the user.
Could anyone let me know how it can be done. I have created a new expression rule which will search the user the firstname and lastname and pick the email address but only picking the old email address here. We need to pick/grab the other email address of the user like if user old email is abc@myworld.com than it should pick the new email address abc@myworldwide.com
=rule!prmFormatUserAsEmailAddress()
=if(and(not(rule!APN_isEmpty(ri!user)),isusernametaken(ri!user)),user(touser(ri!user),"firstName") & " " & user(touser(ri!user),"lastName"),"NA")
...

Discussion posts and replies are publicly visible

0 sudhirp804 over 10 years ago

...
Your suggestion will be value for us. Thanks in advance
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

Attached the expression rule
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

=if(and(not(rule!APN_isEmpty(ri!user)),
isusernametaken(ri!user)),
user(touser(ri!user),"email"),"NA") .... This is current rule I have added but it is still picking old email address.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

Hi sudhirp804 Are you talking about process instances that has been generated before making the recent changes in process model?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

Recently in our organization email address has been changed and both email addresses are in data. Like the user have sudhir his old email addess is sudhir123@world.com and new email sudhir123@worldwide.com both exist but we want to pick new one...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

Could you please let me know what do you mean by 'data' here?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

We need to update the process model Build_Project_Quote to use the new email address. Currently this model is using a PV projectmetadata to get the email address. I would like to not modify this PV and instead we could create an expression rule like prmFormatUserAsFirstLast to get the email address then we can reference the rule in the process model. I have already created a rule to get the user name firstname and lastname and pick the email address but it is picking old email. Just want to know how it can pick the other email address of the user.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

sorry I mean (data) the organization database
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

So, is your email address present as an attribute of 'User' object in Appian or is the email address present in database?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

Simply speaking, please make sure that the new email address you are expecting for the user is exactly same as the 'email' attribute of an 'User' object in Appian because the rule which you have created recently returns you the 'email' attribute of 'User' object in Appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel