Hey there,

I would like to create a filter like this in SQL

select * from log where message not like '%test%'

In the documentation i found the FieldLikePredicate and the result is this.

                  filter.AddWithAnd(LogFields.Exception % string.Format("%{0}%", s))
                        .AddWithOr(LogFields.Message % string.Format("%{0}%", s));

But how do you create the Not Like with LLBL gen ?

Kris

myFilter.Negate = True

Yep. You need to use the FieldLikePredicate constructor. Or use a FieldLikePredicate varialbe and then set the _Negate _property to true.