Retrieve all "Test" issue type which are in "Todo" status, whose user story is in"Inprogress" status

[Uma]

Can someone help me with sharing jquery for below case: Retrieve all the linked "Test" issuesTypes(as like Subtasks but not subtasks) from all the User stories which are in InProgress status in a project XXX.

Ex:

S1 -> linked with S1T1(Todo), S1T2(Inprogress), S1T3(Todo), S1T4(Todo), S1T5(Done)

S2 -> linked with S2T1(Todo), S2T2(Inprogress), S2T3(Todo)

S3-> linked with S3T1(Todo), S3T2(Todo), S3T3(Done)

and I wants to have my Jira filter result as below,

S1T1(Todo), S1T3(Todo), S1T4(Todo), S2T1(Todo), S2T3(Todo), S3T1(Todo), S3T2(Todo)

I have tried with below query , unfortunately it retrieves all the Test issueTypes but for all the userstories of all status, I need specifically for Inprogress status userstories.

issuetype = Test AND status = "To Do"  AND issueFunction in linkedIssuesOf("issuetype = Story") AND project = "XXX"

when I tried apply for condition to filter the Inprogress status, resulted with below error, 

Error in JQL Query: Expecting either a value, list or function but got 'In'. You must surround 'In' in quotation marks to use it as a value. (line 1, character 32)

for below try,

issuetype = Test AND status = "To Do" AND issueFunction in linkedIssuesOf("issuetype = Story and status = In Progress") AND project = "NewCo CX"

Can someone help me with this..

[Uma · Accepted solution]

Found an answer :

project = XXX AND issuetype = Test AND status = "To Do" AND issueFunction in linkedIssuesOf("project = XXX AND issuetype = Story AND status = 'In Progress'") ORDER BY created ASC

[John Funk]

Did that work for you?

[Uma]

Yes. it is