Mastering JIRA Course by MrAddon in the Knowtech Barcelona offices

We are happy to announce the new COURSE / TRAINING “MASTERING JIRA” in the Knowtech offices in Barcelona ( inside the Glories Comercial Center). See the summary and levels of the course. Different modules for different professional roles. The modules are not consecutive. Learn JIRA Basics in only 2 hours!! Special or employees of IT…

Read More

How to create a new JIRA Scripted Custom Field obtaining LDAP attributes

Very simple! Download the plugin Kepler Custom Fields Create a SIL Script Custom Field In the custom field configuration set a new script like this: return ldapUserRecord(“attribute”, “”, “”, “”, “user@example.com”, “user”); Remember to configure the LDAP connection Go to “Cog icon” –> Addons –> KEPLER –> LDAP Configuration URL = ldap://localhost:389 BIND USER =…

Read More

New JIRA Cloud development environment FREE!

Info extracted from: “https://developer.atlassian.com/blog/2016/04/cloud-ecosystem-dev-env/?utm_source=newsletter&utm_medium=email&utm_campaign=developer-newsletter_may-2016” Cloud development instances “In order to make the cloud development experience better, we have designed a new environment for you that includes free development instances exclusively for add-on developers. When you sign up for a developer instance, you will get: JIRA Core: 5 users free JIRA Software: 5 users free Confluence:…

Read More

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