JIRA Plugins / Add-on Scripted Custom Fields Uncategorized

How to set format to the value of a Custom Field calculated in JIRA with JIRA MISC addon

Very easy, first see this instructions to create the Custom Field To remove the decimal part of the resulting number from a division of two custom fields for example, and for adding the final character “%”, you can try to set in the “description” of the custom field (of type “Calculated Number”… for example) a…

Read More
Confluence tricks Uncategorized

Obtaining Confluence metrics & SQL tricks

MySQL query to get the last login of all members of the confluence-users group SELECT distinct u.lower_user_name, l.successdate FROM cwd_user u LEFT JOIN logininfo l ON u.user_name = l.username JOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN spacepermissions sp ON g.group_name = sp.permgroupname WHERE permtype=’USECONFLUENCE’ order by u.lower_user_name; …

Read More