I need help with JQL query to filter out test report from Test Executions for current sprint

[kajaljena01]

I need help with a JQL query that can filter out my Test Executions based on the environment they are run on a daily report basis. Also, the report needs to exclude test execution for any retest.

The query that I'm using is 

issuetype = Test AND issue in testExecutionTests('TestExecutionKey') AND updated > startOfDay() AND updated < now()

TestExecutionKey filter: 

issuetype = "Test Execution" AND project=XX AND fixVersion = vNext AND sprint in openSprints()

It returns the previous execution test run status rather than current execution, 

Can someone help me with it? any help would be appreciated.

[Santiago Arreche · Accepted solution]

I think I found the solution through Jira Support.
To obtain the values I need about the account field we must use a GET to this URL

https://topsystems.atlassian.net/rest/api/2/field/io.tempo.jira__account/option/

[Alexey Matveev]

Hello,

You should use Tempo Rest Api to set the account field:

http://developer.tempo.io/doc/accounts/api/rest/latest/

[Santiago Arreche]

Thanks. 

That way I have it implemented and it does not work anymore, because the Tempo API changed and they no longer return the ID for the Account objects that I need to send to the Jira Rest API to create the issue.

This is the documentation that Im following now: https://tempo-io.github.io/tempo-api-docs/#accounts

[Alexey Matveev]

What exactly does not work?

[Santiago Arreche]

Hi,

As I understand to create an issue through the jira api I need to send in the field ACCOUNT an ID number.

However, when I try to get the values of the count field from the Tempo api it returns all the data but not the ID number

Then if I try to send the value key to jira's api it fails as I showed before:

Can not construct instance of java.lang.Long from String value 'FAMA'

 The other problem is that if I also send a valid  value hardcoded it is giving me as it is blocked

"Option cannot be selected, it has been locked from assigning to issues"