Options in list menu item type

[jacardiel]

HI,
I have a list menu item type. I want to use the option "prefilter" to do a filter of the list.
In a select query should be: SELECT xxx FROM table_name WHERE recomendacion='EL'

I use the next expresion in prefilter option (attach) but don't obtain any result.
What is the problem?
What is the diferrence between "prefilter" and "show in list"
Thanks in advance.

 

[troester]

Prefilters: http://fabrikar.com/forums/index.php?wiki/pre-filters/
are filtering data

Show in list: defines which elements (columns) to show in list view

The options in the menu item are overriding the prefilters in list settings and the elements' "show in list" settings.

 

[jacardiel]

Perfect troester, now work well.

Thank you