leftjoin inside select options (editor)

marat.s.11

Hello everyone!
Here is a code

Field::inst('library_4_topic.chapter_id', 'chapter_id')
->options( Options::inst()
->table( 'library_3_chapter' )
->value( 'id' )
->label( 'id' )
->order('id ASC')
),

the question is: is it possible to make a join list inside options? because this code shows dropdown list but only with number whereas the description for each option is in another table and depends on the translation. so the question how can do the leftjoin to grab text value for each label(id) because there is no text value inside library_3_chapter. Text values are inside another table.

Also how to use where clause at the same time.

Thank you in advance! Hope i didnt complicate the explanation.

marat.s.11

found an answer.

for those who has the same problem.
https://datatables.net/forums/discussion/44019/can-we-add-left-join-in-options

allan

Thanks for posting back - good to hear you found a solution.

Allan