It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can JIRA metadata be accessed remotely?

Josh Eastburn Aug 16, 2012

Is there any chance that by adding metadata to JIRA using this plugin that I can then pull this data into another application for report generation?

Thanks,

Josh

1 answer

1 accepted

0 votes
Answer accepted

Hi Josh,

sorry - but no. My plugin exports the MetadataService as component for other plugins (within JIRA) but not via ReST. You have to create a Plugin which takes my Service via component-import, make it available via ReST and install it on your JIRA server.

The component-import for your atlassian-plugin.xml

<component-import key="metadataService" name="JIRA Metadata Service"
        interface="com.osoboo.jira.metadata.MetadataService">
        <description>to access the jira metadata service.</description>
 </component-import>

For more details about ReST Plugins see: https://developer.atlassian.com/display/DOCS/Incomplete+Plugin+Tutorial+-+Writing+REST+Services

Cheers
Andreas
Josh Eastburn Sep 19, 2012

Thanks, Andreas. I mostly need to present tables of the metadata now associated with each JIRA project and version. I found where the metadata is stored in the JIRA database, so I think I can probably just use SQL queries to present the results I need.

the good old sql integration ;). the Table should be AO_XXXXXX_Jira_METADATA:

the stored ENRICHED_OBJECT_KEY string will be gernerated by the following pattern:

[com.atlassian.jira.project.Project or com.atlassian.jira.project.version.Version]:[THE_OBJECT_IDENTIFIER]

e.g for a project called SampleProject (Key: SP ) the identifier will be com.atlassian.jira.project.Project:SP

Sample:

Table's create-SQL:

CREATE TABLE AO_CC6AEB_JIRA_METADATA(

ENRICHED_OBJECT_KEY VARCHAR(255),

HIDDEN BOOLEAN,

ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,

USER_KEY VARCHAR(255),

USER_VALUE VARCHAR(255))

The id of my table is the generated primary key.

INSERT INTO AO_CC6AEB_JIRA_METADATA VALUES(

'com.atlassian.jira.project.Project:SP',

FALSE,

3,

'Budget',

'15,000,000.00')

i'll hope this will help you

Andreas

Josh Eastburn Sep 20, 2012

Thanks, again, Andreas. Very helpful!

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Marketplace Apps & Integrations

Demo Den Ep. 4: Continuous Integration with CircleCI & Jira Software

Get ready! Demo Den Episode 4 is coming your way on Tuesday, May 28, 2018 with a Continuous Integration and Delivery special demo. CircleCI Director of Solutions Engineering, Eddie Webb will show us ...

686 views 0 4
Join discussion

Community Events

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

Events near you