Is there a JQR builder tool to select fields, from drop down list, function, etc?

[louis_palardy]

I am It Professionnal with over 30 years of Experience. 

We have been moving to Jira for over 3 years now for Project implementation and Baseline.

Issue I found with the toll is everything is Build in order to Manage the Project work, Time  elapse, status, SDLC and Implementation. Unfortunately it seems there is NO Tool accessible to 1) Select all the Tickets related to a an Epic or a "Functionality", Epic Link Stories and Extract all the Information filled in each fields in a consolidated file - DOCX having all the Epic, Stories, QUalifying questions, exported instead of having to look into 100s of tickets, Stories, Issues, Tests, to try figure out what has been build around this functionality?

The Filter tool is capable of filtering base on fields and operations, unfortunately, where do you get the field name list to use, the value to select, the operator list besides a document listing the operators ? 

No interactive tool for building query., 

I am using PeopleSoft PS Query for pver 25 years and it's standard Delivery, Open a Table, check fields you wish to retrieve, add conditions, and run the report to an excel.

I used IBI Focus - TABLE TALK, for over 30 years, and was able to do a SQL type command having access to field lists. Jira does not seem to have such tool, or it's hiden somewhere, or it's Security related.

project = "TRANSFORMATION PROGRAM" AND Type = Story AND "Epic Link" = "xxxx"

Not obvious to figure out I have to use Type for "Story" or "Epic" 

Any Suggestion to simplify life?

[Clark Everson]

Hi Louis,

Welcome to community!

For the type of searching you are trying to do this is not a native function of JQL. You would need a plugin like scriptrunner to enhanced the JQL to allow this type of functionality.

Even better if you have all three you can more easily automate some processes

I would recommend speaking to your instances site admin

Alternatively you could use the atlassian api with the python library

Scriptrunner: https://scriptrunner-docs.connect.adaptavist.com/jira/

API: https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#about

Python: https://github.com/pycontribs/jira

Best,
Clark