How to get issue list from project in jira 3.12?

[michael raj]

Need to get the all issues from the project or component in jira 3.12 version

[Nic Brough -Adaptavist-]

All you need to do is run a query in Jira - don't bother messing with the database, a simple Jira search can do it already.

Once you've done the search in Jira, look at the top of the screen for the various displays for it - if you want to get it into another application, the XML link is very useful. If you need to get a range of different queries, look carefully at the URL for the XML - it will contain the id for a saved filter, or a series of parameters defining your search.

Hooking up something to try to read via SQL is a lot more complicated, less flexible and pretty much pointless.

[michael raj]

Thanks Luzia. I have one question. Using SOAP api we cant able to get all the issues ? (without filter or search issue)

[michael raj]

Thanks Nic!!!!

I have one question. Using SOAP api we cant able to get all the issues ? (without filter or search issue)

[Luzia Mendes]

Yeah, I can't find information about the API of 3.12 anymore.

I'm sure you can connect your php script to JIRA's db and get the info you need.

[michael raj]

Hi Luzia,

Thank you very much. Please guide me, how to connect php with jira db?

[Luzia Mendes]

Don't exactly remember how is the database on 3.12...but you should be able to find something like

select * from jiraissue where projectkey = <something>

There are just two tables you're interested in, and I'm pretty sure the projects are in a 'projects' table, and the issues are in the 'jiraissue' table

[michael raj]

Hi Luzia,

I already tried with SOAP API via PHP. Using getComponets() and getProject() we can able to lis the existed components and projects. But i cant able to list the issues unser any component or project. I am realy appriciate your answer.

[michael raj]

Hi Luzia,

Thanks for your update. Your answer seems SQL query. But How can i use this query using PHP?