Developer forum

Hi Nuno,

Same problem here. We have a custom product field "Diametro" defined as Integer, with a query parameter of type Int32[] and its facet as checkboxes (I attach screenshots with the configuraton)

The facet is not displayed, despite this product field has several values indexed.

Is it needed to extend the index with a custom field or is there any other solution? Can you provide more info?

Regards, and happy Xmas!
Tomas

Hi Both

This has to do with the way Lucene handles numeric fields. We did make some changes in how we handle integers in facets and searches in 9.7 - so take a look at the latest 9.7 build and see if that will work for you.

BR Nicolai

Hi Nicolai,

We upgraded to 9.7.2 a while back and the issue still remains. I know there's 9.7.5 now, but I haven't tried it yet.

Best Regards,

Nuno Aguiar

Hi,

Thanks for the fast response :-)

Same for us, we use 9.7.2 and cannot display the integer facets

BR, Tomas

Hi Nicolai and Nuno,

I installed a local 9.7.5 solution and set the above configuration.

There is an error, no products are shown when displaying the product page. I checked the product feed adding "?feed=true" to the URL and this error is shown:

An error occurred while attaching module (Dynamicweb.Frontend.Content)<br><br><pre>System.InvalidCastException: Specified cast is not valid.
   at Dynamicweb.Indexing.Lucene.LuceneIndexProvider.FillFacetResultUsingSpecializedQuery(Facet facet, FieldDefinitionBase field, IndexReader reader, Query searchQuery, QuerySettings settings, FacetGroupResult facetsResult, IList`1 exceptions)
   at Dynamicweb.Indexing.Lucene.LuceneIndexProvider.DoFacetSearch(IFacetGroup facets, FieldDefinitionBase[] fields, IndexReader reader, IQuery query, QuerySettings settings, Query originalQuery, IList`1 exceptions)
   at Dynamicweb.Indexing.Lucene.LuceneIndexProvider.SearchInternal(IQuery query, QuerySettings settings)
   at Dynamicweb.Indexing.Querying.QueryService.Query(IQuery query, QuerySettings settings)
   at Dynamicweb.Ecommerce.Frontend.Frontend.GetProductsFromIndexQuery(ProductCatalogShowType settingsType)
   at Dynamicweb.Ecommerce.Frontend.Frontend.EcomRender()
   at Dynamicweb.Ecommerce.Frontend.Frontend.GetContent()
   at Dynamicweb.Frontend.Content.GetModuleOutput(Paragraph paragraph, PageView pageview)</pre>

Is there any trick we could do to solve this error?  ...or how could we implement the integer facets?

Regards, Tomas

Hi Tomas,

In our case we created a new index field of type string (not analyzed). Since we don't need any sort of range or integer calculations like lower than, it was good enough.

Best Regards,

Nuno Aguiar

Thanks Nuno!

It works perfect for our needs as well :-)