list prefilter "NOT BEGINS WITH"

[linque]

In a list, I would like to pre-filter like "NOT BEGINS WITH".
how can I do it ?

 

[lousyfool]

You should be able to achieve it with a pre-filter set to something like

• Field: id
• Condition: IN
• Value: SELECT id FROM your_table_name WHERE field_in_question NOT LIKE 'foo%'
• Type: Query

with "foo" being the string you do not want the field_in_question to begin with.

 

[linque]

thank's a lot