search value "customer request type"

I want to find issues based on field values "customer request type" (service desk).
Works: "Customer Request Type" = empty!
It does not work: "Customer Request Type" = 'Task'

Is there any way?
Thank you.

5 answers

1 accepted

0 votes
Steven Behnke Community Champion Feb 01, 2016

sad This field isn't properly supported yet. A few of the Service Desk fields seem to be like this. Please see the reported bug – https://jira.atlassian.com/browse/JSD-1583

Workaround

Customer Request Type values follow the format of "key/lowercased-form-title-hyphenated", so it may be possible to guess.
For example project key of "ITS":

  1. General Assistance = its/general-assistance
  2. Infrastructure Support = its/infrastructure-support
  3. Telecommunications / Telephones = its/telecommunications--telephones (notice the double hyphen on this one)

I've also noticed that this value is determined when the form is FIRST created, and if you change the name of the form, it doesn't change the title. I've also seen some values that look like "req/its-request2" where it apparently added a number on the end to make it unique. I think that happened because I had two identically named forms when I first set up that project.
Maybe that will help you reverse engineer things and get some queries working.

I failed to work.
I hope that Atlassian solve it in a new version.

thanks.

What is type for this custom field?

It is a field created by service desk

CustomerRT.png

 

Hello

Discovered this today, no need to guess.

In the table AO_54307E_VIEWPORTFORM, the value of KEY will hold the string that may be searched by. 

Steve is correct, the spaces are frequently replaced by hyphen, however this may be one or more hyphens, and the 'CALL_TO_ACTION' field may or may not match the key.

The string format for the JQL is "<lower_case_project_key/key_from_AO_54307E_VIEWPORTFORM_table>"

This select help find all possible value for Customer Request Type

select distinct cfv.stringvalue, a.name
from customfieldvalue cfv,
AO_54307E_VIEWPORTFORM a,
customfield b
where b.id = cfv.customfield
and b.cfname = 'Customer Request Type'
and substr(cfv.stringvalue, 4) = a.key;

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,760 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot