Need to correct below JQL filter

[Pooja Bhardwaj]

Does not work: issueFunction in childrenOf("key in (PM968-1805, PM968-1804, PM968-1812)")
AND issuetype = "Test Plan"

Need a filter for filtering all defects linked to the test execution linked to below multiple inititaives in different project - Above query didn't work

[Bartek Szajkowski _ Orbiscend OU]

Dear @Pooja Bhardwaj 

Thanks for your request.

If you are open for third=party app, I would like to recommend JQL Argon app.

issueFunction is ScriptRunner-only — JQL Argon's syntax is just issue in childrenOf(...)

Argon uses the cleaner issue in childrenOf(...) form, plus linksQuery / linkedByQuery for navigating links between Test Plans → Test Executions → Defects.

Step 1 - Test Plans under the 3 initiatives:

issue in childrenOf("key in (PM968-1805, PM968-1804, PM968-1812)") AND issuetype = "Test Plan"

Step 2 - Test Executions linked to those Test Plans (nested subquery):

issue in linksQuery("issue in childrenOf('key in (PM968-1805, PM968-1804, PM968-1812)') AND issuetype = 'Test Plan'") AND issuetype = "Test Execution"

Step 3 — Defects linked to those Test Executions (final query the user wants):

issue in linksQuery("issue in linksQuery('issue in childrenOf(\"key in (PM968-1805, PM968-1804, PM968-1812)\") AND issuetype = \"Test Plan\"') AND issuetype = 'Test Execution'") AND issuetype = "Bug"

Hope my answer give you some additional overview, nevertheless its works with JQL Argon app. JQL Argon Powerful Search 

Greetings
Bartek
(Orbiscend OU - JQL Argon app provider)