list pre filter

[bobafet465]

Hi this is something probably easy to resolve but I can't get my head around the pre filter setup for lists.

I have two data fields one call stock_level and the other stock_min I want to list all items where stock_level <= stock_min

I have created a MySQL query that works fine when I run it in phpmyadmin but the settings for the pre filter don't make much sense to me.

I am on joomla 2.5.1 and Fabrik 3.0.5.2

Thanks for your time.

 

[troester]

You can do anything with "Type"=query: e.g.
Element:id
Condition: IN
Value: SELECT id from your-table WHERE stock_level <= stock_min
Type: query
Apply to: whatever

 

[bobafet465]

thanks for the very fast response, the list is working perfectly.