Scriptrunner Jira, getting 0 records with searchService.search

Mehhss

def masterFilter = "'ISSUETYPE' IN ('PERSON') AND 'STATUS' IN ('ACTIVE, INACTIVE') AND " +

            "PROJECT IN ('Project1') AND 'ID NUMBER' ~ 'ID1234' ORDER BY 'END DATE'  DESC, 'START DATE' DESC";

def parseResults = jqlQueryParser.parseQuery(masterFilter);                      

def masterResults = sServ.search(executeUser, parseResults, PagerFilter.getUnlimitedFilter())
 ;  

log.warn masterResults.total // gives me 0 records 

but when I search with the Query it returns 3 records for ID1234

Is there any mistake in my code for searching the results ?

Ram Kumar Aravindakshan _Adaptavist_

Hi @Mehhss

For your requirement, I suggest taking a look and ScriptRunner's HAPI feature to simplify your code.

You could try something like below on the ScriptRunner Console to get the total number of issues returned in the result

'ISSUETYPE' IN ('PERSON') AND 'STATUS' IN ('ACTIVE, INACTIVE') AND PROJECT IN ('Project1') AND 'ID NUMBER' ~ 'ID1234' ORDER BY 'END DATE'  DESC, 'START DATE' DESC""")Issues.count("""

If the result is greater than 0 then you can try to see what is the output returned:-

).each { issue ->
log.warn "=====>>> ${issue.key}"

}Issues.search("""<span>'ISSUETYPE' IN ('PERSON') AND 'STATUS' IN ('ACTIVE, INACTIVE') AND </span><span>PROJECT IN ('Project1') AND 'ID NUMBER' ~ 'ID1234' ORDER BY 'END DATE' &nbsp;DESC, 'START DATE' DESC"""</span>

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram