Filter options from foreignKey

[matthijsb]

Hey Guys,

I am getting options for a multiple checkbox field with a foreignKey. I just want to filter the results a bit more, like in this example:
foreignKey: 'table.name'
foreignFilter: 'published=1'

I know this is possible with options_callback, but this not an option right now for me, because that is not so flexible as I need it to be.

[Tru]

Why it's not flexible for you? :shock:
Check out these examples
[code=php:3228wpc5]<span class="syntaxdefault">
class*tl_some_dca*extends*Backend
</span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">****$arrNews*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*array</span><span class="syntaxkeyword">();
</span><span class="syntaxdefault">****$objNews*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$this</span><span class="syntaxkeyword">-></span><span class="syntaxdefault">Database</span><span class="syntaxkeyword">-></span><span class="syntaxdefault">execute</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT*id,*headline*FROMÂ  tl_news*WHERE*published=1"</span><span class="syntaxkeyword">);

</span><span class="syntaxdefault">****while*</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$objNews</span><span class="syntaxkeyword">-></span><span class="syntaxdefault">next</span><span class="syntaxkeyword">())
</span><span class="syntaxdefault">****</span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">********$arrNews</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">$objNews</span><span class="syntaxkeyword">-></span><span class="syntaxdefault">id</span><span class="syntaxkeyword">]</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$objNews</span><span class="syntaxkeyword">-></span><span class="syntaxdefault">headline</span><span class="syntaxkeyword">;
</span><span class="syntaxdefault">****</span><span class="syntaxkeyword">}

</span><span class="syntaxdefault">****return*$arrNews</span><span class="syntaxkeyword">;
}
</span><span class="syntaxdefault">*</span>[/code:3228wpc5]
options_callback are definitely less flexible...

[matthijsb]

I am busy with a module that can generate modules based on catalogs from the catalog module.
I tried a few ways with the options_callback. But that did not work properly.
If I can do it like my example in my last post, it can make filtering stuff much easier in the backend.