You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Please accept my answer so that other users can see that, too.
Admin Tools for JIRA also give that ability (also some additional features) that you can use to administer JIRA - https://marketplace.atlassian.com/plugins/pl.com.tt.admintoolsforjira.AdminToolsForJira/server/overview
There's no way, at least to my knowledge, i use a db query for this:
( ua_lastlogin.attribute_value, 0, len(ua_lastlogin.attribute_value) - 2 ),
u.id = ua_lastlogin.user_id
u.id = m.child_id
you need to replace JIRA7 with your db name and jirachema with your schema name,
if you're not using sql server yo can delete both
Hi @Om Joshi
You can use the above query that @Gaston Valente shared (thank you!) but you'll need to replace the length function that he's using, in addition to the database name and schema name of course.
len(ua_lastlogin.attribute_value) - 2 )
length(ua_lastlogin.attribute_value) - 2 )
Details can be found on this function in the official PostgreSQL documentation.
Please let me know if you have any questions!