You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get list of value in Custom Field based on Category

Question
32
Views
0
Comments

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) 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!