RickyAdams.com

(Backup your data first, use at your own risk) set @rank=0; INSERT INTO jiradb.customfieldvalue SELECT 12101 + @rank:=@rank+1 as ID, a.ISSUE, 10308 as CUSTOMFIELD, a.UPDATED, a.PARENTKEY,a.STRINGVALUE, a.NUMBERVALUE,a.TEXTVALUE, a.DATEVALUE, a.VALUETYPE FROM jiradb.customfieldvalue a left join jiradb.customfieldvalue b on a.ISSUE = b.ISSUE and b.CUSTOMFIELD = 10308 where a.CUSTOMFIELD = 10800 and a.ISSUE = 11763; where 12101 is the max(ID) of the table to insert into 10308 is the new customerfieldID to be inserted 10800 is the from customfieldID to get the data…

Read More Read More

Atlassian is excited to announce the beta release of our new Issue Collector Plugin, which makes reporting issues easy. This is a must-have plugin for anyone developing a web application: users can raise issues in your JIRA instance directly from within your app, without navigating or logging into JIRA. A trigger link within your application will open a dialog box, where your users can submit details. The details entered are then submitted to your JIRA instance in the background. There…

Read More Read More

Configuring JIRA applications to receive email from a POP or IMAP mail server To enable JIRA to create comments and issues from email, you need to first configure JIRA to receive email from a POP or IMAP mail server as described below. Note: For all of the following procedures, you must be logged in as a user with the JIRA Administrators global permission. Add or edit a POP or IMAP mail server Choose > System. Select Mail > Incoming Mail to open the Incoming Mail page….

Read More Read More