Gravatar for bberriz@lifeextension.com

Question by Ben, Jan 20, 2016 9:44 AM

Sitecore Multilist with Search - Issues with Spaces

Sitecore 7.2 CES 7.0.7711

When we are trying to filter a list field in Sitecore, a query which includes a space does not work. Both of these implementations worked pre-Coveo. We tried using single quotes, space, underscore, %20, but no luck. We aren't looking to start renaming our templates. Any thoughts?

Works:

StartSearchLocation={00000000-0000-0000-0000-000000000000}&Filter=_templatename:Product&PageSize=50&SortField=name

Doesn't Work:

StartSearchLocation={00000000-0000-0000-0000-000000000000}&Filter=_templatename:Product Number&PageSize=50&SortField=name
Gravatar for jflheureux@coveo.com

Comment by Jean-François L'Heureux, Jan 20, 2016 9:59 AM

Can you look in your CES query logs and find the respective queries received by CES for both of those Sitecore queries please? I would like to analyze them.

Gravatar for bberriz@lifeextension.com

Comment by Ben, Jan 21, 2016 10:59 AM

Query (@fz95xpath1099=="3a68318f3f644526befe45adf8fb1bbb") (@fz95xtemplatename1099=="Product") (@fz95xpath1099=="11111111111111111111111111111111") (@fz95xlatestversion1099=="1") (@fz95xdatasource1099=="sitecore") performed by performed by NAME [Sitecore Security Provider for PLACE]. 1458 results in 1.139 seconds.

Query (@fz95xpath1099=="3a68318f3f644526befe45adf8fb1bbb") (@fz95xtemplatename1099=="Product Number") (@fz95xpath1099=="11111111111111111111111111111111") (@fz95xlatestversion1099=="1") (@fz95xdatasource1099=="sitecore") performed by NAME [Sitecore Security Provider for PLACE]. 0 results in 0.125 seconds.

Gravatar for jflheureux@coveo.com

Comment by Jean-François L'Heureux, Jan 21, 2016 1:16 PM

Your queries are well formed but contains more than the filters you specified in your question.

Both queries contains (@fz95xpath1099=="3a68318f3f644526befe45adf8fb1bbb") (@fz95xpath1099=="11111111111111111111111111111111") (@fz95xlatestversion1099=="1") (@fz95xdatasource1099=="sitecore") in addition to the filter on the "_templatename" Sitecore field.

In plain text, this means:

  • Give me the search results that are the "3a68318f3f644526befe45adf8fb1bbb" Sitecore item or one of its child,
  • AND that are the "11111111111111111111111111111111" Sitecore item (/sitecore) or one of its child,
  • AND that are the latest version of their items,
  • AND that have a "_datasource" Sitecore field with an exact value of "sitecore".

Do you know where this filter could come from?

Gravatar for bberriz@lifeextension.com

Comment by Ben, Jan 22, 2016 8:00 AM

Any extraneous fields/filters outside the ones we set are possibly added by Sitecore (?). It's just strange that a space in a value causes no results to be returned.

Gravatar for jflheureux@coveo.com

Comment by Jean-François L'Heureux, Jan 22, 2016 9:31 AM

I think the problem is not the space as the resulting Coveo query is correctly formed.

It may just be that no Sitecore items of that particular template were indexed at all. Or that the items indexed from that template doesn't have the expected values in their fields. So the query filters are excluding them from the search results.

Gravatar for bberriz@lifeextension.com

Comment by Ben, Jan 22, 2016 3:28 PM

I'll go through an indexing process again, and see what the results are. I'll let you know what I can find.

1 Reply
Gravatar for bberriz@lifeextension.com

Answer by Ben, Mar 11, 2016 7:37 AM

As was stated, this was an issue of our indexing process unknowingly excluding items because of a random obscure rule.

Ask a question