nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL CONTAINS ~ operator doesn't work with 'Parent' fields

Maja Zuchowska

JQL CONTAINS ~ operator doesn't work with 'Parent' fields.

Use case: JQL advanced search eg. finding tasks with a certain condition under Epics containing particular name of the system etc.

Issue: JQL search does not accept ~ operator for Parent type fields (before the change to Parent, the Epic type fields could be associated with it).

Am I missing something, or is it a feature request?

Accepted answers

Fazila Ashraf

Hi @Maja Zuchowska

Could you give a sample JQL to understand what you refer as 'Parent' type fields? Is the field Parent or fields associated with parent?

Hannes Obweger - JXL for Jira

Hi @Maja Zuchowska

to the best of my knowledge, the contains operator isn't available for the parent field. You'll need extra tooling for this.

E.g., if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

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. Excel or Google Sheets. It also comes with a number of advanced features, including the ability to perform text filtering on all issue fields, like so:

For more advanced use cases, you can also use logical operators and even regular expressions.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

All comments

Fazila Ashraf

Hi @Maja Zuchowska

Could you give a sample JQL to understand what you refer as 'Parent' type fields? Is the field Parent or fields associated with parent?

Maja Zuchowska

Hi @Fazila Ashraf thanks for reaching about it. I actually refer to Parent (I know some teams are using ParentLink or Parent Name as well, but that's optional).

Maja Zuchowska

Here is an example of a search I was hoping to use:

project = "CODE"

AND type IN (Task, Bug, Support, Sub-task)

AND status NOT IN (Done, Cancelled)

AND assignee = empty

AND parent ~ 'part of name'

ORDER BY created DESC

Fazila Ashraf

Unfortunately the parent field only stores the issue# and not the summary.

~ is not an operator designed to work with the field yet. See https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Parent

If you have some apps that provide additional JQLs like JQL Search Extensions for Jira or Scriptrunner , you could workaround this problem though.

Hannes Obweger - JXL for Jira

Hi @Maja Zuchowska

to the best of my knowledge, the contains operator isn't available for the parent field. You'll need extra tooling for this.

E.g., if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

For more advanced use cases, you can also use logical operators and even regular expressions.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Maja Zuchowska

Hi @Hannes Obweger - JXL for Jira thanks for that, looks interesting, may give it a go

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql