Querybuilder casesensitive issue | Community
Skip to main content
R
rajat168
Level 4
August 26, 2024

Querybuilder casesensitive issue

  • August 26, 2024
  • 1 reply
  • 1382 views

Hi Team,

      i was trying to execute below query on my query builder, when i execute this query (search text: Smart Lock) im getting 12 result count which is expected result, same when i execute this query with (search text: smart lock) im getting 0 result. I also tried with the group.2.operation=equalsIgnoreCase by replacing group.2_operation=like but it's not working. Kindly please suggest. my intension was, the query should return 12 result even if i gave the search text upper case or lower case.  Kindly please suggest.

 

QUERY 1 Executed

 

 

 

 

path=/content/wknd/us/en/mypage/support type=nt:unstructured group.1_property=sling:resourceType group.1_property.value=wknd/components/text group.2_property=text group.2_operation=like group.2_property.value=%Smart Lock% group.p.and=true p.limit=-1

 

 

 

 

 

  QUERY 2 EXECUTED

 

 

 

path=/content/wknd/ae/en/c/support type=nt:unstructured group.1_property=sling:resourceType group.1_property.value=wknd/components/text group.2_property=text group.2_operation=equalsIgnoreCase group.2_property.value=%Smart Lock% group.p.and=true p.limit=-1

 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

h_kataria
Community Advisor
h_katariaCommunity Advisor
Community Advisor
August 26, 2024

Operation is a property predicate. Please try

group.2_property.operation=equalsIgnoreCase

 

    R
    rajat168Author
    Level 4
    August 26, 2024

    Hi @h_kataria , thanks for your response. please find updated query as you suggested but still the expected result 12 was not coming.

    QUERY -1 ========= path=/content/wkn/en/us/c/support type=nt:unstructured group.1_property=sling:resourceType group.1_property.value=wknd/components/text group.2_property=text group.2_property.operation=equalsIgnoreCase group.2_property.value=%smart lock% group.p.and=true p.limit=-1 QUERY -2 ========= path=/content/wkn/en/us/c/support type=nt:unstructured group.1_property=sling:resourceType group.1_property.value=wknd/components/text group.2_property=text group.2_property.operation=equalsIgnoreCase group.2_property.value=%Smart Lock% group.p.and=true p.limit=-1

     

      h_kataria
      Community Advisor
      h_katariaCommunity Advisor
      Community Advisor
      August 26, 2024

      As you can apply one operation at a time, lose the % as it is applicable only for LIKE operation.

      group.2_property.value=Smart Lock
        Terms & ConditionsAccessibility statement

        Loading footer...