Loading...
 
Skip to main content

Features / Usability


Tracker field - dropdown list from external database

I would like to create a Tracker with one of its dropdown fields populated from a external database table. I know how to link to another tracker, but I can find no way at all to link to an external database.

Is this a real constraint within Tiki, or am I completely missing something?

Thanks for any help.

Kevin

Just in case anyone else looks at this, I've managed to find a solution.

I've modified /lib/core/Tracker/Field/Dropdown.php ro raise an event when it sets up the options array. In my event handler I then look at the options (which I've used to identify the database query I need to execute), build the query, execute it, and extract the results to give the options I really want to display in the dropdown.

I had to extend the event handling to allow a result to be passed back from the user event.

But it's now working fine.

Kevin