Problem with xml SavedQuery in WEM 8.1

Raju_Dachepally

Hi, 

We are using the following xml query for retrieving the content items using the SavedQuery class. This query need to give all the list of content items starting with particular letter(result should include content items starting with both capital letters and small letters). It is working in the VCM 7.3.1 but not working in WEM 8.1.

 <term type="constant">a%</term>

 But In WEM 8.1 it is giving content items starting with either small letters or capital letters. Any solution for this for getting all the results? We are building this query xml dynamically.

                 <?xml version="1.0" encoding="UTF-8"?>

               <query itemType="WF-CCG-DOCUMENT,WF-CCG-PROCEDURE" version="1.0">

                                <where>

                                                <and>

                                                                <eq><term type="field">System.Channel</term>

                                                                <term type="constant">ef88955bf7e27010VgnVCM10000090321b0a____</term>

                                                                </eq>

                                                                <like><term type="field">WF-title</term>

                                                                <term type="constant">a%</term>

                                                                </like>

                                                </and>

                                </where>

                                <order-by propName="WF-title"/>

                </query>

 

Following is the code which we are using for the query execution

public static List executeXMLQuery(String xmlstr, int maxSize, RequestContext requestContext) {

                                if (xmlstr == null || xmlstr.length() == 0) {

                                                return Collections.EMPTY_LIST;

                                }

                               

        StringReader reader = new StringReader(xmlstr);

        SavedQuery query = SavedQuery.createFromXML(reader);

       QueryRequestContext queryRequestContext = new QueryRequestContext(requestContext);

                                if(maxSize > 0)

                                                return query.runQuery(queryRequestContext, 0, maxSize);

                                else

                                                return query.runQuery(queryRequestContext);

                }

Thanks & Regards,

Raju Dachepally