Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to get list of value in Custom Field based on Category
in Help Desk
Summary:
Hi,
I had created one custom column and choose field type as Choice List (Fixed) and assign Lookup Type.
I need to show the list of value of the custom column based on Category selection.
I defined the Category value in Tag of lookup.
Below Sample Groovy Script I am using.
def var_categ = getSelectedListDisplayValue("CategoryId")
def vo = newView('CommonLookup')
def vc = vo.createViewCriteria()
def vcr = vc.createRow()
def vci1 = vcr.ensureCriteriaItem('LookupType')
vci1.setOperator('=')
vci1.setValue('REQUEST_TYPE')
vc.insertRow(vcr)
vo.appendViewCriteria(vc)
vo.executeQuery()
while(vo.hasNext())
{
def row = vo.next()
if(row.Tag == var_categ)
Tagged:
0