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; } } }

Custom filter

Roman Zolotarevskyi

Hi guys,

I have epic 'Epic1'

This epic has a custom field 'SalesRepresentative'.

I want to create a custom filter and search only epics which contain people 'SalesRepresentative' = 'Anna'

'Anna' - is not a text field, but the user.

Could u plz advise what should I put into Filter query?

Accepted answers

Roman Zolotarevskyi

I believe it is some bug in jira!
The resolution: today I created a new epic and assigned a guy in the SalesRepresentative field. After that the custom filter suddenly began to work properly.

Hope it helps someone!

All comments

Evgenii

Hi, @Roman Zolotarevskyi

You can use such JQL request

issuetype = Epic AND "SalesRepresentative" IN (username1, username2, username3)

If you want to use only one user in search query you can use such JQL string:

issuetype = Epic AND "SalesRepresentative" = username

Roman Zolotarevskyi

somehow it does not provide me with the users
Screenshot 2023-06-21 at 20.18.54.png

ramyaallena

Hi @Roman Zolotarevskyi

You can use this simple JQL :

project = <ProjectName> AND type = <Issue Type> AND 'SalesRepresentative' is EMPTY : this gives the issues which don't have any value in the custom field.

project = <ProjectName> AND type = <Issue Type> AND 'SalesRepresentative' is not EMPTY

This JQL gives the issues which have values in that custom field.

Thanks,

Allena

Evgenii

Roman, what type of field is "SalesRepresentative"

Roman Zolotarevskyi

but I need to filter the fields that contain the user, for example 'Anna Smith'

Roman Zolotarevskyi

People

ramyaallena

project = <ProjectName> AND type = <Issue Type> AND customfield_10000 = john.doe

Customfield_10000 is the cusmfield_ID

Could you Please try with this?

Roman Zolotarevskyi

issuetype = Client AND "SalesRepresentative[People]" = 5d404b47813f380dab350ab4

does not work

Roman Zolotarevskyi

I believe it is some bug in jira!
The resolution: today I created a new epic and assigned a guy in the SalesRepresentative field. After that the custom filter suddenly began to work properly.

Hope it helps someone!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud