How to analyze Table Grid Editor data with JIRA Issue data

[Sara Lam]

Hello,

The Table Grid Editor seems like a very good plugin for collecting data into table format within JIRA issue.  However, the documentation never mentioned how I can view/retrieve both JIRA Issue data and the table grid data in the Navigator filter format.

For example in their expense report, if I want to analyze a reporter's expenses reports, how can I get all the issues created by a reporter and see how much was spent on meals in certain month? I guess JQL can retrieve the issues but can it show all the table data at the same time without clicking each individual issue ticket?

Thank you for your help in advance,

Sara

[Guilherme Nogueira · Accepted solution]

I think in issue navigator you can add the "table grid" field as a column. So you can see values without opening issue.

To search by using JQL you can use:

issue in grid("YOUR_CF_NAME", "Your_COLUMN= 'value_of_this_column'")

more info:

https://wiki.idalko.com/display/TGPD/Criteria+based+grid+search