pre filter

[plykite]

Hello,

I would like to add this query as pre filter:
SELECT * FROM opendatamai2015.t_annuaire_site where acces='1' ORDER BY RAND() LIMIT 10

How can i do this? i try do add it in the pre filter field but it s not ok.

Thank you

Pascal

 

[troester]

I would create a MySQL view and link a Fabrik list to this view.

 

[plykite]

Thank you. Good idea. I m gonna try it.

Pascal