https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482175#M193196 <P>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</P> Wed, 20 Nov 2019 23:23:18 GMT nukarajusundeep 2019-11-20T23:23:18Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482169#M193190 <P>I am using this query but I am not getting any data</P> <P>| jirarest jqlsearch "project = CHANGE AND issuetype in ("App Code", "PaaS" , "Arch", "CR-PaaS Maint", "CR-Akamai")"</P> <P>when I use the for single jira it is working<BR /> | jirarest jqlsearch "project = CHANGE AND "KEY"="CHANGE-88778""<BR /> this is returning the value</P> <P>What is the mistake i am doing</P> Mon, 11 Nov 2019 23:41:21 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482169#M193190 nukarajusundeep 2019-11-11T23:41:21Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482170#M193191 <P>@nukarajusundeep, whats the issue type of <CODE>"KEY"="CHANGE-88778""</CODE> ?<BR /> Do you have the mentioned issue types in CHANGE Project ?</P> Tue, 12 Nov 2019 09:47:47 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482170#M193191 renjith_nair 2019-11-12T09:47:47Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482171#M193192 <P>The issue is with unbalanced quotes <CODE>""</CODE>.<BR /> Try the below queries,</P> <PRE><CODE>| jirarest jqlsearch "project=CHANGE AND issuetype in (\"App Code\", \"PaaS\" , \"Arch\", \"CR-PaaS Maint\", \"CR-Akamai\")" </CODE></PRE> <P>and</P> <PRE><CODE>| jirarest jqlsearch "project=CHANGE AND KEY=\"CHANGE-88778\"" </CODE></PRE> <P>all the programming languages and tools follow nested quotation rules.<BR /> as per the rule, all sub-level quotes should be escaped (using <CODE>\\</CODE>)</P> Tue, 12 Nov 2019 13:31:23 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482171#M193192 gaurav_maniar 2019-11-12T13:31:23Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482172#M193193 <P>I tried escape slashes also but it did not work for me</P> <P>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</P> Tue, 12 Nov 2019 16:46:42 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482172#M193193 nukarajusundeep 2019-11-12T16:46:42Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482173#M193194 <P>@gaurav that's right initially I used escape slashes but it did not return any data</P> <P>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</P> <P>Here the issue is with the jqlsearch format looks like not sure how to make it work</P> Tue, 12 Nov 2019 19:04:14 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482173#M193194 nukarajusundeep 2019-11-12T19:04:14Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482174#M193195 <P>yes each jira will have issuetype</P> Tue, 12 Nov 2019 19:05:01 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482174#M193195 nukarajusundeep 2019-11-12T19:05:01Z https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482175#M193196 <P>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</P> Wed, 20 Nov 2019 23:23:18 GMT https://community.splunk.com/t5/Splunk-Search/Get-list-of-all-jiras-with-project-name-and-issuetype/m-p/482175#M193196 nukarajusundeep 2019-11-20T23:23:18Z