dropdown values from database

seppo 31 Jul, 2017
I would need to populate dropdown values from list read from database.

At read data function, I have in fields to retrieve:
CategoryDd.aid
CategoryDd.category

and select type as key/value pairs. In the views-tab, at dropdown field in options I have
{var:read_categories_dropdown}

At first I didn't get anything. Then, after selecting "This is an extra field list" at the read data -function, I did get the keys correctly, but only 0 as value. What am I doing wrong here?

Thanks in advance!
seppo 01 Aug, 2017
Answer
1 Likes
Solved it.

I guess the initial problem was that I did not have the function call at the events-tab.
After I had it, I must have done something else to prevent it from working (likely that extra field list). No I took that tick back away and it started working.

Anyway I hope the above helps someone else with same problem.

I will mark this solved, however if possible someone could clarify what the "This is an extra field list" is used for?
This topic is locked and no more replies can be posted.