I thought I would build my in query separately and add to other expressions using WhereAny expression as below
string searchQuery = Camlex.Query().WhereAny(inQuery, searchExpressions).ToString();
When I do this, I get the below exception.
WHERE tag contain element which can't be translated:
<FieldRef Name="Location" />
at CamlexNET.Impl.ReverseEngeneering.Caml.Factories.ReAnalyzerFromCamlFactory.getAnalyzerForWhere(XElement el)
at CamlexNET.Impl.ReverseEngeneering.Caml.Factories.ReAnalyzerFromCamlFactory.Create(XElement el)
at CamlexNET.Impl.ReverseEngeneering.Caml.Factories.ReTranslatorFromCamlFactory.Create(String input)
at CamlexNET.Impl.Query.getWhereExpressionFromString(String existingWhere)
at CamlexNET.Impl.Query.WhereAny(String existingWhere, IEnumerable`1 expressions)
Looks like the WhereAny can't combine expressions with dynamically built In query. Am I doing anything wrong? Can't I build "In" query this way and combine with other expressions? If this doesn't work then I will have to go with Contains clause which is supported by Camlex. Please confirm.