Jira jql issuekey "project=CONF"). Encode the JQL query. There are also a handful of other add-ons that offer this functionality but like ScriptRunner, they all cost money. com. 4 days ago · As the JQL query is a request parameter for this resource, it must be URL-encoded in order to work correctly. In a clause, a field is followed by an operator , which in turn is followed by one or more values (or functions ). Was this helpful? Oct 20, 2021 · Standard JQL doesn't easily allow searching for exact words, special phrases and patterns. I would like to find a list of issues in our QA project for the original issues resolved list. This works if you want to do a one-off analysis. getInstance("com. ofbiz. Indeed, executing the search specified in: Nov 28, 2018 · Hi Nir, thanks for your response. project = HCPUB and issuekey >= "HCPUB-730" and issuekey <= "HCPUB-739" You can also always generate the list yourself, which can be a little tedious: Feb 3, 2022 · Hi, I am using the following JQL query: project = EVV AND issuetype = Feature AND issueLinkType not in ("implemented by", implemented) ORDER BY key ASC Is it possible to filter the linked issues by their issue types ? Regards, Vincent Apr 6, 2023 · The portfolio JQL is not capable of doing what you are asking. Option 1: Run JQL in Jira and copy from address bar. Example. I found out already, that "~" ist an unsupported operator for "issue key". Mar 9, 2023 · The built-in JQL function linkedIssues(issueKey) does not allow the flexibility that you want to achieve here. If you're still running into the same issue, maybe the JQL functions are not enabled with your Portfolio instance. Jan 10, 2019 · @Isaias Salazar Torrealba Please refer below Atlassian documentation on Advanced Searching JQL functions available out of the box in JIRA Cloud. It's the last bit I'm struggling with. 0 Usage/Examples: Feb 2, 2017 · you can call a JIRA QL like this one: watcher = currentUser() AND resolution = Unresolved ORDER BY priority DESC, updated DESC. Jira versions earlier than 8. You've spotted the two main ones! Jun 2, 2017 · A pretty accessible work-around that I would suggest is below (using the JIRA / Hipchat issues themselves as an example). Sep 13, 2022 · Scriptrunner issue picker JQL does not support (to the best of my knowledge) any placeholder to reference the current issue. Sep 26, 2014 · You can see one example of how it works in Atlassian's REST API browser for jira. 18. Your use case is more dynamic than that. When a query has to search through fewer issues, results load faster. However, you need to know how to construct structured queries using JQL to use this feature. match(". When searching JQL using updatedBy(), eg: issuekey IN updatedBy in JQL, search issuekey IN updatedBy Atlassian Jira Project Management Software; Feb 1, 2021 · Advanced Roadmaps is now part of Jira Software Data Center See our FAQ to find out how this affects your site These docs are for Advanced Roadmaps version 3. For example, imagine you want to find information on two issues. It is not possible to use the CurrentUser() in JQL with UpdatedBy function. issueKey in (JIRA-1,JIRA-2,JIRA-1000) I would like to add a AND condition and filter out the only issues which has Child issues within. You can't add comments to a JQL statement, like you would add comments to programming code. It uses the strict ordered-ness of JIRA keys without needing a wildcard. Basic Filters 1. My problem is that this strings can be parts of another string Example: SomeSTRINGi need and antoherTHINGineed to find. In case of a user having permissions for ISS-23 and with no permissions for ISS-25, request to /rest/api/3/search with a JQL like “IssueKey in (ISS-23, ISS-25)” will result in the 200 status, fully detailed ISS-23, and the proper warning message telling about the ISS-25. Field – Fields are different types of information in the system. According to Grok it Sep 14, 2018 · Hello everyone, I'm having trouble with using truncation for the field "issue key". Creating an issue using the Jira REST API is as simple as making a POST with a JSON document. As a result, the issuekey cannot be returned by using jql query in the validator part. Thank you so much Sep 11, 2024 · issuekey in ChildIssuesOf(ABC-9876) - I then use AND and additional statements to further filter if needed, by status' for example. How can I specify the comment field to be included in my response results? Apr 10, 2024 · I have a specific epic where I want to see all direct issues and their subtasks from. Otherwise, register and sign in. What you need is Adaptavist ScriptRunner, they have a function called hasLinks(). 18 - Jira Service Management 5. Advanced Jira Query Filtering. How to we programmatically get the corresponding issueId for an issueKey? If we have to use combination of Jira and Zephyr apis, then how do we authenticate programmatically for Jira api calls like we do for Zephyr through JWT. Jan 31, 2019 · Hi, I am trying to run a JQL query for Portfolio where I need to see all child issues of a Campaign for which the user story contains a Label = 'ABC'. . There are two ways to encode a JQL query to make it URL-compatible. The only way to get only the issues linked to the current issue is to use dynamic JQL. issueFunction in issuesInEpics("issuekey = JRA-1") Having two JQL functions of the same name in Jira will produce confusing results. How to search for JIRA issues NOT in filter. 2 to about 2000 characters - roughly as long as can be accommodated when the Navigator's context is specified using the GET method - with the query encoded in the url. Since: v1. 12 which our company uses. JQL is a key feature of Jira, a popular project management tool used by teams to track and manage their work. 20 I need to track a set of epics. It is a simple yet flexible language that enables users to create complex queries to find the exact information they need. If I use. I know there is linkedIssues(issueKey,linkType) but it works on single issuekey for each call. Expected Output - If JIRA-1,JIRA-2 only has child issues so the query should return JIRA-1 and JIRA-2 out of issue keys Nov 21, 2022 · History searches without JQL. You must be a registered user to add a comment. Well, I have to admit, that I'm kind of abusing Jira for project management - since we don't have no PM-Programm in my Nov 13, 2015 · I am looking for the Jira JQL syntax to find issues that have a linked issue in another project. Sorry. 0. The following pictorial representation: PORTFOLIO EPIC EPIC1 Issues/stories EPIC2 Issues/Stories EPIC3: Issues/Stories Attempted JQL: issuekey in childIssuesO Boost your productivity by learning how to use advanced search with Jira Query Language (JQL) in Jira. Status = "Waiting for Customer" AND Updated < -10m AND Organizations = "zzTest - Testing Org" then I get accurate results in the Issues Search but it fails validation in the Scheduled Automation JQL Aug 4, 2019 · It's not well-documented, but there are a handful of "aliases" in Jira. Aug 30, 2011 · Something which works for me is following jql project = xxx and component="Data Provider Component and component = "Grid Configuration" which results in a list of issues which have both components I'm not sure this is an answer, because if you have a long list of components and you need to specify all permutations, you will get a huge jql The JQL Query length in the Issue Navigator has been limited in Jira 6. Additionally: I want to filter tickets only created between 12am to 8am. In this article, you will read how to search history in Jira: with JQL and without it. This function is not working with the Link Type Name , it just works with Outward Description and Inward Description . getKey() def jql = "project = ABC and issuetype = Epic and issueFunction in linkedIssuesOf('issuekey =" + issuekey+ "')'" //not working, of course . Let’s say you want to view all the work assigned to you using a JQL filter. Apps tell Jira how to replace a specific function into a valid JQL fragment. A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira fields. title. Mar 17, 2021 · Hi All I am using Jira 8. If the standard JQL isn't enough, check out existing plugins, such as JQL Tricks Plugin. Regards, Asmath While some searches are simple, others can be complex and require knowledge of JQL (Jira Query Language). Using query below, I can get of list of epics to be excluded. groovy. I hope this helps! Daniel. Feb 19, 2013 · Have a look at JIRA's Advanced Searching for more information. Jira Query Language (JQL) is the popular way to search for issues in Jira. 8 and scriptrunner 6. You can also use JQL to search for issues, by using Advanced Roadmaps issue Aug 11, 2017 · In the core JIRA JQL functionality the closest thing you have, as you've already found out, is linkedIssues() that requires a parent Issue reference. Using i. I would like the filter to only show the blocking issues Aug 10, 2017 · in the Scheduled Automation JQL, it comes back as valid; however running it in the Issue Search returns no results. (I've clicked on all of them to unwatch manually though) Dec 19, 2024 · It sounds like you might be using the issue hierarchy and plans feature in Jira Cloud. Because this smart value deals with multiple items (i. For instance, you have this hierarchy: Javadoc API documentation for Atlassian JIRA. I want to get all undone issues in a project, linked to a certain epic, but do not want issues with issue key = "HHVASE*" My JQL so far is: E Mar 3, 2020 · Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. If you've already registered, sign in. jira. Key is an alias for issuekey, and type is an alias for issuetype. When constructing your JQL query, tell Jira where it should search for issues by including or excluding specific projects or boards. That answer could change based on additional addons you may have with enchanted search capabilities, but the native Jira JQL doesn’t allow for this kind of referencing. Nov 7, 2024 · Jira is not a time machine, but some features let you travel in the past. ” Of course, you can always add functionality to Jira through the Atlassian marketplace and many Apps to add querying functionality specific to their use Aug 1, 2018 · JIRA JQL CURL-Search based on Issue name/description (Get ticket ID based on name) REST API 2 How to retrieve Jira issues via REST API when query contains a space Jun 1, 2018 · If you are searching for the issues in a Plan, you should use "issuekey in issuesInPlan(18)" instead of "issuekey in issuesInProgram(18)". But the only way I have found so far to retain the correct order in the list is by numbering the summaries manually - not really sophisticated. What if you need to search for other past changes that JQL doesn’t support? It can be sprints, issue types, descriptions, comments, due dates, or other updates. I would like to create a filter that captures all issues under an Initiative. How can I create a JQL for this? I've tried multiple options, however those only work in Jira Cloud and not in Jira Server 9. 4. atlassian. The plugin is developed as a history journal for all past activities on the issue level. Are there other aliases and is there a documentation regarding this? Thanks a lot! Feb 1, 2021 · In Jira, you can use JQL to search for issues that use Advanced Roadmaps custom fields. JQL is for everyone: developers, testers, agile project managers, and business users. OneOrOther") Jun 19, 2022 · I want to know how many statuses was changed and how many issues were created by every Jira user during the last six months. Jira fields include priority, fix Version, issue type, etc. I wrote a JQL to get this information by single user: issuekey IN updatedBy(username "2021/12/19", "2022/06/19") AND creator = username But is there is a way to create a query to get this information for all users together? Accesses the values in an issue's Affected services field. After you install the app, you can simply search: Check out the documentation for more examples and other text matching functions. If you're interested in learning more about the terminology and how things are organized, this document is a great place to start! In a JQL search, you can simply use this search string to only include issues from the OP project: Jul 15, 2020 · As you're on Jira Cloud the correct answer is to get an app that provides JQL extensions you're looking for. In Jira, select Search > View all issues; Write a JQL query and select the Search icon For example, you can use the ORDER BY clause in a JQL query to search for issues and display them in an ascending or descending order. So far I have: project = "Project Name" AND issuelinktype = blocks However, the results show both blocking issues and issues that are "blocked by". Still have a question? Get fast answers from people who know. With standard JQL you can only get a list of issues and export them to Excel for further processing. To learn more about advanced searching in Jira, see Advanced issuekey in portfolioChildIssuesOf("INIT-001") AND issueType = Story If needed, you can skip returning issues of the hierarchy levels you don't need: issuekey in portfolioChildIssuesOf("INIT-001") AND issueType != Epic. Oct 17, 2023 · Hi All, I would like to have JQL filter, where I wanted to get children epic(s) and issues from children epics from the Portfolio Epic. 请注意，除非在搜索查询中指定，否则 JQL 搜索不会在结果中返回空白字段。要在搜索未指派给当前用户的事务时包含空白字段（例如未指派的事务），您需要输入 (assignee != currentUser() OR assignee is EMPTY)，以将未指派的事务包含在结果列表中。 Feb 16, 2017 · I'm trying to use JQL, and Script Runner functions, to construct filters which give me a list of issues (typically stories) in a project which have a link (or links) to other issues where the linked issues are unresolved. Best, Joseph Dec 6, 2023 · I am not good with JQL. May 25, 2021 · Hi, thanks for bringing the question! Yes, the behaviour that you presented in the scenario is the desired one. com. Jun 13, 2017 · @Jeffrey Freund You would have to create a filter that selects all the stories/tasks first that is linked to the epic, something like this:. The currentJQL field also contains the JQL that describes the set of issues in which you want to find substring matches (eg. That means that I would like to add a filder to the childIssuesOf so that when we reach the user story level, if that user story contains a Label = ' Jan 23, 2020 · Most people using Jira would look at it and expect to see the issue key (and they would, although what you see is not quite what it really is) issueFunction is a (sort of) custom field created by ScriptRunner to accumulate a load of issue information together in the index to prevent it having to do massive calculations every time certain Mar 6, 2024 · In Jira you can only find the user details by giving the Name of the user in the Updatedby function otherwise by using CurrentUser we can't filter the tickets in Jira for Updatedby function. JQL’s flexibility in Jira helps project managers and agile teams navigate large datasets. However I would like to exclude epics belonging to couple of initiatives. Searching for issues using Advanced Roadmaps details | Advanced Roadmaps for Jira Data Center and Server 3. *")}} I am absolutely sure that the smart value is working, because I am audit logging the same value in the previous step and it returns valid issue key; I have tried the super simple JQL in Jira and the issue is found; Mar 31, 2023 · Welcome to the Atlassian Developer Community, @MiriCHENEFR! For this specific use case, you might want to use the Search for issues using JQL, this way you can search for issues linked to the issue (SSDBG-940) with an issue link type of “Contient”. If you’re using Jira 8. You can fill in a Description for the saved filter, but you can't insert explanatory comments into the JQL itself. *(RM-\d{4}). core. project = "Works" and issuetype= epic and ("Parent Link" in (TAN-37,TAN-67)) Howe Oct 17, 2023 · Hi All, I would like to have JQL filter, where I wanted to get children epic(s) and issues from children epics from the Portfolio Epic. JQL, or Jira Query Language, is a powerful tool for creating advanced search queries in Jira. e. I need to list all issues in project that contains STRING and THING. Jira will only register the first function for use in Jira and will simply ignore any others of the same name. It can help if you need to find out what happened in the past, but not in all cases. To be able to find all those tickets with your watch. Jan 24, 2025 · Hi @Manisha Patel Welcome to the community!. Also the "issuekey in" part should be there. Would something like this be possible? Thank you! Feb 1, 2024 · Unfortunately changes I make with this code are still not seen with 'issuekey in updatedBy("<user>")' JQL queries. 29 | Atlassian Documentation However, that doesn't seem to work for me. EXAMPLE: For parent issues of an issue. 0. I have seen posts that say to use "linkedIssues" but this is not a field that we have. Jira invokes the business logic of the app. I am getting the issue information using the jql query but the problem is the 'comment' field is absent in the jql query response results which I think it's because comment has multiple entries. Another option might be to create your own JQL search, check Adding a JQL Function to JIRA for more info about this solution. Nov 3, 2021 · I’ve gone through and Identified six bits of JQL that will help you take your querying to the next level. pull_request. Apr 11, 2017 · In Jira Cloud you can currently find the children of initiative by specifying the issue key: issuekey in portfolioChildIssuesOf(MYKEY-1) You can specify multiple keys by duplicating the above query and connecting the queries with OR. Mar 1, 2025 · Scope: I'm trying to run a jql query (it works in the jql search prompt) using a groovy script; to give me a list of issue keys. 15 or higher, see Advanced Roadmaps in the Jira documentation A field in JQL is a word that represents a Jira field (or a custom field that has already been defined in your Jira applications). Add Action: Lookup issue and filter the tickets using JQL: JQL: issuetype = bug. And it only gives me null results using the Script Runner Console. Sep 30, 2022 · Here I found that I should be able use the JQL "issuekey in parentIssuesOf("{{issue. Sep 28, 2019 · Hey Guys, It seems there are aliases possible in JQL. 5. Jul 17, 2019 · JIRA JQL select issues where issuekey contains key. Jan 8, 2018 · I don't know how proficient you are in JQL yourself, but I can recommend this blogpost as an excellent starting point on how to search for issues in Jira using the power of JQL. Apr 11, 2017 · Is it possible to use JQL in the Confluence JIRA Issue/Filter macro to display a table of all the issues of a Portfolio Initiative? The link above seems to be creating a query in Portfolio itself [ issuekey in childIssuesOf("INIT-001") ], but I can't seem to find equivalent JQL syntax that will work in the Confluence macro to retrieve the issues. Introduction to JQL Search. Creates an IssueKey object form the given issue key String. Text Search. Background is that there is email handler i Mar 12, 2021 · Hi Petr, What issue keys are you trying display? In your example you branching on all cloned issues. You can also fire up Feb 25, 2020 · Could you try the following? Search for EMEA issues within the folowing range 100 - 250 both inclusive. The app that Jira determines to be first is somewhat arbitrary and may result in different JQL functions of the same name being registered on each start. Trigger: Issue Created. If so, you can use a JQL statement like: issuekey in portfolioChildIssuesOf("ISSUE-123") Simply replace ISSUE-123 with the ID of one of your initiative issues. e: issues can have many fix versions), it can be used with the # symbol to apply the rule to each individual fix version. 10. Let me know if you need help and good luck! Feb 12, 2025 · In a situation where an automation rule in Jira generates a list of issue keys using the "Lookup Issues" action, please follow these steps: Generate the issue key list using lookup issues. Is there a call similar l In linkedIssues(issueKey,"CaseSensitiveLinkType") if you replace CaseSensitiveLinkType with the link type name, it will return that the Issue link type couldn’t be found in function 'linkedIssues'. The epic contains a multitude of issues and those issues all have a list of subtasks. def Category log = Category. For your case, you can use the function "linkedIssues()", as mentioned in this document: Oct 10, 2019 · issuekey in childIssuesOf("your parent issuekey-xxxx GOES HERE") example: issuekey in childIssuesOf("NMER-9549") where NMER-9549 is the Story and the search results would be the subtasks. JQL Booster Pack you can type the following: Search for issues that blocks others issues OR linked issues with status != Done: issue IN linkedIssuesOf("status != Done", "is blocked by") Jan 15, 2019 · You can use Jira Query Language (JQL) to search for issues that use custom issue fields in Portfolio. The same situation for key and issuekey. The current JIRA function only retrieves the immediate links whereas this one traverses the enitre tree and retrives all the directly and indirectly linked issues. Whether you are a Jira beginner or a seasoned user, here are some essential tips and tricks to help you become more efficient and effective with JQL. Any JQL you place there needs to be able to work exactly as is in a regular issue navigator screen. Regars. Is there any way I can use JQL to get a list of issues where the epic link of the issues is linked to a specific initiative? Right now I am typing out the keys for all of the epics but it is always nice when the Feb 13, 2019 · So I use a query like "parent = XYZ-165 OR issuekey = XYZ-165 ORDER BY summary". 12. I can get the list of stories which hav A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or JIRA fields. To search for issues using JQL, follow these steps: In Jira, go to > Search for issues > Advance search bar. If you do a jql search for more than one specific issue key and one of those keys does not exist, it derails the whole search. Apr 30, 2020 · Hi, I am trying to write a JQL query to filter blocking issues for a specific project. On our Scrum Boards we are already using a filter query with IssueFunction in subtasksOf to show all stories of a specific team working in a specific project. A function performs a calculation on either specific Jira data or the function's content in parentheses, such that only true results are retrieved by the function, and then again by the clause in which the function is used. Are you then trying to populate the field with all the linked issues of the original issue? May 25, 2012 · I am trying to figure out a query where top 10 linked issues are returned. Filter Issues by JQL. Is there another way to do this without a plugin on Jira data center? Apr 2, 2019 · I must be doing something fundamentally wrong but this simple query does not work in JIRA JQL: issuetype = Epic In search it works withount any problem, showing me all my epics and if I change to issuetype != Epic again it works showing me all non-epic issues. For example I can search for issuetype and also for type – it’s the same. Apr 18, 2024 · A JQL statement is a set of criteria that is compared to issues in order to select matching issues. Use {{lookupIssues}} to get the result linkedAllIssues(issueKey,[linkType]) Function to find all issues linked to a given issue and optionally for a link type. To create an issue, you will need to know certain key metadata, like the ID of the project that the issue will be created in, or the ID of the issue type. If you have Scriptrunner in your Jira instance, you can get it using this JQL function: linkedIssuesOf(Subquery, [link name]) So, for your case the JQL would be like this: issueFunction in linkedIssuesOf("assignee= xxxxxx") JQL, or Jira Query Language, is a powerful tool that allows users to search and filter issues in Jira. 29 and older. text ~ "search term" Aug 18, 2019 · Zephyr apis accept issueId. Sep 9, 2019 · For regular JQL, we would use: def jql = "project = ABC and issuetype = Epic" But what we would need is: Issue issue = issue def issuekey = issue. To get children of initiatives based on more advanced criteria you can install our professional indexing service: JQL is a powerful search language specifically designed for Jira that allows users to create complex queries for issue tracking, advanced filtering, and reporting. JQL (Jira Query Language) is a powerful query language that allows you to search for issues in Jira based on various criteria. As always, I will be talking about functionality that is in Jira “Out of the box. key}}")" to find the parent issue of an an epic whenever it's updated. Dec 23, 2020 · I am in a situation where I have a Basic JQL i. Learn more about services in Jira Service Management. It validates that there is at least one character preceding the dash, but it does not validate that May 29, 2020 · Here is my JQL condition: key = {{webhookData. You will need to include each Initiative, by key, in the format I provided above. To get the wildcard support, use our professional indexing service JQL Search Extensions. For example in three projects I can find the list of issues that have been resolved in the last 90 days. What am I doing wrong? Feb 22, 2018 · I need to setup filter that will search 2 strings in Summary field. There must be something missing from changes made this way since I do see manually entered changes in other tickets when querying with this JQL function. Jul 2, 2020 · In our documentation, what you mentioned as a Jira ticket number (example: OP-12345) is called an issue key. It must contain a dash ('-'), and the substring following the final dash must be a valid number. Aug 28, 2023 · I am trying to find the query to show linked issues in an epic. The following pictorial representation: PORTFOLIO EPIC EPIC1 Issues/stories EPIC2 Issues/Stories EPIC3: Issues/Stories Attempted JQL: issuekey in childIssuesO Oct 18, 2018 · Here I would like to get issuekey in the result returned by JQL query in validator. The above will display all issues including stories and subtasks beneath Epic ABC-9876 that are in any status except "Done" Jan 29, 2018 · To quickly pull up parent or child issue of an issue via JQL and search issues within Portfolio hierarchy. To get all child issues (Epics, Tasks, Subtasks, Stories, User Stories) for multiple initiatives in JIRA using JQL, you can use the issueFunction in hasLinks() function provided by the ScriptRunner plugin. One with key TST-1 and one with key CONF-1747 . Mar 29, 2019 · Hi, Bernardo - firstly, the query you're trying to use contains a ScriptRunner JQL function, and must be preceded with issueFunction instead of issuekey, like this: issueFunction in portfolioChildrenOf("issuetype = Epic AND fixVersion ~ 'DA-R3*'") Nov 6, 2018 · To return all issues that have been "touched" by a specific user on JIRA, you will need to use a plugin to do this. "CONF-301"). Maybe there is a good reason why users have been sending issue lists to one another, but I believe the key to overcoming your adoption problem is in trying to eliminate Jun 10, 2024 · *Scenario:* I have an initiative with 5 epics and a bunch of issues under each epic. Issue History for Jira can help here. onresolve. For parent issues of an issue in a specific hierarchy level in Portfolio for Jira, type issuekey in parentIssuesOf("EX-000"). However, if you are in the Server env, then you can take a look at Scriptrunner for Jira (DC version only) third party add-on for their enhanced JQL functions where you can use to achieve your need. joins two or more queries together to form a complex JQL query. Enter the search query as explained in the cases below and click Enter. configurable; com. 2. Oct 23, 2024 · Regardless Cloud or Server env, you cannot use jql inside the parameters of the out of the box JQL function unfortunately. The point of custom functions contained in JQL queries is to be replaced by native JQL. However, you can manually combine criteria: Example: issueKey = "PARENT-123" OR parent = "PARENT-123" This will: May 17, 2018 · If I understand your question well, you are looking for a JQL that will fetch you all the bugs that are LINKED to that specific bug!!! Considering this is what you're asking, here is the solution for that: You'll need to create a filter as like what is shown below, and name this filter as MyFilter: issuetype = Bug AND issuekey = ABC-12345 Jan 16, 2018 · I'm looking for a JQL that gives all Sub-tasks of parent User Stories that have a specific status in our workflow (New, In Refinement, Ready for Poker, Ready for Sprint). This does some validation on the format of the given String. My recommendation is to use JQL Search Extensions for Jira that provide you a new parameter to search for any updated details on issues. ofbiz; com. Jira Software 9. The query field contains the substring match that you want to find (eg. Initiative->Epics>Stories>Tasks I am going to use this filter to set up a Jira Plan. These are the stops involved in executing a JQL search in Jira: Jira finds an app-defined function in the JQL query. A keyword in JQL −. issuekey in ChildIssuesOf(ABC-9876) and status != Done. When I send it with Rest api, because the issue is not created, so it does return the bad request. test Dec 16, 2024 · Option 1: Native Jira JQL (Limited Functionality) Out of the box, Jira's JQL doesn't natively support hierarchical queries like returning both a parent and its children (sub-tasks or portfolio-style children). uhtxewodjrkojckytwsjslyotzrhfmjalwgqspybpdamaymfyjfwxnvmdfnrguydbfznusc