We know that updating user details via back end is not recommended. But we have a task to achieve this.
We would like to update the missing user details from crowd database. And to achieve this we are able to update the cwd_user table using query (UPDATE CWD_USER SET LAST_NAME='lastname' , FIRST_NAME='firstname' , EMAIL_ADDRESSfirstname.lastname@example.org' WHERE USER_NAME ='username' from database. and this is working perfectly fine.
But when we update the user details via database the display name(refer crowd1 screenshot attached highlighted in red) shows the old values even though the table is updated with modified values.
How can we resolve this issue, please suggest.
Only issue is why it is not showing the updated values in under name.(please refer crowd1 screenshot)
refer the before and after updating the values in crowd.(attached screenshots)crowd1.pngbefore_update.pngafter_update.png
Hi @Gsep Support,
I think this has something to do with the attributes' lower values or the timestamp. This worked for me on HSQLDB database:
UPDATE CWD_USER SET UPDATED_DATE=CURRENT_TIMESTAMP, LAST_NAME='Bar' , LOWER_LAST_NAME='bar', FIRST_NAME='Foo', LOWER_FIRST_NAME='foo', EMAIL_ADDRESSemail@example.com', LOWER_EMAIL_ADDRESSfirstname.lastname@example.org', DISPLAY_NAME='Foo Bar', LOWER_DISPLAY_NAME='foo bar' WHERE USER_NAME ='myuser';
Still, you should definitely use Crowd REST User Resource instead of direct updates to the database: https://developer.atlassian.com/display/CROWDDEV/Crowd+REST+Resources#CrowdRESTResources-UserResource
Hi Atlassian's, How is your journey with #Atlympics 2021 so far....excited! Me too, same excitement. Here's my typical team planning and vision dashboard which I used to share to my management and ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events