Developer forum

You cannot have comma in the value for facets - comma is handled as arrays in the implementation, so you need to use another value.

Hi Nicolai,

Thanks for your answer. We actually cannot simply change these values because this is a migration from an existing website and it integration with AX (with already data imported). 

Do you know any other possible workaround for this?

Thanks in advance.

Best regards,

António Ramos

Not currently. I have a backlog item that we should give an alternative for this scenario - there was another thread on this matter some weeks ago.

You can run a SQL during/after the import that will copy the data to another column and make a conversion when doing that.

Alternatively you can create an extender to the indexer that will manipulate the data when going into the index:

namespace Dynamicweb.Examples.CSharp
{
    class IndexBuilderExtenderExample : Indexing.IndexBuilderExtenderBase<Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder>
    {
        public override void ExtendDocument(IndexDocument document)
        {
            if (document.ContainsKey("ID"))
            {
                string productid = (string)document["ID"];
            }
            
            document.Add("CustomField", DateTime.Now);
        }
    }
}

For future reference we workaround the pre-selection problem in the front-end by verifying all the keywords from XX parameter (facet) in the facet options.

BR,

António Ramos

Hi Nicolai,

Have you been able to implement a solution for commas in the facet handling?

Best regards, Anders

Hi Nicolai,

Thank you so much!!! It works like a charm! :-)