Developer forum

Forum » CMS - Standard features » ItemTypes - Use value from feild in a SQL query for another field

ItemTypes - Use value from feild in a SQL query for another field

E-mail notifications
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply
Posted on 19/12/2016 15:26:33

Hi Guys,

I was wondering if it's possible to use the value from a Field in a Sql query to populate the values in another field.

For example, I can populate a dropdown list with a SQL query and store the PageID (for example) and based on the value selected in this field, I can use the PageID to populate a second SQL based dropdown list.
I know it's a long shot but I think I should ask first.

Thanks,

Adrian

 


Replies

 
Nicolai Pedersen
Posted on 19/12/2016 15:39:44
Reply

Hi Adrian.

No, that is not possible. You also have situations where the pageid would be the wrong value (i.e. when creating a new item, it would be null, or changing the first dropdown, it would be the old id).

So no simple fix for that. You can however code your own editor where something like this is supported.

BR Nicolai

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 19/12/2016 17:50:23
Reply

Hi Nicolai,

Thank you very much.

I knew it was a very long shot but it worth asking in case you have some hidden gem inside :)

Thank you. I will probably create some editor.

Adrian

 

You must be logged in to post in the forum