Grouped filters with OR?

[skttl]

Will it be possible to do groups of filters with OR or maybe have multiple fields in a filter?

In my Full Text Search package, I search for the search terms in a list of fields (typically nodename, meta title, meta description and full text search). I only expect the terms to be present in some of the fields.

Heres an example of the Lucene query it generates:

(
  (nodeName:"my search"^2 OR nodeName_en:"my search"^2 OR __fullText:"my search"^2 OR __fullText_en:"my search"^2)
  OR
  ((nodeName:my^1 OR nodeName_en:my^1 OR __fullText:my^1 OR __fullText_en:my^1) OR (nodeName:search^1 OR nodeName_en:search^1 OR __fullText:search^1 OR __fullText_en:search^1))
)
AND ((__VariesByCulture:y AND __Published_en:y) OR (__VariesByCulture:n AND __Published:y))
AND __IndexType:content
AND -(templateID:0)

The first group has the search terms.
The second group checks if the page is published in the current culture, or is invariant.

[kjac]

Hi @skttl 👋

We're deliberately trying to keep the surface of the abstraction API as narrow as possible (and as close to the original RFC as possible). This is not to say that grouped filtering is not a relevant feature, but perhaps there's an alternative way to achieve the same goal.

I just published a blog post detailing some of the extension points in the indexing part of the search abstractions. The IContentIndexer might be the alternative. You could use it to calculate your grouped filters up-front in dedicated fields - in your example, joining name, meta title, meta description and other relevant fields into a new index field.

The upside would be a faster query execution time, because the query becomes less complex. The downside is a larger index, although not as bad as it sounds, given that these are all inverted indexes.

That being said - I think your specific case here is already covered by Search. All textual fields are automatically included when free text querying, and Search will also include invariant content alongside culture variant content in a culture bound search query.

[skttl]

Thanks @kjac

I might look into just indexing the full text content then :)