Filtered list

[FilMar]

I have a list and I want to show by default only a part of the records but stil have them in the list.

How can I do this?

I know I can use a prefilter but then I don't have those records any more in my list.
Can I prefill a filterbox?

Otherwise told. I have a list where, when I view the list, I only want to see the records where one field is empty (NULL). But still have the possibility to cancel this filter so I see all the records.

Some advice please,

Greetings,
Filip

 

[troester]

You can add an "Extra Query String" in the list menu item settings (Fabrik options, at the bottom). This filter option will be removed by clicking "Reset filter".

 

[FilMar]

Great,

But how do I filter on NULL?

Many thanks in advance,

Filip

 

[troester]

You can do URL filtering with &table___element[condition]=IS%20NULL

But it seems this isn't accepted in the "Extra Query String". So you can do it the "old" way: Use an "System/URL" menu link calling your list with this filter URL (obviously you don't have the other "Fabrik List Options" in this case).

 

[FilMar]

Thanks,

Got it to work like that.