Dynamic "OR" for a full-text search

[Martinelli_Davide]

Hello!

Say I have 3 string fields and I want to search for the same string inside those fields.
I need a way to make a dynamic OR because the fields may be more than 3, or less and the OR search must work consistently, thus I can't do the Where(Linq.Contains('Prop1',Value) or... or...) but it needs to be dynamic, so the ORs have to be appended one after another.
Any ideas?

Thanks!

[wlandgraf (Wagner Landgraf)]

Maybe this topic can help you:

Query data with "OR" condition in many code rows

You can use something like this: uses Aurelius.Criteria.Linq; var Expr: TLinqExpression; begin Expr := (Linq[‘A’] = 1) or (Linq[‘B’] = 2); if Condition then Expr := Expr or (Linq[‘C’] = 3); Criteria.Add(Expr); end;

[Martinelli_Davide]

Oh, that might work. I will give it a try.
Does this work with normal expressions as well?

Thanks!

[wlandgraf (Wagner Landgraf)]

What do you mean by normal expressions? You can set any Linq expression to a variable of type TLinqExpression.