Good Morning,
My name is Hugo Maurício, i work in the company Deloitte.
I have an problem with the custom fields in Service Desk, i want to make a rule using the addon ScriptRunner but when i put in the code,
"cfValues['Customer Request Type '] == 'Marcação de videoconferência'"
It do nothing. What i want is that the email only bee sent when the costumer selecet the request type "Marcação de videoconferência",what is the way to call that block field as it is written on the top?
Best Regards,
Hugo Maurício
Is Customer Request Type a select list? If so you need
cfValues['Customer Request Type ']?.value == 'Marcação de videoconferência
Hi Hugo,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
With recent Service Desk version, "Customer Request Type" value consists in a `project/UUID` string which can be found in database tables AO_54307E_VIEWPORTFORM (key) in relation with AO_54307E_VIEWPORT (key).
Refer to SQL query available at https://community.atlassian.com/t5/Jira-Service-Desk-questions/Re-set-customer-request-type-with-script-runner/qaq-p/120737/comment-id/1213#M1213
SELECT concat(lower(p.pkey),'/',vform.key) as value FROM jiraissue i , project p, issuetype t , AO_54307E_VIEWPORT vport, AO_54307E_VIEWPORTFORM vform WHERE p.id = i.project AND i.issuetype = t.id AND i.project = vport.project_id AND vport.id = vform.viewport_id AND vform.issue_type_id = t.id AND i.id = 'PROJECT-123';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So if I have a request type, of type "After Sales"
My condition will by like this?
cfValues['Customer Request Type']?.value == "projectKey/After Sales"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to use SQL query above to find out Customer Request Type <<UUID>>.
Then condition has to test for value "projectkey/ed3df54d-5f13-4b7b-8010-07aca15d68c4" (an example from my setup)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How do you get the value for the different Request Types (UUIDs)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
With the mentioned "SELECT" SQL statement from my answer, to be executed in JIRA database itself directly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Helder,
you can extract the UUIDS via scriptrunner script console. If you have an issue with the selected option:
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.issue.customfields.CustomFieldType
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def issueManager = ComponentAccessor.getIssueManager()
def issueObject = issueManager.getIssueObject("issuekey")
String customFieldId = "customfield_10009"
CustomField customField = customFieldManager.getCustomFieldObject(customFieldId)
String fieldValue = issueObject.getCustomFieldValue(customField)
return "KEY: "+fieldValue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.