Hello,
How to create a Report in Jira using the Postgress Schema tables
Thanks
Karu
Don't.
The JIRA database is a data store. It's about as optimised for reporting as I am optimised for a trip to Mars without a spaceship or suit.To give you a rough idea, look at a single issue. If it's a bit complex, you may have to join up to 40 tables, often in joins 4 deep, and do them repeatedly, just to get the basic issue data.Whatever reporting you are trying to get to, please
Thanks Nic , my basic reporting need is to find number of issues created like select * from issue , where can I write query and see the report in Jira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That can be done inside JIRA far more easily than using SQL or reporting add-ons.
Go to Issues -> Search.
There is a simple search allowing you to define a search with drop-downs, but I prefer the advanced one where I can write "JQL". This is *not* SQL, but has some similarities. The main thing to understand about it if you are coming from a SQL background, is that is it only the "where" clause. It says nothing about output, it just gives you lists of issues that match criteria
Your select statement example is too vague to be turned into a proper query, but try something like "project = ABC" to see all the issues in that project, or "project = ABC and resolution = unresolved" to see the open ones, and so-on. See https://confluence.atlassian.com/jirasoftwareserver074/advanced-searching-921472935.html for a lot more...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Nic , but this advanced search will not give me option to write my own custom JQL , it has its own Pre built onces ,any other work around
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.