Get list of all jiras with project name and issuetype

[nukarajusundeep]

I am using this query but I am not getting any data

| jirarest jqlsearch "project = CHANGE AND issuetype in ("App Code", "PaaS" , "Arch", "CR-PaaS Maint", "CR-Akamai")"

when I use the for single jira it is working
| jirarest jqlsearch "project = CHANGE AND "KEY"="CHANGE-88778""
this is returning the value

What is the mistake i am doing

[nukarajusundeep]

it is working now thanks I figured out the issue single quotes are working and the query is taking a long time retrieve the data in splunk

[nukarajusundeep]

I tried escape slashes also but it did not work for me

Note: so basically the data is not in splunk we are using jirarest plugin in splunk which will fetch the data from jira using jirarest ideally jqlquery should work which is not working in my case

[gaurav_maniar]

The issue is with unbalanced quotes "".
Try the below queries,

| jirarest jqlsearch "project=CHANGE AND issuetype in (\"App Code\", \"PaaS\" , \"Arch\", \"CR-PaaS Maint\", \"CR-Akamai\")"

and

| jirarest jqlsearch "project=CHANGE AND KEY=\"CHANGE-88778\""

all the programming languages and tools follow nested quotation rules.
as per the rule, all sub-level quotes should be escaped (using \\)

[nukarajusundeep]

@gaurav that's right initially I used escape slashes but it did not return any data

Note: jira data is not in SPlunk, here we are using jirarest splunk plugin to do a rest call to jira and get the data

Here the issue is with the jqlsearch format looks like not sure how to make it work

[renjith_nair]

@nukarajusundeep, whats the issue type of "KEY"="CHANGE-88778"" ?
Do you have the mentioned issue types in CHANGE Project ?

[nukarajusundeep]

yes each jira will have issuetype