PCFU - Single Select field getting value

[Omprakash Thamsetty]

Hi,

I am using power database custom field single selection type to display dynamic values. When I am trying to get the value in groovy script it return as

" [SocOptionImpl{label='Lastname, Firstname', value='Lastname, Firstname'}] "

How I can just get Value from output?

I used SQL data source with PCFU - Single Select custom field type to display dynamic list value.

Thanks,

Om

[Alexey Matveev · Accepted solution]

Hello @Omprakash Thamsetty !

Could you provide your groovy script?

[Alexey Matveev]

Do you use Power Database Fields or Power Custom Fields Pro?

[Omprakash Thamsetty]

Power custom field pro and data source is SQL 

[Omprakash Thamsetty]

Hello @Alexey Matveev 

Here is the script and field configuration

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.event.type.EventDispatchOption
import com.atlassian.jira.issue.MutableIssue
import org.apache.log4j.Category
import com.atlassian.jira.issue.IssueManager;
import java.sql.Timestamp
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.util.IssueChangeHolder
import com.atlassian.jira.issue.*
import java.util.Date
import java.text.SimpleDateFormat
import java.text.DateFormat
import java.text.ParseException
import java.sql.Timestamp
import com.atlassian.mail.Email
import com.atlassian.mail.server.MailServerManager;
import com.atlassian.mail.server.SMTPMailServer;
import com.atlassian.mail.queue.MailQueue
import com.atlassian.mail.queue.SingleMailQueueItem
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.web.bean.PagerFilter
////////////////////////////////////////////////////////////////////////////////////////
//Used for testing on specific issue
def IssueKey = "SS-129"
def issue = ComponentAccessor.getIssueManager().getIssueObject(IssueKey)
////////////////////////////////////////////////////////////////////////////////////////
MailServerManager mailServerManager = ComponentAccessor.getMailServerManager()
SMTPMailServer mailServer = mailServerManager.getDefaultSMTPMailServer()
CustomFieldManager customFieldManagerobj = ComponentAccessor.getCustomFieldManager()
// Logger
//def Category log = Category.getInstance("com.onresolve.jira.groovy.PostFunction");
def user = ComponentAccessor.jiraAuthenticationContext.getLoggedInUser()
def IssueManager issueManager = ComponentAccessor.issueManager
def issueLinkManager = ComponentAccessor.getIssueLinkManager()
IssueChangeHolder changeHolder = new DefaultIssueChangeHolder();
Calendar cal = Calendar.getInstance();
//MutableIssue issue = event.issue as MutableIssue

// Set the logging level to DEBUG
log.setLevel(org.apache.log4j.Level.DEBUG);


def extrepoter = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectsByName("External Reporter").first()
def extrepoterval = issue.getCustomFieldValue(extrepoter)

log.debug "External reporter ${extrepoterval}

[Omprakash Thamsetty]

Here is the file configuration

[Alexey Matveev]

Thank you for the details @Omprakash Thamsetty !

PCFU returns a List of SocOptionImpl class objects. 

SocOptionImpl has two methods:

getLabel() - get the Label for the current value

getValue() - get the current value.

You use the single select field, that is why this list contains only one value and you can write a code like this:

def extrepoter = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectsByName("External Reporter").first()
def extrepoterval = issue.getCustomFieldValue(extrepoter)

log.debug "External reporter ${extrepoterval?.get(0)?.getValue()}"

[Omprakash Thamsetty]

Hi @Alexey Matveev I am able to get the value but it is showing error in script console as unable to find matching method get

[Alexey Matveev]

@Omprakash Thamsetty ,

Do not pay attention to this error. The problem is that you use def from the extrepoterval variable. Which means that the real class of this variable will be defined at the runtime and that is why the error checker does not know which methods this class has.