I have a dashboard that extracts data from Jira through the REST connector. My connection string works fine and I'm able to pull in all the fields necessary, but I'm having trouble with the syntax of the query parameters to reduce the fields loaded.
Currently, I only need to load -
-description, [customfield_1], [customfield_10], and due date from the fields_u1 table
-value_u1 from the [customfield_20] table
-value_u32 from the [customfield_30] table
Can I load fields from different tables in the same query? Or do I need a query each?
Also, is it possible to use a query like project = 'ABC' or 'DFG'? Where project is another field like those above.