Jira query contains. Find parents issues which contains subtasks with label.

Jira query contains We'll call. What is the best way to use JQL to find text in the title of a Jira issue? A simple jira advanced search can be something like: However, I think the string feature-55 will be A simple query in JQL (also known as a “clause”) consists of a eld, followed by an operator, followed by one or more values or functions. As soon as a sprint is started you will want to use a different query. {0,10}$") 3 days ago · Jira Query Language (JQL) is a powerful tool that allows you to search for issues within Jira. Ask a question . "project in (UKSCR, COMPRG) AND issuetype = Bug AND labels in (BAT)" and "project in (UKSCR, COMPRG) AND issuetype = Bug AND labels = BAT" don't work because they both brin Solved: JIRA server -- is there a way to do a search on a multi-select field to only return issues where there is more than one value selected? thank. Step 1: Define a Filter based upon [all other teams] which gives me the issues solely blocked by my team. It doesn't look possible, but wanted to get that confirmed. A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or JIRA fields. The parent of a specific issue can be found by querying the “Parent issue ID” column, Add a third query by selecting Add query and choosing Copy of Query 2. If you want to find issues for “ABC-*” then you would simply use “project = ABC”. ie. EAHA, EAHB, etc) you wont be able to do a wildcard search. the query contains any of the comparison operators: !=, IS, IS NOT, >, >=, <, <=. I'm New Here. It will return all issues which at least have one sub task issue in subtaskCountGreaterThan(1) CONTAINS: ~ The ~ operator is used to search for issues where the value of a specified field matches a specified value: either an exact or fuzzy match. Specific Jira issues may be selected by providing a proper Jira Query Language (JQL) query. A "labels IN (x, y, z) AND labels NOT IN ()" clause could work but there are too many labels to exclude, and they're always changing. Stack Overflow. My query happened to be extremely long, so long that the page wouldn't scroll down to see results. We work with Jira and separate the issues for the two platforms with different components ("iOS" and "Android") as well as with the prefix "i:" or "a:" ore sometimes "iOS:" or "Android:" in the summary. JIRA query that returns all Epics that contain an issue that is assigned to me. Jira JQL - Show all child tasks. Jul 9, 2024 · Jira Query Language doesn't support that kind of text search natively. Query that returns issues without parent in JIRA. For example, if you enter summary ~ "\\"saturn summer sizzle\\"" as a JQL query, the search results wil CONTAINS: ~ The ~ operator is used to search for issues where the value of a specified field matches a specified value: either an exact or fuzzy match. . To find issues that contain "error" in the summary and are assigned to a specific user, use. 0 Trying to construct a JIRA filter that shows results where the labels contain any combination of (x, y, z), and nothing else. Jira jql query to search for tickets that status changed to a particular status after a date. cancel As you are using I want to do this, but with grouping (because I will have more than 2 terms, and I'd like to keep the query easy to read and short-ish): description ~ term OR description ~ "different thing" jql; JIRA JQL Query - Filter by multiple texts on summary field JIRA How many values contains a field - JQL. if you are open to solutions from the Atlassian Marketplace, this would now be easy to do using the app that my team and I are working on, JXL for Jira. However, I realized it simply doesn't work. But this is probably not fully what you want. It definitely can be confusing when just the word key is Hello, I'm trying to run a filter for all open bugs that contains in their 'description' field, two different words, Mars and 2nd word, Galaxy. When constructing your JQL query, it’s important to tell Jira where it should search for issues by including or excluding specific Oct 16, 2020 · Hello, I'm trying to run a filter for all open bugs that contains in their 'description' field, two different words, Mars and 2nd word, Galaxy. I believe that I have it set up correctly but would like some help if not. A quite similar JQL query to the previous one will show you issues in open sprints: sprint in openSprints() Hint: depending on the configuration of your Jira instance it is possible that the feature "Parallel Sprints" is enabled. If i type bellow syntax, i get no results: project in (cosmos) AND issuetype = Bug AND status = Open AND description ~ "Mars Galaxy" Is there a type of q Oct 27, 2017 · Understanding Issue Types in Jira; What are Issues in Jira; What’s the difference between a kanban board and a Scrum board? New Portfolio Cloud Experience Beta; Announcement: Project Level Email Notifications for next-gen projects on JSW/JSD Mar 8, 2016 · This page provides information on the syntax for searching text fields, which can be done in the quick search, basic search, and advanced search. and other query to get names of Epic names As soon as a sprint is started you will want to use a different query. There are other ways too but this is the simplified way. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you Solved: Hi, Im trying to save a filter with a JQL of all issues thah DO NOT contain a certain label. Here is a breakdown of the main components of JQL. But if I try to do Mar 21, 2019 · Solved: I found an interesting thing in JQL contains (~) search. Jira’s database query language contains several key elements. the number that Jira automatically allocates to a sprint). It uses a human-readable syntax to deliver more complex logic and operators than the ones available in the basic search mode. In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your issues whose summary contains [ICTO*. This works for active sprints and future sprints. Note: This doesn't apply when I have a query to search issues where the summary does not contain multiple different values, but the query is not running correctly. Doing so more than one sprint can be started means WHERE summary CONTAINS win and any multiple character combination after it. Is it possible to find all parent tasks which contains subtasks with that label? (I use ondemand jira version) JIRA query to check if a parent issue has specific sub-tasks. The status name having a Aug 24, 2018 · Could you tell me how to use JQL to check how many Values contains a field (multiple values field) Thanks! Skip to main content. Danamma Muttakkanavar. So basically restrict "comment ~ currentUser()" to some period of time comments were made. I checked "issueFunction in commented" function in Script Runner, but it This produces an old-style SearchContext based on the passed in search query and the user that is performing the search. e ATLASSIAN, JIRA) but I want to filter the field so it only includes issues where the value is part of a list, myField ~ "\"ATLASSIAN,\"" will return issues where both ATLASSIAN is the only value and part of a list. Syntax. assets = (red, blue) etc. Jira JQL to filter on issues that are not part of a particular fixVersion. How can I get my expected results without using any app, directly through the JQL query? To clarify, above is just an example. In that field are 4 checkboxs. Standard JQL doesn't easily allow it but the results can be quickly Apr 25, 2022 · I need to find all Epics that have linked other specific issue types. Manage any business project. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. When using JQL, the key is the term JIRA uses for the id of the issue, e. No. The trouble is there are many teams, and there doesn't appear to be a neat way of saying a label set "contains things other than x" in JQL. 5 days ago · You can use a JQL filter to make a board that shows the relevant issues based on whatever criteria you want. For example, if the ticket contains Comment 2 below, then it should show in the results of the query since it has the "urgent" keyword which is not on the default Aug 11, 2021 · I'm wondering if it is possible to find tickets with attachments containing a specific text string. It does allow you to use some additional JQL functions that can look at parent issues values or subtask issues values in regards to which issues to return. JQL for Finding Open Issues having Linked Issues in status "Done" The only option in JQL I've seen related to comments is the Tilde (~) which I believe indicates "contains. So for me (labels is EMPTY OR labels not in Sharing Official Answer from a high-speed Atlassian Support Engineer: The Description field, along with many of the Jira text fields, leverage the tilde operator as a fuzzy search in order to pull results that are "about the same" as the query. Hope this helps. However, ScriptRunner provides a search function that supports regular expressions, so maybe the following query returns all issues from FOO project with a description of less than 10 characters:. EpicName contains "X"] Or a select within select. Text searches can be done in the advanced search when the CONTAINS (~) operator is used, e. A function in JQL appears as a word followed by parent­heses, which may contain one or more explicit values or Jira fields. How to retrieve Jira issues via REST API when query contains a space. Project and issue tracking. Service management and customer support. Is this possible? In general my concern is, that I have Releases that have a specific nomenclature and I want to filter for the issues that are subordinated, b In the right-hand panel, under Linked Jira field, select the Jira field you want to populate with the information in your form field: Select Save changes . Our instance is Jira Server with Script Runner installed. Ask a question Does the basic query not work - I tried this on a Select List (Single Choice) and it worked: It might be possible for you to use something like the SQL for Jira Driver: Convert JQL to SQL to help here. I have tried using comment !~ "String" or NOT (comment ~ "String") also single quotes around String. the query specifies a field and value that is related to a project (e. Data Center. A quite similar JQL query to the All the literature seems to be for the postive case "find this label or empty" but we're trying to flag issues where the label contains "anything BUT". the query contains an EMPTY operator. ; the query contains any of the comparison operators: !=, IS, IS NOT, >, >=, <, <= the query specifies a field and value that is related to a project (e. A function performs a calcul­ation on either specific Jira data or the function's content in parent­heses, such that only true results are retrieved by the function, and then again by the clause in which the function is used. 7. Name Jira Query Language (JQL) is basically a text-based search language you can use in Jira to find the issues you’re looking for. TEXT. However, this plugin is only available for Jira Server, and not for Jira Cloud. In the new visual mode query, add the Parent issue ID, Issue key, and Issue type columns from the Issue table under “Jira family of products”. First query - "Epic Link" in(<<Epic 1>>,<<Epic 2>>,<<Epic 3>>). 'Variable' FROM T2 WHERE T2. Solved: I want to view JIRA issues by a specific reporter. It seems you can only use JQL to find tickets with attachments. version, component, custom fields) and the project is not explicitly included in the query (e. fixVersion = "4. A JQL function - your query becomes "labels = A and labelCount() = 1" Both of these are really easy to implement if you've got ScriptRunner installed, I've done the field one with my own code and SR, and seen SR create the function as well. I have a JIRA project and some of my tasks contains subtasks with lasbels "needDesign". Could you please explain the intention a bit further? Regards, Daniel Solved: Most of our tickets is grouped inside square bracket like [BE], [FE], etc. Because if an AddOn product can do it, then the original product should be able to do it. The project can refer to the actual name of the Project (e. [EpicLink. Or, or, or etc. Your query would look like this: JQL query for search issues based on substring as wildcard * can’t be used as first character Unfortunately, using JQL of Jira, you’ll not be able to do it. Let's say, I have a custom field called CRank. Jira Work Management. Advanced search lets you search for issues by building structured queries using the Jira Query Language (JQL). If you are using an expression where the value or attribute contains a space, you must include quotations surrounding the value, for example "Ted Anderson". Lastly,. It can also be done in quick search and basic search when searching on supported fields. Ask Question Asked 6 years ago. Supported operators ~ , !~ JQL full form is Jira Query Language is used to search your issues in Jira. Something like "labels ONLY IN (x, y, z)". But if you had scriptrunner in your Jira Cloud instance, you could create a JQL filter like this: Hello Community! Is it possible to use a table transformer to filter out criteria that "contains" text rather than being equal to text? For example, here is SQL query for an exact match: SELECT * FROM T1 WHERE T1. To perform a multiple character wildcard search use the "*" symbol. when I search : labels == Recorrente or labels in (Recorrente) It works fine. I want to do the same thing for the FixVersion/s field. Learn how to utilize Jira Query Language for advanced search capabilities in Jira Service Management. My current queue looks like this: status in ("Awaiting CAB approval", "Awaiting im Feb 15, 2022 · Hello Community! Is it possible to use a table transformer to filter out criteria that "contains" text rather than being equal to text? For example, here is SQL query for an exact match: SELECT * FROM T1 WHERE T1. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. 9. issueFunction in issueFieldMatch("project = FOO", "description", "^. This plugin lets you use more SQL like syntax when querying Jira. Jira Software. Our instance is Jira Server with Script Runner installed. Fortunately, there are only five elements to keep in mind. 7. The native JQL in Jira can't really look at specific values on related issues like this. "Blocked By" is a custom label field, but I presume works with the same operators as the system label field. Is this an industry tread to move more towards swimlanes instead of viewing things as hierarchies? My brain works MUCH better via bullet points and well-structured hierarchies (same way I build class libraries) so working with Jira has been Dec 18, 2019 · Hi, Im trying to save a filter with a JQL of all issues thah DO NOT contain a certain label. About; Products Querying JIRA to Produce Counts of Issues by Different Type. you can also use sub queries for complex searches , JQL makes this easy by scanning and locating specific words or phrases across multiple fields. I cannot implement a marketplace plugin and it has to be native to JIRA. This works if you want to do a one-off analysis. Once you filter out the issues that do contain the text, you can use the "!=" with the filter to find out all the issues that don't contain the text. EAH-123, which is actually the issue key. Export this to excel. Learn more about the power of JQL queries. See examples below. For this example, let’s say we want to find all issues that are urgent, and not done within a specific Epic link. Add a second query by selecting Add query and choosing New query. cancel. {0,10}$") Contains text; You’ll notice the “Advanced” option to the right of the filters: This is where you’ll have access to Jira JQL. In lieu of a function or operator, we've got something working based on the below. JQL fields. but if the asset fild contains one of the valid labels it does not show. ; the query contains an EMPTY operator. Sorry about that. For example: To perform a more complex query, You can use the Jira Query Language (JQL) to specify criteria that cannot be defined in the quick or basic searches. "let us know if this is urgent"). JQL query search in Jira. when Jira Product Discovery ; Jira Service Management ; Compass To essentially run the first part of the query first before the label aspects. This is a GUI bug/issue. 1 description. This works perfectly when the JQL is comment ~ "String" but the opposite does not. CONTAINS: ~ The ~ operator is used to search for issues where the value of a specified field matches a specified value: either an exact or fuzzy match. This returns the values of the parent issues for Jira issues Query/filter to return child issues from a list of active parents (EPICs) Hot Network Questions Animated series begin 2000s or just before with samurai and evil twin any operator which works as LIKE operator to search by part of string in JIRA; any operator which works as LIKE operator to search by part of string in JIRA . Hi, I work in a scrum team where we are developing a mobile app on Android as well as on iOS. issue in wildcardMatch("summary", "[ICTO*") Please contact our support if you have any other questions about this query. It is a text field. That said I’m confused by your request and example. 'Index' = 1) Feb 17, 2021 · I haven't used Jira for a few years, so when I switched back from Azure DevOps I was surprised that this still isn't supported. 0. You might be troubleshooting, reviewing updates, or tracking customers’ contains: ~ The ~ operator is used to search for issues where the value of a specified field matches a specified value: either an exact or fuzzy match. With this query, Jira will find issues where the summaries contain both the exact phrase "full screen" and any other phrase that includes the exact word combination "full I am using a standard JIRA Software project with epic -> story -> (sub)task hierarchy. 'Fix Version/s' = (SELECT T2. So for example if the client ID contains multiple values separated by a comma (i. Issues->Search for Issues->Contains text doesn't find all issues that contain text when the text is part of a hyphenated word. That being said, the syntax for doing something similar to SQL’s LIKE statement is nothing like how you’d do it in SQL. 1. For example: To perform a more complex query, you can link clauses together with keywords. If i type bellow syntax, i get no results: project in (cosmos) AND issuetype = Bug AND status = Open AND description ~ "Mars Galaxy" Is there a type of q This should be simple but the results don't match my expectations. I'm trying to set up individual filters for the design dashboard, Dev dashboard, and QA Dashboard. Searcher returns This query will show all issues in project "DEV" that are assigned to future sprints. For example, you can use the ORDER BY clause in a JQL query to search e. Follow Query JIRA to get FIX versions for the given JIRA issues. A Jira Query Language example using AND. If no JQL query is provided, all objects having Jira issues connected are returned. Components I'm looking are different strings such as Eagle or Shark. JIRA Query (JQL) to filter those issues within a certain set of EPICs. JQL for specific condition. Product Q&A Groups Learning Events . Sep 9, 2019 · Thanks Ste, I appreciate the suggestions. 4") AND fixVersion IN versionMatches("29. Sprint. Solved: My goal is to run a JQL search on a single Jira project and a Select List custom field that contains a list of our Jira projects. There are two types of wild-cards in JQL: ? and * where: To perform a single character wildcard search use the "?" symbol. With straight JQL if you are trying to find issues from a project with key EAH, then you can query for: project=EAH . So maybe that might help in your current approach. How can I get around this? the query contains a NOT operator. To see the results of my query, I had to zoom out quite a bit (50%) on the page to be able to see the lower section's small vertical scroll bar so that I could scroll through results. The search is based on either the sprint name or the sprint ID (i. "Tested" "Design Reviewed" "Code Reviewed" & "Needs Review". Elements of a JQL query. A field that counts labels - your query becomes "labels = A and 'count of labels' = 1" 2. Something like At the moment, unless we map every Forms field to a Jira field, they will not be searchable through the JQL query, we have a request feature created for this topic: JSDCLOUD-10507 - JQL search/basic search on ProForma/Forms fields; Therefore, you can link form fields to Jira fields to ensure the JQL work as usual. For example, the jql below works : Advanced search lets you search for issues by building structured queries using the Jira Query Language (JQL). Jan 7, 2019 · Need to find a JQL query to search for the keyword "urgent" which was commented by the reporter, but note that this keyword is being used in a default response in comments (i. Users may input Sep 23, 2020 · We need to get all tickets when user is mentioned recently (e. Since JIRA cannot search for issues containing parts of words, word 'stemming' allows you to retrieve issues from a search based on the 'root' (or 'stem') forms of words Use this Jira JQL cheat sheet as your comprehensive guide to mastering Jira Query Language for advanced searching and filtering in Atlassian’s project management tool. I expect to see them because they contain the components I'm looking for. An example of my query: issuetype = "issuetype1" AND (summary !~ "ABC" OR summary !~ D OR summary !~ "EFG") ORDER BY reporter ASC JIRA return no result even I have tickets that contain the text "[A]" in the summary. ; the query contains any of the comparison operators: !=, IS, IS NOT, >, >=, <, <=. 22. the query contains a NOT operator. You can get all child issues of Epics in one query , however when you export this to excel, the Epic names are not exported. 0 Jira Query Language (JQL) is a versatile and powerful tool that allows users to create sophisticated queries to find issues in Jira. Jira Query Language (JQL) is a query language that’s quite similar to SQL. 0") AND labels = Test. last X days). Even matching all the fixVersions that contain "keyword" (such as "my-keyword-version") would be helpful. Field Type. The more acurate context can be gotten by calling getQueryContext(ApplicationUser, I need to be able to search a paragraph text field in Jira issues for strings that contain a "-" character and a wildcard. asset = (one, blue) is not shown, but in fact I would like it to show. For example: If. 1. For example, I want to search for tickets with a comment containing a name "Smith" and later in the comment, the word "fixed". Jira Service Management. The more acurate context can be gotten by calling getQueryContext(ApplicationUser, Unfortunately, using JQL of Jira, you’ll not be able to do it. It only doesn't work for "[A]", if i try with other letters, it works. here's the JQL <project = OE AND issuetype = "Epic/Feature" ORDER BY updated DESC> and here was my mod to filter out the labels contain "delete" <project = OE AND issuetype = "Epic/Feature" AND labels !="delete" ORDER BY updated Jira; Questions; JQL QUERY CONTAINS COLON; JQL QUERY CONTAINS COLON . To get the most This query finds all issues where the summary and description contains words starting with "roadmap" and "log". Each one plays a different role in building Jira queries. The closest you can get is probably by listing all the project keys manually in your query: Hi @James K_. I am presuming it is the hypen that is causing this. Searching for issues in open sprints. By leveraging JQL, you can create complex queries to extract the exact information you need from your Jira projects. Jira Query Language doesn't support that kind of text search natively. I tried " ", but Jira didn't like the empty string operator. Because I immediately think logically and try using standard database "Query Language" syntax alternatives. JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e. g. How to search a text field for multiple possible values in JIRA. So I need a query that tells me if just "design reviewe If you are using an expression where the value or attribute contains a space, you must include quotations Specific Jira issues may be selected by providing a proper Jira Query Language (JQL) query. Remove the This works fine if ie. Check the JIRA advanced searching guide and the wild-card explanation here. Turn on suggestions. Add a filter where the Parent issue ID from the Issue table is not null. I'm struggling with a JQL query that will bring back issues with a specific label, even if there are other labels on the issue. If you are trying to find issues from project with key's starting with EAH (e. Viewed 4k times 2 I'm trying to retrieve all issues from a project that are status "New Ticket". Modified 1 year, 9 months ago. Workaround steps: I have a custom field "Review" for my "core" Project. summary~"windows*". Apr 24, 2020 · Hi Guys, I'm looking to filter out "user submissions" as my key words from my open queue, but i've been struggling with doing this the basic way, so i've had a look at via JQL, however i'm struggling on the SQL also. " However, I want to find all issues with comments, not just those, and I don't know how I can do that with ~ because I can't know what the comments might contain. Any assistance would be greatly appreciated Sep 21, 2022 · I am working on JIRA Cloud and would like to get a list of records where a certain comment does not appear. Deviating from the syntax that inspired it isn’t uncommon, but it’s quite peculiar that Jira Query Language reserves the word ‘LIKE,’ even when not explicitly used for fuzzy A query to both Affects Version/s and Fix Version/s I was able to form like the following (on top added labels): affectedVersion IN versionMatches("27. I was hoping that following will work but it seems that colon is a reserved symbol. Search for issues where the description contains particular text using Jira text-search syntax. I am using JIRA v7. I checked "issueFunction in commented" function in Script Runner, but it seems it doesn't allow search by comments text. More about searching syntax for text fields. Ask a question ^ This located all issues containing a partial query - in this instance, I searched for three letters and it located multiple 1. For example, if you enter summary ~ "\"saturn summer sizzle\"" as a JQL query, the search results will only include issues where the summary Hi , I wants to search the String "[XXX]" in sub tasks BUT I wants in result list only sub tasks which contain [XXX] and don`t wants to recieve sub tasks which contain only XXX This is the query I wrote , but I also sub tasks which contain only XXX without [] : issueFunction in subtasksOf("issu Find parents issues which contains subtasks with label. For example, if I search for 1553, the issue that contains ICD-1553 in the summary doesn't show up. Possible ideas (no luck with any of them yet): Yes I have tried this format but the comma is being ignored. It's being updated to provide more accurate results when searching for an exact phrase. Thanks! jira; Share. I Finally, figured it out! You can find issues that have only one label and the label is "Foo", and also exclude any other labels with the following query: This is not possible. It is possible to search for parts of what is written in the summary field (with ~). project = TEST AND in (currentuser())assignee keyword ˜eld operator function I'm new to using JQL and after having a look at the resources I'm still unable to make the search query: Parent string contains. However , one query to fetch Issue keys of the all the required Epics. JQL is a powerful search language specifically designed for To search for documents that must contain "jira" and may contain "atlassian", use the query: Just execute this query and it will Search for subtasks with a parent's summary containing a particular text xxx. Auto-suggest Just surround the searched key-word with single quote marks if it contains any special chars. With this query, Jira will find issues where the summaries contain both the exact phrase "full screen" and any other phrase that includes the exact word combination "full It doesn't return the PROJ-1002 and PROJ-1006. 0", without the AND project=JRA). How do you look for jira tickets with comments containing two text strings with many possible strings in between the two. Auto-complete. A JQL query is a set of words and operators that define how JIRA will narrow your search. We need to get all tickets when user is mentioned recently (e. Jul 6, 2021 · Hi, With standard JQL you can only get a list of issues with remote links and export them to Excel for further processing. e. Excel or Google Sheets. The issuekey isn’t a text field. Create . Hi, I use colon ":" in the summary of my Epic and I want to list the Epics where I have missed putting colon. Every Armadillo Hiccups) or the shortened code of the project (EAH), which they refer to as the project key. Faisal Ladak February 26, 2019 . This will only make sense if the query returns true for doesQueryFitFilterForm(ApplicationUser, Query) since SearchContext is only relevant for simple queries. JQL is a flexible yet robust logic that can be used in a variety of different ways. Note: To link form fields with Jira fields, certain criteria must be satisfied, or Use advanced search with Jira Query Language (JQL) Cloud. 2. Field – Fields are different types of information in the system. In order to create Jira queries, you need to know what’s inside them. I just wish they hadn't called it JQL = Jira Query Language. Search for issues that are assigned to a particular sprint. 4. How can I search subtasks starting with those words? I've tried: Once in excel create some filter on Component column like: text filter>does not contain "," now that you have filter wich are with just one component, copy all your showed results, and paste them in another sheet. Improve this question. With this query, Jira will find issues where the summaries contain both the exact phrase "full screen" and any other phrase that includes the exact word combination "full From the docs. Is there a way to query/filter all issues (stories and tasks/sub-tasks) whose epics along the ancestral chain contains a given word? Something like: project = Foo and "Epic Link" ~ Bar When I try the above, I get I am using JQL Search Extensions for Jira & reports and following query will fulfill this need if you use the same plugin. Name Description; connectedTickets() All objects The “Issue” table contains information about your Jira issues. For example, I want to find all the Epics that have at least the highlighted Apr 30, 2021 · Select * from Project [project-list] where label contains ["xyz " or "xyz-"] I am running into the issue that I am not able to find a function in JQL to support the "Contains" clause. 'Index' = 1) Is there a way f This produces an old-style SearchContext based on the passed in search query and the user that is performing the search. mhlktdhh qqzc xxlai aokr vitm yfry kpgqisl jkel yotmzzm taem