jsnosal - Tuesday, January 14, 2014 2:54 PM:
Has anyone used a SQL view for drop down list inside of ARAS? I have the view created and I know what I want the end result to be. The view is one column with distinct names.
Is there a way to create a list that is a SQL view under Admin>Lists? What process do I need to fallow? I'm currently looking at ARAS SQL queries to see if this is already being done in the stock version of ARAS.
Thank you for your help its greatly appreciated.
Josh
aponceot - Tuesday, January 14, 2014 5:03 PM:
Hi Josh,
It is not possible to do that as designed in Aras. But as always, there's some ways to achieve it.
Without having tested it, I would try to implement it as an onAfterGet function on the Value ItemType.
when you query a specific list ID, you'll populate the list of value from the your database.
