Populating Value Lists through scripting

[Former Member]

Hello,

If anyone has worked on a script to populate an extension field with a Value List Value, please let me know.

Thanks & Regards,

Reshma

[Former Member]

Hi Reshma,

I think there are ways to call SQL query in beanshell (Java Scripting)

But need to explore a little bit. Will try and let you know

Regards,

Vaibhav

Edited by: Vaibhav Modi on Nov 21, 2009 3:30 PM

[Former Member]

Hi Vaibhav,

So we would have to create a JDBC connection to the database and write a query inside it?

Do let me know if you get this to work.

Responding to your earlier question, to add an extension of Value List type, create an extension definition field and choose the data type as 'Value List' and choose the type.

Regards,

Reshma