[SOLVED] cb Query Plugin to run a query and based on result update another field

Dear Team,

referring to my post below i have a question about how to use cb query :-

www.joomlapolis.com/forum/255-developer-members-support/232314-integrating-sms-gateway?start=12

i am trying to in-corporate a feature where when a user who had previously successfully verified their phone number and the value of their cb_phonenumberverified field is "yes" now have changed their phone number so this query will basically check if the old phone number is changed, if yes, then the value in field cb_phonenumberverified should be changed to "no" so that they have to re-verify their new number. Please suggest how i can implement this feature ?

Thanks
Pranay

Act on the after profile update trigger and check that [var1_FIELD_NAME] is not equal to [var3_FIELD_NAME] under Conditionals. If they're not equal then the field value has changed as var1 is the new user object (after their changes) and var3 is the old user object (before their changes).

Dear Kyle,

This is what i tried in auto actions :-

1)Triggers - Onafteruserupdate
2)type- Field
3) Under conditions-> [var1_cb_phonenumber]not equal to [var3_cb_oldphonenumber]
4) Action-> field- cb_phonenumberverified
Operator- set(field=value)
Value-no

the issue is it updates the value of cb_phonenumberverified field to no even if i just update the profile without even changing the number.

Thanks
Pranay

You need to compare the exact same field to see if it changed. So you'd have the below.

[var1_cb_phonenumber] Not Equal To [var3_cb_phonenumber]

I've no idea what cb_oldphonenumber field is or if you're updating it when cb_phonenumber changes properly.

Dear Kyle,

it is working now. Thanks!!


Thanks
Pranay