Cascade LOV – load
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
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.