How to Filter ContentItem by Field using Lucene.

[jaypeemayo]

Hi,

I have this code and my objective is just to get all of the content items (with type Episode) that have a o?.Content?.Episode?.Series?.ContentItemIds.First?.Value field that matches the seriesId value.

var allSeriesEpisodes = (await _orchard.QueryContentItemsAsync(query => query.Where(x => x.ContentType == "Episode")))
				.Where(o =>  o?.Content?.Episode?.Series?.ContentItemIds.First?.Value == seriesId);

I find the Where clause slow because it loops through all of the Episodes. I was thinking to do this in Lucene.

I tried to search for Ochard Core Lucene implementation but cannot find a good one. Can anyone help me with this?

[Skrypt]

Here is a small helper method that I use for Lucene in a Controller :

private async Task<OrchardCore.Lucene.LuceneQueryResults> LuceneQueryAsync(string queryName, Dictionary<string, object> parameters)
        {
            var contentItems = new List<ContentItem>();
            var query = await _queryManager.GetQueryAsync(queryName);
            var queryResult = new OrchardCore.Lucene.LuceneQueryResults();

            if (query != null)
            {
                queryResult = (OrchardCore.Lucene.LuceneQueryResults)await _queryManager.ExecuteQueryAsync(query, parameters);

                if (queryResult.Items != null)
                {
                    foreach (var item in (IEnumerable)queryResult.Items)
                    {
                        if (!(item is ContentItem contentItem))
                        {
                            contentItem = null;

                            if (item is JObject jObject)
                            {
                                contentItem = jObject.ToObject<ContentItem>();
                            }
                        }

                        // If input is a 'JObject' but which not represents a 'ContentItem',
                        // a 'ContentItem' is still created but with some null properties.
                        if (contentItem?.ContentItemId == null)
                        {
                            continue;
                        }

                        contentItems.Add(contentItem);
                    }
                }

                queryResult.Items = contentItems;
            }

            return queryResult;
        }

[jaypeemayo]

Thanks for this @Skrypt . I have one more request. Would you mind sending me a sample code on how to use this LuceneQueryAsync method? A sample of the query and parameter? Sorry because I'm not an expert on writing Lucene query

[Skrypt]

So here I assume "Series" is a Content Picker field. Then the Lucene Query should be quite simple.

{
  "from" : 0, "size" : 2000,
  "query": {
    "bool" : {
      "must" : [
        { "term" : { "Content.ContentItem.ContentType" : "Episode" } },
        { "term" : { "Content.ContentItem.Published" : "true" } },
        { "term" : { "Content.ContentItem.Latest" : "true" } },
        { "term" : { "Episode.Series" : "some-uid" } }
      ]
    }
  },
  "sort": { "Content.ContentItem.DisplayText.Normalized": { "order": "asc" } }
}

Just make sure you use "Store" for this "Episode.Series" Content Field in the Lucene Index settings of your "Episode" Content Type.

[jaypeemayo]

Awesome. thanks this works!