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?

[Roman Zolotarevskyi · Accepted solution]

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! 

[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

[Roman Zolotarevskyi]

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

[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

[ramyaallena]

Have you tried in Basic search instead of JQl. 
Once please try that as well, so we will get to know if that's the issue with JQL or not

[Roman Zolotarevskyi]

basic filters work

[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 

[Evgenii]

Roman, what type of field is "SalesRepresentative"

[Roman Zolotarevskyi]

People

[Evgenii]

Well, it's possible, that there are no hints. 

Please, try query like: 

issuetype = Epic AND "SalesRepresentative" = "Anna Surname"

[Roman Zolotarevskyi]

this does not work - I still do not see the Sales Representative with that name when apply the filter with this

But the name is exist:

[Evgenii]

Hmm, let's try workaround.

Switch search to basic mode

Then select needed field, from +More

Then select in field needed user.

And then Switch to JQL. It will show your needed request, which you can use for other users

[Roman Zolotarevskyi]

The basic search works.

And I got the query:
"SalesRepresentative[People]" in (5d404b47813f380dab350ab4) AND project = CSM007

But when I put it in the Filter query > Save > go to Board > Select the custom filter > it shows nothing at all

[Roman Zolotarevskyi]

Do you have any thoughts why it does not work?

[Emanuele Covello]

Hi, I also have a similar problem.
From custom filter i want to add a filter that target a specific label. This should be the easies use case in Jira world but unfortunately it doesn't work.

I tried from issues and there the filter works. I saved the filter but this is not available to be used in custom filters for the backlog. Trying to copy the same query from issues to custom filter it doesn't work. How is that possible? Is it the same tool?