Creation of Table in JIRA Database Version 4.4.3

[suryavani bhallamudi]

I have a repository of around 5000 records. Actually i want to store it sme where in JIRA and link it to the workflow of a particular Project such that if for a particular workflow, the status changes from WIP to Resolve, Particular record from repository should change from Active to Inactive.

Plz suggest how my purpose can be solved using JIRA tool.

[Nic Brough -Adaptavist-]

You'll need to write code for this. If you were on version 5.x, I'd recommend a look at Active Objects, but as you're on 4.4, possibly not, maybe just stick to a simple handful of tables in the database (if you do it this way, it's worth modifying the entityengine.xml in Jira to make it aware of the new tables).

Whatever your data store, youlre going to need to write code to store/retreive it. Your spec implies you need a post-function, or possibly a listener, which you can write as a plugin.

Although, my instincts are saying "why not just interrogate the issue for it's status" instead of maintaining flags.

[suryavani bhallamudi]

Can you plz be more precise on what exactly needs to be done.

[Nic Brough -Adaptavist-]

You need to

1. Decide whether to use active objects or not
2. Write a plugin that provides a post-function that reads/writes your data (or possibly a listener)

Google and the documentation point to:

Active objects

https://developer.atlassian.com/display/AO/Active+Objects

Direct database tables

https://confluence.atlassian.com/display/JIRA/Configuring+the+Entity+Engine+for+JIRA

Plugin for the code

https://developer.atlassian.com/display/JIRADEV/JIRA+Plugin+Guide