Cascade LOV – load

Hi,

Is there a way to create a cascade list of values with a load?

Thank you,

Dorota

Agile User Asked on September 10, 2019 in Product Collaboration.
Add Comment
3 Answer(s)

Unfortunately, no.  The creation of a list of values for a cascading list must be done manually.

Agile Angel Answered on September 10, 2019.
Add Comment

Hi Dorota,

You can build a PX which consumes a file to  create/update the values in Cascade List. Please make sure you handle the special Characters  while creating/updating  list entries.

Thank You,

Karthik

Agile Talent Answered on September 11, 2019.
Add Comment

Hi Dorota,

Depends on the count of LOVs. If it’s really huge list then i suggest writing a simple groovy script event. Personally tried it and it worked fine.

You can create an event of Event-Type : Extended Tools Menu and in Groovy Event-handler you could write code as shown below:

//The ListVals.addChild is where you specify your cascaded list-values in “|” separated format

—————————————————————————-

IAgileSession session = obj.getAgileSDKSession();
IAdmin admin = session.getAdminInstance();
IListLibrary listLib = admin.getListLibrary();
IAdminList list = listLib.getAdminList(“CascadedFruitList“);
IAgileList ListVals = list.getValues();

ListVals.addChild(“Fruit|Guava”)
ListVals.addChild(“Fruit|Apple”)
ListVals.addChild(“Fruit|Mango|Alphonso”)

list.setValues(ListVals);

—————————————————————————-

let me know if you get any issues in executing it.

 

Regards,

Arif

This should work fine.

 

Agile Angel Answered on September 12, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.