How to add "Request Type" (available under Service Desk request) in filters

[Nishant Kumar]

Hi,

I am using "https://eteamproject.internal.ericsson.com/" link to access my JIRA board.

I want to add filter on Request Type in the existing filter, i am not getting any option to do this in Basic / Advanced mode. 

Kindly assist me.

Regards

Nishant

[Jack Brickey · Accepted solution]

Hi Nishant, the field is called “Customer request type” in JQL.

[Jack Brickey]

Hi Nishant, first let me convey that it is best to use the "Reply" button here so we keep the thread clean for future observers. The "Answer" button is meant to be used to offer an answer to the original post.

That aside...

So there are a couple of errors in your JQL. First the actual error is caused because you placed JQL logic after the ORDER BY which should be at the end of any JQL. The second is that you have an "AND" between the two request types. Since an issue can only have a single Request type you should use an OR, or better yet the "in" operator. So try this...

project = DE3 AND "Test Environment" in cascadeOption(16849) AND "Customer Request Type" in ("STP Assistance (DE3)", "STP Incident (DE3)") ORDER BY created DESC

[Jack Brickey]

Nishant, please keep the discussion under this answer not yours.

as I stated above use the "in" operator and list all request types you want included in your search....

... AND "Customer request type" IN (a, b, c, d)

replace a, b, c w/ your RTs

[Nishant Kumar]

Thanks for your help.

[Nishant Kumar]

Hi Jack,

Thanks for the answer, I got the field.

Can you please tell me how to use it in the existing filter. I am getting error. Refer below print

Filter 

project = DE3 AND "Test Environment" in cascadeOption(16849) ORDER BY created DESC, "Customer Request Type" = "STP Assistance (DE3)" AND "Customer Request Type" = "STP Incident (DE3)"

Error: 

Error in the JQL Query: Expecting either 'ASC' or 'DESC' but got '='. (line 1, character 109)

Regards

Nishant

[Nishant Kumar]

project = DE3 AND "Customer Request Type" = "STP Assistance (DE3)" AND "Test Environment" in cascadeOption(16849) ORDER BY created DESC

Seems working for me, but how i can add STP Assistance and STP Incident in same customer request type.