Expand my Community achievements bar.

SOLVED

find and replace query on aemascs issue

Avatar

Level 5

Hi Team,

 we were trying to implement find and replace content on our project which is similar to classic UI search and replace functionality.  i have created a component find and replace. while executing the code on my localhost:4502, its working as expected, where when we deploy the code in AEMasCS environment we are getting error as below. Kindly help on this issue.

rajat168_0-1722928871356.png

 

pfb ajax call:

rajat168_1-1722928946169.png

 

 

my servlet:

rajat168_2-1722929033465.png

 

 

query executed via my code below

 

/jcr:root/content/mysample/ae/en/c/demo/components/_x0030_001findandreplacedemo//*[jcr:contains(., 'sampletext') and (jcr:like(fn:lower-case(@jcr:title),'%sampletext%') or jcr:like(fn:lower-case(@jcr:description),'%sampletext%') or jcr:like(fn:lower-case(@htmltext),'%sampletext%') or jcr:like(fn:lower-case(@accessoriescardpretitle),'%sampletext%') or jcr:like(fn:lower-case(@brandcategoryid),'%sampletext%') or jcr:like(fn:lower-case(@viewalltitle),'%sampletext%') or jcr:like(fn:lower-case(@alttext),'%sampletext%') or jcr:like(fn:lower-case(@maintitle),'%sampletext%') or jcr:like(fn:lower-case(@text),'%sampletext%') or jcr:like(fn:lower-case(@viewall),'%sampletext%') or jcr:like(fn:lower-case(@viewless),'%sampletext%') or jcr:like(fn:lower-case(@loadmore),'%sampletext%') or jcr:like(fn:lower-case(@title),'%sampletext%') or jcr:like(fn:lower-case(@label),'%sampletext%') or jcr:like(fn:lower-case(@name),'%sampletext%') or jcr:like(fn:lower-case(@value),'%sampletext%') or jcr:like(fn:lower-case(@categorylabel),'%sampletext%') or jcr:like(fn:lower-case(@categoryresults),'%sampletext%') or jcr:like(fn:lower-case(@learnmore),'%sampletext%') or jcr:like(fn:lower-case(@clearsearch),'%sampletext%') or jcr:like(fn:lower-case(@noresulttext),'%sampletext%') or jcr:like(fn:lower-case(@backtobusiness),'%sampletext%') or jcr:like(fn:lower-case(@aed),'%sampletext%') or jcr:like(fn:lower-case(@aednum),'%sampletext%') or jcr:like(fn:lower-case(@ctatext),'%sampletext%') or jcr:like(fn:lower-case(@offer),'%sampletext%') or jcr:like(fn:lower-case(@promo),'%sampletext%') or jcr:like(fn:lower-case(@vat),'%sampletext%') or jcr:like(fn:lower-case(@vataed),'%sampletext%') or jcr:like(fn:lower-case(@vatnum),'%sampletext%') or jcr:like(fn:lower-case(@iconalttext),'%sampletext%') or jcr:like(fn:lower-case(@featuresheading),'%sampletext%') or jcr:like(fn:lower-case(@field),'%sampletext%') or jcr:like(fn:lower-case(@iconheading),'%sampletext%') or jcr:like(fn:lower-case(@mainheading),'%sampletext%') or jcr:like(fn:lower-case(@mainheadingsubtext),'%sampletext%') or jcr:like(fn:lower-case(@subscriptionheading),'%sampletext%') or jcr:like(fn:lower-case(@icondesc),'%sampletext%') or jcr:like(fn:lower-case(@backbuttonlabel),'%sampletext%') or jcr:like(fn:lower-case(@getstartedbuttonlabel),'%sampletext%') or jcr:like(fn:lower-case(@nextbuttonlabel),'%sampletext%') or jcr:like(fn:lower-case(@popupid),'%sampletext%') or jcr:like(fn:lower-case(@secondarytitle),'%sampletext%') or jcr:like(fn:lower-case(@secondaryheading),'%sampletext%') or jcr:like(fn:lower-case(@badgelabel),'%sampletext%') or jcr:like(fn:lower-case(@imagealttext),'%sampletext%') or jcr:like(fn:lower-case(@labelvalue),'%sampletext%') or jcr:like(fn:lower-case(@benefitname),'%sampletext%') or jcr:like(fn:lower-case(@subtitle),'%sampletext%') or jcr:like(fn:lower-case(@featuressubtext),'%sampletext%') or jcr:like(fn:lower-case(@featurestext),'%sampletext%') or jcr:like(fn:lower-case(@newplantext),'%sampletext%') or jcr:like(fn:lower-case(@planprice),'%sampletext%') or jcr:like(fn:lower-case(@planpricesubtext),'%sampletext%') or jcr:like(fn:lower-case(@planpricecurrency),'%sampletext%') or jcr:like(fn:lower-case(@recommendedplantext),'%sampletext%') or jcr:like(fn:lower-case(@bundleheading),'%sampletext%') or jcr:like(fn:lower-case(@benefitsubtext),'%sampletext%') or jcr:like(fn:lower-case(@benefittext),'%sampletext%') or jcr:like(fn:lower-case(@tooltiptitle),'%sampletext%') or jcr:like(fn:lower-case(@companysectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@bundlebandwidthspeed),'%sampletext%') or jcr:like(fn:lower-case(@bundlebandwidthunit),'%sampletext%') or jcr:like(fn:lower-case(@bundleOldPrice),'%sampletext%') or jcr:like(fn:lower-case(@bundleOldPriceMonth),'%sampletext%') or jcr:like(fn:lower-case(@bundlecurrency),'%sampletext%') or jcr:like(fn:lower-case(@bundleprice),'%sampletext%') or jcr:like(fn:lower-case(@bundletimeperiod),'%sampletext%') or jcr:like(fn:lower-case(@bundlevattext),'%sampletext%') or jcr:like(fn:lower-case(@pricesectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@recommendedbundletext),'%sampletext%') or jcr:like(fn:lower-case(@slidernumber),'%sampletext%') or jcr:like(fn:lower-case(@usersectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@slidertitle),'%sampletext%') or jcr:like(fn:lower-case(@bwswitchviewtext),'%sampletext%') or jcr:like(fn:lower-case(@discountText),'%sampletext%') or jcr:like(fn:lower-case(@tableswitchviewtext),'%sampletext%') or jcr:like(fn:lower-case(@benefitssectionheading),'%sampletext%') or jcr:like(fn:lower-case(@applyPromocodeText),'%sampletext%') or jcr:like(fn:lower-case(@wasPriceFormat),'%sampletext%') or jcr:like(fn:lower-case(@wasPriceTitle),'%sampletext%') or jcr:like(fn:lower-case(@benefitstext),'%sampletext%') or jcr:like(fn:lower-case(@image1alttext),'%sampletext%') or jcr:like(fn:lower-case(@image2alttext),'%sampletext%') or jcr:like(fn:lower-case(@iframe-src),'%sampletext%') or jcr:like(fn:lower-case(@panellabel),'%sampletext%') or jcr:like(fn:lower-case(@inputvalue),'%sampletext%') or jcr:like(fn:lower-case(@ctaLabel),'%sampletext%') or jcr:like(fn:lower-case(@miniheading),'%sampletext%') or jcr:like(fn:lower-case(@billingctatext),'%sampletext%') or jcr:like(fn:lower-case(@sectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@content),'%sampletext%') or jcr:like(fn:lower-case(@tiletitle),'%sampletext%') or jcr:like(fn:lower-case(@icon),'%sampletext%') or jcr:like(fn:lower-case(@accessibilityLabel),'%sampletext%') or jcr:like(fn:lower-case(@storedesc),'%sampletext%') or jcr:like(fn:lower-case(@storetitle),'%sampletext%') or jcr:like(fn:lower-case(@pretitle),'%sampletext%') or jcr:like(fn:lower-case(@promobannerctatitle),'%sampletext%') or jcr:like(fn:lower-case(@placeHolderText),'%sampletext%') or jcr:like(fn:lower-case(@linkText),'%sampletext%') or jcr:like(fn:lower-case(@tilelinklabel),'%sampletext%') or jcr:like(fn:lower-case(@crosspromoctatitle),'%sampletext%') or jcr:like(fn:lower-case(@crosspromoplansPretitle),'%sampletext%') or jcr:like(fn:lower-case(@gacategorylistvalue),'%sampletext%') or jcr:like(fn:lower-case(@gacategoryname),'%sampletext%') or jcr:like(fn:lower-case(@badgeText),'%sampletext%') or jcr:like(fn:lower-case(@cardTitle),'%sampletext%') or jcr:like(fn:lower-case(@buynow),'%sampletext%') or jcr:like(fn:lower-case(@buynowalttext),'%sampletext%') or jcr:like(fn:lower-case(@categorysubtitle),'%sampletext%') or jcr:like(fn:lower-case(@categorytext),'%sampletext%') or jcr:like(fn:lower-case(@offertext),'%sampletext%') or jcr:like(fn:lower-case(@fromtext),'%sampletext%') or jcr:like(fn:lower-case(@oldproductprice),'%sampletext%') or jcr:like(fn:lower-case(@oldproductpricetext),'%sampletext%') or jcr:like(fn:lower-case(@productcurrency),'%sampletext%') or jcr:like(fn:lower-case(@productprice),'%sampletext%') or jcr:like(fn:lower-case(@vatinclude),'%sampletext%') or jcr:like(fn:lower-case(@smilepoints),'%sampletext%') or jcr:like(fn:lower-case(@viewmore),'%sampletext%') or jcr:like(fn:lower-case(@titlewithlinktext),'%sampletext%') or jcr:like(fn:lower-case(@heading),'%sampletext%') or jcr:like(fn:lower-case(@subheading),'%sampletext%') or jcr:like(fn:lower-case(@collapseall),'%sampletext%') or jcr:like(fn:lower-case(@expandall),'%sampletext%') or jcr:like(fn:lower-case(@designation),'%sampletext%') or jcr:like(fn:lower-case(@contactmail),'%sampletext%') or jcr:like(fn:lower-case(@contactnumber),'%sampletext%') or jcr:like(fn:lower-case(@contactperson),'%sampletext%') or jcr:like(fn:lower-case(@tileheading),'%sampletext%') or jcr:like(fn:lower-case(@ctalinktext),'%sampletext%') or jcr:like(fn:lower-case(@copyrighttext),'%sampletext%') or jcr:like(fn:lower-case(@featureslinklabel),'%sampletext%') or jcr:like(fn:lower-case(@featurestitle),'%sampletext%') or jcr:like(fn:lower-case(@titlename),'%sampletext%') or jcr:like(fn:lower-case(@brand),'%sampletext%') or jcr:like(fn:lower-case(@country),'%sampletext%') or jcr:like(fn:lower-case(@population),'%sampletext%') or jcr:like(fn:lower-case(@since),'%sampletext%') or jcr:like(fn:lower-case(@videoiconlabel),'%sampletext%') or jcr:like(fn:lower-case(@bottomtext),'%sampletext%') or jcr:like(fn:lower-case(@toptext),'%sampletext%') or jcr:like(fn:lower-case(@languageText),'%sampletext%') or jcr:like(fn:lower-case(@menutitle),'%sampletext%') or jcr:like(fn:lower-case(@promotitle),'%sampletext%') or jcr:like(fn:lower-case(@subnavigationtitle),'%sampletext%') or jcr:like(fn:lower-case(@catTitle),'%sampletext%') or jcr:like(fn:lower-case(@boarddesignation),'%sampletext%') or jcr:like(fn:lower-case(@boarddirector),'%sampletext%') or jcr:like(fn:lower-case(@promotiontitle),'%sampletext%') or jcr:like(fn:lower-case(@alt),'%sampletext%') or jcr:like(fn:lower-case(@tabmobiletitle),'%sampletext%') or jcr:like(fn:lower-case(@herobannerctatitle),'%sampletext%') or jcr:like(fn:lower-case(@captchakey),'%sampletext%') or jcr:like(fn:lower-case(@badge1),'%sampletext%') or jcr:like(fn:lower-case(@badge2),'%sampletext%') or jcr:like(fn:lower-case(@factdescription),'%sampletext%') or jcr:like(fn:lower-case(@facticonalt),'%sampletext%') or jcr:like(fn:lower-case(@factnumber),'%sampletext%') or jcr:like(fn:lower-case(@featureTitle),'%sampletext%') or jcr:like(fn:lower-case(@navigationlabel),'%sampletext%') or jcr:like(fn:lower-case(@navigationtitle),'%sampletext%') or jcr:like(fn:lower-case(@menualttext),'%sampletext%') or jcr:like(fn:lower-case(@followussectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@submenulabel),'%sampletext%') or jcr:like(fn:lower-case(@backlabel),'%sampletext%') or jcr:like(fn:lower-case(@mainintrolabel),'%sampletext%') or jcr:like(fn:lower-case(@opacity),'%sampletext%') or jcr:like(fn:lower-case(@number),'%sampletext%') or jcr:like(fn:lower-case(@monthlabel),'%sampletext%') or jcr:like(fn:lower-case(@loadmoretext),'%sampletext%') or jcr:like(fn:lower-case(@position),'%sampletext%') or jcr:like(fn:lower-case(@signatureIconAltText),'%sampletext%') or jcr:like(fn:lower-case(@socialIconAltText),'%sampletext%') or jcr:like(fn:lower-case(@benefitnumber),'%sampletext%') or jcr:like(fn:lower-case(@unit),'%sampletext%') or jcr:like(fn:lower-case(@businessverticaltitle),'%sampletext%') or jcr:like(fn:lower-case(@copyLinkLabel),'%sampletext%') or jcr:like(fn:lower-case(@otherArticlesLabel),'%sampletext%') or jcr:like(fn:lower-case(@readTime),'%sampletext%') or jcr:like(fn:lower-case(@tagsLabel),'%sampletext%') or jcr:like(fn:lower-case(@writtenByLabel),'%sampletext%') or jcr:like(fn:lower-case(@designationWrittenBy),'%sampletext%') or jcr:like(fn:lower-case(@nameWrittenBy),'%sampletext%') or jcr:like(fn:lower-case(@shareLabel),'%sampletext%') or jcr:like(fn:lower-case(@youtube),'%sampletext%') or jcr:like(fn:lower-case(@elife),'%sampletext%') or jcr:like(fn:lower-case(@producttitle),'%sampletext%') or jcr:like(fn:lower-case(@channeltitle),'%sampletext%') or jcr:like(fn:lower-case(@channelLabel),'%sampletext%') or jcr:like(fn:lower-case(@packagetitle),'%sampletext%') or jcr:like(fn:lower-case(@elite),'%sampletext%') or jcr:like(fn:lower-case(@packagesubtitle),'%sampletext%') or jcr:like(fn:lower-case(@packagetext),'%sampletext%') or jcr:like(fn:lower-case(@packageunits),'%sampletext%') or jcr:like(fn:lower-case(@breadcrumbtitle),'%sampletext%') or jcr:like(fn:lower-case(@backtolabel),'%sampletext%') or jcr:like(fn:lower-case(@heroimagectatitle),'%sampletext%') or jcr:like(fn:lower-case(@heroimagetitle),'%sampletext%') or jcr:like(fn:lower-case(@docModallabel),'%sampletext%') or jcr:like(fn:lower-case(@doclabel),'%sampletext%') or jcr:like(fn:lower-case(@vatText),'%sampletext%') or jcr:like(fn:lower-case(@tagtitle),'%sampletext%') or jcr:like(fn:lower-case(@bannerPreTitle),'%sampletext%') or jcr:like(fn:lower-case(@imageopacity),'%sampletext%') or jcr:like(fn:lower-case(@thumbnailtext),'%sampletext%') or jcr:like(fn:lower-case(@offerlinklabel),'%sampletext%') or jcr:like(fn:lower-case(@validdatetext),'%sampletext%') or jcr:like(fn:lower-case(@linklabel),'%sampletext%') or jcr:like(fn:lower-case(@productpricelabel),'%sampletext%') or jcr:like(fn:lower-case(@featuresimageopacity),'%sampletext%') or jcr:like(fn:lower-case(@featurespretitle),'%sampletext%') or jcr:like(fn:lower-case(@qrtext),'%sampletext%') or jcr:like(fn:lower-case(@customErrorMessage),'%sampletext%') or jcr:like(fn:lower-case(@customFormId),'%sampletext%') or jcr:like(fn:lower-case(@customSuccessMessage),'%sampletext%') or jcr:like(fn:lower-case(@workflowTitle),'%sampletext%') or jcr:like(fn:lower-case(@filterText),'%sampletext%') or jcr:like(fn:lower-case(@loadMoreLabel),'%sampletext%') or jcr:like(fn:lower-case(@yearLabel),'%sampletext%') or jcr:like(fn:lower-case(@footerctatext),'%sampletext%') or jcr:like(fn:lower-case(@qlctatext),'%sampletext%') or jcr:like(fn:lower-case(@quicklinkstitle),'%sampletext%') or jcr:like(fn:lower-case(@socialapptitle),'%sampletext%') or jcr:like(fn:lower-case(@ddownctatext),'%sampletext%') or jcr:like(fn:lower-case(@lastdatetext),'%sampletext%') or jcr:like(fn:lower-case(@stepmaintext),'%sampletext%') or jcr:like(fn:lower-case(@stepsubtext),'%sampletext%') or jcr:like(fn:lower-case(@fromDate),'%sampletext%') or jcr:like(fn:lower-case(@timing),'%sampletext%') or jcr:like(fn:lower-case(@toDate),'%sampletext%') or jcr:like(fn:lower-case(@stepnumber),'%sampletext%') or jcr:like(fn:lower-case(@daysRemainingText),'%sampletext%') or jcr:like(fn:lower-case(@lastDateTitle),'%sampletext%') or jcr:like(fn:lower-case(@submissionText),'%sampletext%') or jcr:like(fn:lower-case(@playvideotext),'%sampletext%') or jcr:like(fn:lower-case(@readingtime),'%sampletext%') or jcr:like(fn:lower-case(@remainingdaystext),'%sampletext%') or jcr:like(fn:lower-case(@shorttext),'%sampletext%') or jcr:like(fn:lower-case(@submissionclosedtext),'%sampletext%') or jcr:like(fn:lower-case(@colourBlindLabel),'%sampletext%') or jcr:like(fn:lower-case(@greenWeaknessLabel),'%sampletext%') or jcr:like(fn:lower-case(@redWeaknessLabel),'%sampletext%') or jcr:like(fn:lower-case(@fontDefaultTextType),'%sampletext%') or jcr:like(fn:lower-case(@fontDefaultTextValue),'%sampletext%') or jcr:like(fn:lower-case(@fontLabel),'%sampletext%') or jcr:like(fn:lower-case(@modalHeaderTitle),'%sampletext%') or jcr:like(fn:lower-case(@downloadsectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@quickaccesssectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@needHelpTitle),'%sampletext%') or jcr:like(fn:lower-case(@paymentsectiontitle),'%sampletext%') or jcr:like(fn:lower-case(@subnavigationlabel),'%sampletext%') or jcr:like(fn:lower-case(@languagelabel),'%sampletext%') or jcr:like(fn:lower-case(@menuback),'%sampletext%') or jcr:like(fn:lower-case(@searchlabel),'%sampletext%') or jcr:like(fn:lower-case(@searchmodallabel),'%sampletext%') or jcr:like(fn:lower-case(@globalfootprintpretitle),'%sampletext%') or jcr:like(fn:lower-case(@globalfootprinttitle),'%sampletext%') or jcr:like(fn:lower-case(@brandtitle),'%sampletext%') or jcr:like(fn:lower-case(@moreinfotitle),'%sampletext%') or jcr:like(fn:lower-case(@populationtitle),'%sampletext%') or jcr:like(fn:lower-case(@sincetitle),'%sampletext%') or jcr:like(fn:lower-case(@offertitle),'%sampletext%') or jcr:like(fn:lower-case(@offerpretitle),'%sampletext%') or jcr:like(fn:lower-case(@sectionId),'%sampletext%') or jcr:like(fn:lower-case(@footerTitle),'%sampletext%') or jcr:like(fn:lower-case(@alt-text),'%sampletext%') or jcr:like(fn:lower-case(@howtodesc),'%sampletext%') or jcr:like(fn:lower-case(@howtotitle),'%sampletext%') or jcr:like(fn:lower-case(@caption),'%sampletext%') or jcr:like(fn:lower-case(@imageModifiers),'%sampletext%') or jcr:like(fn:lower-case(@backgroundImagetitle),'%sampletext%') or jcr:like(fn:lower-case(@query),'%sampletext%') or jcr:like(fn:lower-case(@addresslabel),'%sampletext%') or jcr:like(fn:lower-case(@customercarelabel),'%sampletext%') or jcr:like(fn:lower-case(@customercaretext),'%sampletext%') or jcr:like(fn:lower-case(@email),'%sampletext%') or jcr:like(fn:lower-case(@emaillabel),'%sampletext%') or jcr:like(fn:lower-case(@listviewtitle),'%sampletext%') or jcr:like(fn:lower-case(@filterLabel),'%sampletext%') or jcr:like(fn:lower-case(@mapviewtitle),'%sampletext%') or jcr:like(fn:lower-case(@searchtext),'%sampletext%') or jcr:like(fn:lower-case(@showresulttext),'%sampletext%') or jcr:like(fn:lower-case(@uselocationtext),'%sampletext%') or jcr:like(fn:lower-case(@autorenewaltext),'%sampletext%') or jcr:like(fn:lower-case(@exclusivelytext),'%sampletext%') or jcr:like(fn:lower-case(@mediactatitle),'%sampletext%') or jcr:like(fn:lower-case(@mediasmalltitle),'%sampletext%') or jcr:like(fn:lower-case(@smiletext),'%sampletext%') or jcr:like(fn:lower-case(@viewplan),'%sampletext%') or jcr:like(fn:lower-case(@viewallbenefitslabel),'%sampletext%') or jcr:like(fn:lower-case(@nextdrawtitle),'%sampletext%') or jcr:like(fn:lower-case(@mediaCtaHeading),'%sampletext%') or jcr:like(fn:lower-case(@pricecurrency),'%sampletext%') or jcr:like(fn:lower-case(@pricevalue),'%sampletext%') or jcr:like(fn:lower-case(@iconsheading),'%sampletext%') or jcr:like(fn:lower-case(@notificationctatitle),'%sampletext%') or jcr:like(fn:lower-case(@imagepretitle),'%sampletext%') or jcr:like(fn:lower-case(@popuptitle),'%sampletext%') or jcr:like(fn:lower-case(@loadmorebutton),'%sampletext%') or jcr:like(fn:lower-case(@sectionlabel),'%sampletext%') or jcr:like(fn:lower-case(@tabname),'%sampletext%') or jcr:like(fn:lower-case(@billingperiod),'%sampletext%') or jcr:like(fn:lower-case(@oldpriceprefix),'%sampletext%') or jcr:like(fn:lower-case(@oldpricevalue),'%sampletext%') or jcr:like(fn:lower-case(@offertagtext),'%sampletext%') or jcr:like(fn:lower-case(@languageswitchtext),'%sampletext%') or jcr:like(fn:lower-case(@previouspage),'%sampletext%') or jcr:like(fn:lower-case(@sharebutton),'%sampletext%') or jcr:like(fn:lower-case(@sharethisdesign),'%sampletext%') or jcr:like(fn:lower-case(@buttonLabel),'%sampletext%') or jcr:like(fn:lower-case(@formInputLabel),'%sampletext%') or jcr:like(fn:lower-case(@nbactatitle),'%sampletext%') or jcr:like(fn:lower-case(@nbasmalltitle),'%sampletext%') or jcr:like(fn:lower-case(@oldprice),'%sampletext%') or jcr:like(fn:lower-case(@newFeatures),'%sampletext%') or jcr:like(fn:lower-case(@userdesignation),'%sampletext%') or jcr:like(fn:lower-case(@username),'%sampletext%') or jcr:like(fn:lower-case(@errortext),'%sampletext%') or jcr:like(fn:lower-case(@tryagaintext),'%sampletext%') or jcr:like(fn:lower-case(@tryagainextratext),'%sampletext%') or jcr:like(fn:lower-case(@categoryTag),'%sampletext%') or jcr:like(fn:lower-case(@noResultsHeading),'%sampletext%') or jcr:like(fn:lower-case(@cardCategory),'%sampletext%') or jcr:like(fn:lower-case(@iconText),'%sampletext%') or jcr:like(fn:lower-case(@plusText),'%sampletext%') or jcr:like(fn:lower-case(@promoText),'%sampletext%') or jcr:like(fn:lower-case(@shownocontract),'%sampletext%') or jcr:like(fn:lower-case(@offerBadge),'%sampletext%') or jcr:like(fn:lower-case(@planName),'%sampletext%') or jcr:like(fn:lower-case(@planDetail),'%sampletext%') or jcr:like(fn:lower-case(@wastext),'%sampletext%') or jcr:like(fn:lower-case(@contract),'%sampletext%') or jcr:like(fn:lower-case(@planType),'%sampletext%') or jcr:like(fn:lower-case(@usp),'%sampletext%') or jcr:like(fn:lower-case(@offer-text),'%sampletext%') or jcr:like(fn:lower-case(@modalId),'%sampletext%') or jcr:like(fn:lower-case(@seedetailstext),'%sampletext%') or jcr:like(fn:lower-case(@bandwidthlabel),'%sampletext%') or jcr:like(fn:lower-case(@bandwidthtype),'%sampletext%') or jcr:like(fn:lower-case(@_x0032_gfilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0032_gfiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0033_gfilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0033_gfiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0034_gfilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0034_gfiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0035_gfilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@_x0035_gfiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@filterapplytext),'%sampletext%') or jcr:like(fn:lower-case(@filterheading),'%sampletext%') or jcr:like(fn:lower-case(@filterresettext),'%sampletext%') or jcr:like(fn:lower-case(@filterstext),'%sampletext%') or jcr:like(fn:lower-case(@iotfilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@iotfiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@futureplantext),'%sampletext%') or jcr:like(fn:lower-case(@highstrength),'%sampletext%') or jcr:like(fn:lower-case(@legendtitle),'%sampletext%') or jcr:like(fn:lower-case(@lowstrength),'%sampletext%') or jcr:like(fn:lower-case(@ltefilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@ltefiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@googleMapKey),'%sampletext%') or jcr:like(fn:lower-case(@noServiceText),'%sampletext%') or jcr:like(fn:lower-case(@notAvailableText5G),'%sampletext%') or jcr:like(fn:lower-case(@coveragetablabel),'%sampletext%') or jcr:like(fn:lower-case(@internettablabel),'%sampletext%') or jcr:like(fn:lower-case(@currentprice),'%sampletext%') or jcr:like(fn:lower-case(@pricemaintext),'%sampletext%') or jcr:like(fn:lower-case(@pricesubtext),'%sampletext%') or jcr:like(fn:lower-case(@maintext),'%sampletext%') or jcr:like(fn:lower-case(@subtext),'%sampletext%') or jcr:like(fn:lower-case(@mainimagealttext),'%sampletext%') or jcr:like(fn:lower-case(@qrcodeimagealttext),'%sampletext%') or jcr:like(fn:lower-case(@catId),'%sampletext%') or jcr:like(fn:lower-case(@gaEventCategory),'%sampletext%') or jcr:like(fn:lower-case(@gaEventName),'%sampletext%') or jcr:like(fn:lower-case(@viewAllText),'%sampletext%') or jcr:like(fn:lower-case(@storage),'%sampletext%') or jcr:like(fn:lower-case(@cardLinkText),'%sampletext%') or jcr:like(fn:lower-case(@price),'%sampletext%') or jcr:like(fn:lower-case(@upgradeLinkText),'%sampletext%') or jcr:like(fn:lower-case(@packTitle),'%sampletext%') or jcr:like(fn:lower-case(@thirdActionText),'%sampletext%') or jcr:like(fn:lower-case(@thirdActionctaText),'%sampletext%') or jcr:like(fn:lower-case(@downloadapptitle),'%sampletext%') or jcr:like(fn:lower-case(@paymentapptitle),'%sampletext%') or jcr:like(fn:lower-case(@timeDelay),'%sampletext%') or jcr:like(fn:lower-case(@carticonaltText),'%sampletext%') or jcr:like(fn:lower-case(@backtomainmenutext),'%sampletext%') or jcr:like(fn:lower-case(@quicklinkscolumnheading),'%sampletext%') or jcr:like(fn:lower-case(@recentsearchtext),'%sampletext%') or jcr:like(fn:lower-case(@trendtitle),'%sampletext%') or jcr:like(fn:lower-case(@trendingsearchheading),'%sampletext%') or jcr:like(fn:lower-case(@voicesearchrecommendedtext),'%sampletext%') or jcr:like(fn:lower-case(@submenutitle),'%sampletext%') or jcr:like(fn:lower-case(@logoalttext),'%sampletext%') or jcr:like(fn:lower-case(@submenuimagetitle),'%sampletext%') or jcr:like(fn:lower-case(@contactDetailsForContact),'%sampletext%') or jcr:like(fn:lower-case(@contactDetailsHeading),'%sampletext%') or jcr:like(fn:lower-case(@continue),'%sampletext%') or jcr:like(fn:lower-case(@continuing),'%sampletext%') or jcr:like(fn:lower-case(@emailAddress),'%sampletext%') or jcr:like(fn:lower-case(@phonenumber),'%sampletext%') or jcr:like(fn:lower-case(@exitChat),'%sampletext%') or jcr:like(fn:lower-case(@exitChatConfirmation),'%sampletext%') or jcr:like(fn:lower-case(@notSameAgent),'%sampletext%') or jcr:like(fn:lower-case(@buyText),'%sampletext%') or jcr:like(fn:lower-case(@chatAgent),'%sampletext%') or jcr:like(fn:lower-case(@chatHelp),'%sampletext%') or jcr:like(fn:lower-case(@chatIntro),'%sampletext%') or jcr:like(fn:lower-case(@chatReplies),'%sampletext%') or jcr:like(fn:lower-case(@contactCustomerCareText),'%sampletext%') or jcr:like(fn:lower-case(@contactYouShortlyText),'%sampletext%') or jcr:like(fn:lower-case(@needhelpbutton),'%sampletext%') or jcr:like(fn:lower-case(@successFullyVerified),'%sampletext%') or jcr:like(fn:lower-case(@addAnotherNumber),'%sampletext%') or jcr:like(fn:lower-case(@didNotReceiveCode),'%sampletext%') or jcr:like(fn:lower-case(@invalidNumberMsg),'%sampletext%') or jcr:like(fn:lower-case(@resendCode),'%sampletext%') or jcr:like(fn:lower-case(@verificationCode),'%sampletext%') or jcr:like(fn:lower-case(@verificationCodeSentMsg),'%sampletext%') or jcr:like(fn:lower-case(@verifing),'%sampletext%') or jcr:like(fn:lower-case(@verify),'%sampletext%') or jcr:like(fn:lower-case(@priceFrom),'%sampletext%') or jcr:like(fn:lower-case(@priceLabel),'%sampletext%') or jcr:like(fn:lower-case(@priceTo),'%sampletext%') or jcr:like(fn:lower-case(@backtext),'%sampletext%') or jcr:like(fn:lower-case(@categoriestext),'%sampletext%') or jcr:like(fn:lower-case(@emiratestext),'%sampletext%') or jcr:like(fn:lower-case(@openstorestext),'%sampletext%') or jcr:like(fn:lower-case(@searchradiustext),'%sampletext%') or jcr:like(fn:lower-case(@emptyresulttext),'%sampletext%') or jcr:like(fn:lower-case(@storeaddresstext),'%sampletext%') or jcr:like(fn:lower-case(@visitstorestext),'%sampletext%') or jcr:like(fn:lower-case(@fcfilterlabel),'%sampletext%') or jcr:like(fn:lower-case(@fcfiltersublabel),'%sampletext%') or jcr:like(fn:lower-case(@excellentstrength),'%sampletext%') or jcr:like(fn:lower-case(@poorstrength),'%sampletext%') or jcr:like(fn:lower-case(@machinestablabel),'%sampletext%') or jcr:like(fn:lower-case(@resellerstablabel),'%sampletext%') or jcr:like(fn:lower-case(@storestablabel),'%sampletext%') or jcr:like(fn:lower-case(@wifitablabel),'%sampletext%') or jcr:like(fn:lower-case(@dropdownLabel),'%sampletext%') or jcr:like(fn:lower-case(@moreText),'%sampletext%') or jcr:like(fn:lower-case(@moredetailstext),'%sampletext%') or jcr:like(fn:lower-case(@promotionalTitle),'%sampletext%') or jcr:like(fn:lower-case(@benefitsTitle),'%sampletext%') or jcr:like(fn:lower-case(@benefitAddnDetais),'%sampletext%') or jcr:like(fn:lower-case(@benefitValue),'%sampletext%') or jcr:like(fn:lower-case(@commitmenttext),'%sampletext%') or jcr:like(fn:lower-case(@templateHost),'%sampletext%') or jcr:like(fn:lower-case(@maintittle),'%sampletext%') or jcr:like(fn:lower-case(@subsectionid),'%sampletext%') or jcr:like(fn:lower-case(@mainLabel),'%sampletext%') or jcr:like(fn:lower-case(@subLabel),'%sampletext%') or jcr:like(fn:lower-case(@sectitle),'%sampletext%') or jcr:like(fn:lower-case(@belowCtaText),'%sampletext%') or jcr:like(fn:lower-case(@viewSummaryBtn),'%sampletext%') or jcr:like(fn:lower-case(@priceFormat),'%sampletext%') or jcr:like(fn:lower-case(@priceTagTitle),'%sampletext%') or jcr:like(fn:lower-case(@vatDetails),'%sampletext%') or jcr:like(fn:lower-case(@whatsNextTitle),'%sampletext%') or jcr:like(fn:lower-case(@featurename),'%sampletext%') or jcr:like(fn:lower-case(@featureprice),'%sampletext%') or jcr:like(fn:lower-case(@totaltext),'%sampletext%') or jcr:like(fn:lower-case(@countertext),'%sampletext%') or jcr:like(fn:lower-case(@countervalue),'%sampletext%') or jcr:like(fn:lower-case(@description),'%sampletext%') or jcr:like(fn:lower-case(@bottomTitle),'%sampletext%') or jcr:like(fn:lower-case(@applybuttonlabel),'%sampletext%') or jcr:like(fn:lower-case(@resetbuttonlabel),'%sampletext%') or jcr:like(fn:lower-case(@viewlesslabel),'%sampletext%') or jcr:like(fn:lower-case(@viewmorelabel),'%sampletext%') or jcr:like(fn:lower-case(@allChannelsLabel),'%sampletext%') or jcr:like(fn:lower-case(@channelsLabel),'%sampletext%') or jcr:like(fn:lower-case(@categoryName),'%sampletext%') or jcr:like(fn:lower-case(@actual-price),'%sampletext%') or jcr:like(fn:lower-case(@actual-price-currency-type),'%sampletext%') or jcr:like(fn:lower-case(@selling-price),'%sampletext%') or jcr:like(fn:lower-case(@selling-price-currency-type),'%sampletext%') or jcr:like(fn:lower-case(@vat-percentage),'%sampletext%') or jcr:like(fn:lower-case(@accordionTitle),'%sampletext%') or jcr:like(fn:lower-case(@nestedTitle),'%sampletext%') or jcr:like(fn:lower-case(@referenceText),'%sampletext%') or jcr:like(fn:lower-case(@tagText),'%sampletext%') or jcr:like(fn:lower-case(@imagebadge),'%sampletext%') or jcr:like(fn:lower-case(@contentbadge),'%sampletext%') or jcr:like(fn:lower-case(@righsectiontheading),'%sampletext%') or jcr:like(fn:lower-case(@badgeTitle),'%sampletext%') or jcr:like(fn:lower-case(@contractTitle),'%sampletext%') or jcr:like(fn:lower-case(@flippedheading),'%sampletext%') or jcr:like(fn:lower-case(@desktopviewhovertext),'%sampletext%') or jcr:like(fn:lower-case(@mobileviewhovertext),'%sampletext%') or jcr:like(fn:lower-case(@btnaltText),'%sampletext%') or jcr:like(fn:lower-case(@footerAltText),'%sampletext%') or jcr:like(fn:lower-case(@leftfeature),'%sampletext%') or jcr:like(fn:lower-case(@rightfeature),'%sampletext%') or jcr:like(fn:lower-case(@postTitle),'%sampletext%') or jcr:like(fn:lower-case(@priceTitle),'%sampletext%') or jcr:like(fn:lower-case(@priceTitleWithAed),'%sampletext%') or jcr:like(fn:lower-case(@stepTitle),'%sampletext%') or jcr:like(fn:lower-case(@viewLessTitle),'%sampletext%') or jcr:like(fn:lower-case(@viewMoreTitle),'%sampletext%') or jcr:like(fn:lower-case(@tabTitle),'%sampletext%') or jcr:like(fn:lower-case(@backButtonText),'%sampletext%') or jcr:like(fn:lower-case(@copyLabel),'%sampletext%') or jcr:like(fn:lower-case(@copytoclipboard),'%sampletext%') or jcr:like(fn:lower-case(@shareDesignLabel),'%sampletext%') or jcr:like(fn:lower-case(@contactNumberLabel),'%sampletext%') or jcr:like(fn:lower-case(@emailIdLabel),'%sampletext%') or jcr:like(fn:lower-case(@fnameLabel),'%sampletext%') or jcr:like(fn:lower-case(@submitButtonText),'%sampletext%') or jcr:like(fn:lower-case(@termsConditionsText),'%sampletext%') or jcr:like(fn:lower-case(@altTextMobile),'%sampletext%') or jcr:like(fn:lower-case(@descriptionMobile),'%sampletext%') or jcr:like(fn:lower-case(@heading2),'%sampletext%') or jcr:like(fn:lower-case(@heading3),'%sampletext%') or jcr:like(fn:lower-case(@headingMobile),'%sampletext%') or jcr:like(fn:lower-case(@heading1),'%sampletext%') or jcr:like(fn:lower-case(@benefitdash),'%sampletext%') or jcr:like(fn:lower-case(@counterNumber),'%sampletext%') or jcr:like(fn:lower-case(@companyNameLabel),'%sampletext%') or jcr:like(fn:lower-case(@requirementLabel),'%sampletext%') or jcr:like(fn:lower-case(@productSubject),'%sampletext%') or jcr:like(fn:lower-case(@productValue),'%sampletext%') or jcr:like(fn:lower-case(@orderTitle),'%sampletext%') or jcr:like(fn:lower-case(@productDetailTitle),'%sampletext%') or jcr:like(fn:lower-case(@totalTitle),'%sampletext%') or jcr:like(fn:lower-case(@termsConditionsLabel),'%sampletext%') or jcr:like(fn:lower-case(@closeSummaryLabel),'%sampletext%') or jcr:like(fn:lower-case(@viewSummaryLabel),'%sampletext%') or jcr:like(fn:lower-case(@fullnameLabel),'%sampletext%') or jcr:like(fn:lower-case(@claimText),'%sampletext%') or jcr:like(fn:lower-case(@dialNumberText),'%sampletext%') or jcr:like(fn:lower-case(@buttonText),'%sampletext%') or jcr:like(fn:lower-case(@internetHeader),'%sampletext%') or jcr:like(fn:lower-case(@navigationField),'%sampletext%') or jcr:like(fn:lower-case(@filterDesc),'%sampletext%') or jcr:like(fn:lower-case(@alias),'%sampletext%') or jcr:like(fn:lower-case(@availableOptionText),'%sampletext%') or jcr:like(fn:lower-case(@contentTitle),'%sampletext%') or jcr:like(fn:lower-case(@specialTitle),'%sampletext%') or jcr:like(fn:lower-case(@moreinfoctalabel),'%sampletext%') or jcr:like(fn:lower-case(@hideTitle),'%sampletext%') or jcr:like(fn:lower-case(@showTitle),'%sampletext%') or jcr:like(fn:lower-case(@fromDescription),'%sampletext%') or jcr:like(fn:lower-case(@wasproductsubtitle),'%sampletext%') or jcr:like(fn:lower-case(@strikeoutTitle),'%sampletext%') or jcr:like(fn:lower-case(@oldPlanPrice),'%sampletext%') or jcr:like(fn:lower-case(@oldPriceFormat),'%sampletext%') or jcr:like(fn:lower-case(@iconTitle),'%sampletext%') or jcr:like(fn:lower-case(@serviceTitle),'%sampletext%') or jcr:like(fn:lower-case(@minsReadText),'%sampletext%') or jcr:like(fn:lower-case(@applyText),'%sampletext%') or jcr:like(fn:lower-case(@loadingText),'%sampletext%') or jcr:like(fn:lower-case(@priceRangeTitle),'%sampletext%') or jcr:like(fn:lower-case(@mostPopularText),'%sampletext%') or jcr:like(fn:lower-case(@pricehightolowText),'%sampletext%') or jcr:like(fn:lower-case(@pricelowtohighText),'%sampletext%') or jcr:like(fn:lower-case(@recommendText),'%sampletext%') or jcr:like(fn:lower-case(@sortbyText),'%sampletext%') or jcr:like(fn:lower-case(@emi),'%sampletext%') or jcr:like(fn:lower-case(@emipriceFormat),'%sampletext%') or jcr:like(fn:lower-case(@startingFrom),'%sampletext%') or jcr:like(fn:lower-case(@battery),'%sampletext%') or jcr:like(fn:lower-case(@camera),'%sampletext%') or jcr:like(fn:lower-case(@cpu),'%sampletext%') or jcr:like(fn:lower-case(@dimension),'%sampletext%') or jcr:like(fn:lower-case(@operatingsystem),'%sampletext%') or jcr:like(fn:lower-case(@screenres),'%sampletext%') or jcr:like(fn:lower-case(@screensize),'%sampletext%') or jcr:like(fn:lower-case(@sim),'%sampletext%') or jcr:like(fn:lower-case(@weight),'%sampletext%') or jcr:like(fn:lower-case(@emiTitle),'%sampletext%') or jcr:like(fn:lower-case(@popularBadgeTitle),'%sampletext%') or jcr:like(fn:lower-case(@recommendBadgeTitle),'%sampletext%') or jcr:like(fn:lower-case(@startsFrom),'%sampletext%') or jcr:like(fn:lower-case(@allcategoryText),'%sampletext%') or jcr:like(fn:lower-case(@secHeading),'%sampletext%') or jcr:like(fn:lower-case(@secHeading2),'%sampletext%') or jcr:like(fn:lower-case(@planDuration),'%sampletext%') or jcr:like(fn:lower-case(@planPackage),'%sampletext%') or jcr:like(fn:lower-case(@planTitle),'%sampletext%') or jcr:like(fn:lower-case(@dataUsesTitle),'%sampletext%') or jcr:like(fn:lower-case(@planContract),'%sampletext%') or jcr:like(fn:lower-case(@featureText),'%sampletext%') or jcr:like(fn:lower-case(@descriptionheading),'%sampletext%') or jcr:like(fn:lower-case(@socialAltText),'%sampletext%') or jcr:like(fn:lower-case(@language),'%sampletext%') or jcr:like(fn:lower-case(@category),'%sampletext%') or jcr:like(fn:lower-case(@service),'%sampletext%') or jcr:like(fn:lower-case(@learnMoreLabel),'%sampletext%') or jcr:like(fn:lower-case(@wasproductprice),'%sampletext%') or jcr:like(fn:lower-case(@productListText),'%sampletext%') or jcr:like(fn:lower-case(@contractText),'%sampletext%') or jcr:like(fn:lower-case(@flagText),'%sampletext%') or jcr:like(fn:lower-case(@mpctatitle),'%sampletext%') or jcr:like(fn:lower-case(@mpposttext),'%sampletext%') or jcr:like(fn:lower-case(@mppretext),'%sampletext%') or jcr:like(fn:lower-case(@mptitle),'%sampletext%') or jcr:like(fn:lower-case(@modalpretitle),'%sampletext%') or jcr:like(fn:lower-case(@simctatitle),'%sampletext%') or jcr:like(fn:lower-case(@simposttext),'%sampletext%') or jcr:like(fn:lower-case(@simpretext),'%sampletext%') or jcr:like(fn:lower-case(@simtitle),'%sampletext%') or jcr:like(fn:lower-case(@noncontractText),'%sampletext%') or jcr:like(fn:lower-case(@loadmorectatext),'%sampletext%') or jcr:like(fn:lower-case(@productcategoryid),'%sampletext%') or jcr:like(fn:lower-case(@productcategorybuttontitle),'%sampletext%') or jcr:like(fn:lower-case(@buttonshowhidelabel),'%sampletext%') or jcr:like(fn:lower-case(@packagedescription),'%sampletext%') or jcr:like(fn:lower-case(@speedunits),'%sampletext%') or jcr:like(fn:lower-case(@loggedinButtonTitle),'%sampletext%') or jcr:like(fn:lower-case(@loggedinbuyNowButton),'%sampletext%') or jcr:like(fn:lower-case(@moreinfolabel),'%sampletext%') or jcr:like(fn:lower-case(@buynowbutton),'%sampletext%') or jcr:like(fn:lower-case(@frequency),'%sampletext%') or jcr:like(fn:lower-case(@plan),'%sampletext%') or jcr:like(fn:lower-case(@productsubtitle),'%sampletext%') or jcr:like(fn:lower-case(@viewchannellistlabel),'%sampletext%') or jcr:like(fn:lower-case(@benefitsgridtitle),'%sampletext%') or jcr:like(fn:lower-case(@hideallbuttontitle),'%sampletext%') or jcr:like(fn:lower-case(@seeallbuttontitle),'%sampletext%') or jcr:like(fn:lower-case(@promotionbuttontitle),'%sampletext%') or jcr:like(fn:lower-case(@promotionpretitle),'%sampletext%') or jcr:like(fn:lower-case(@paginationtext),'%sampletext%') or jcr:like(fn:lower-case(@searchbuttonlabel),'%sampletext%') or jcr:like(fn:lower-case(@placeholder),'%sampletext%') or jcr:like(fn:lower-case(@recentlabel),'%sampletext%') or jcr:like(fn:lower-case(@suggestionlabel),'%sampletext%') or jcr:like(fn:lower-case(@header),'%sampletext%') or jcr:like(fn:lower-case(@didyoumean),'%sampletext%') or jcr:like(fn:lower-case(@relatedtext),'%sampletext%') or jcr:like(fn:lower-case(@btnlabel),'%sampletext%') or jcr:like(fn:lower-case(@closeMenuAltText),'%sampletext%') or jcr:like(fn:lower-case(@openMenuAltText),'%sampletext%') or jcr:like(fn:lower-case(@menuIconAltText),'%sampletext%') or jcr:like(fn:lower-case(@langAltText),'%sampletext%') or jcr:like(fn:lower-case(@loginAltText),'%sampletext%') or jcr:like(fn:lower-case(@ripponLabel),'%sampletext%') or jcr:like(fn:lower-case(@sharetext),'%sampletext%') or jcr:like(fn:lower-case(@afterSubmitMessage),'%sampletext%') or jcr:like(fn:lower-case(@lnameLabel),'%sampletext%') or jcr:like(fn:lower-case(@callBackLabel),'%sampletext%') or jcr:like(fn:lower-case(@feedbackLabel),'%sampletext%') or jcr:like(fn:lower-case(@inquiriesLabel),'%sampletext%') or jcr:like(fn:lower-case(@othersLabel),'%sampletext%') or jcr:like(fn:lower-case(@suggestionsLabel),'%sampletext%') or jcr:like(fn:lower-case(@commentLabel),'%sampletext%') or jcr:like(fn:lower-case(@collapseText),'%sampletext%') or jcr:like(fn:lower-case(@expandText),'%sampletext%') or jcr:like(fn:lower-case(@loginText),'%sampletext%') or jcr:like(fn:lower-case(@backgroundImageLabel),'%sampletext%') or jcr:like(fn:lower-case(@closeButtonLabel),'%sampletext%') or jcr:like(fn:lower-case(@ctaButtonText),'%sampletext%') or jcr:like(fn:lower-case(@fixedCoverageDesc),'%sampletext%') or jcr:like(fn:lower-case(@fixedCoverageLabel),'%sampletext%') or jcr:like(fn:lower-case(@locationListViewLabel),'%sampletext%') or jcr:like(fn:lower-case(@locationMapViewLabel),'%sampletext%') or jcr:like(fn:lower-case(@locationhreftextlabel),'%sampletext%') or jcr:like(fn:lower-case(@locationsearchbuttontext),'%sampletext%') or jcr:like(fn:lower-case(@lteDesc),'%sampletext%') or jcr:like(fn:lower-case(@lteLabel),'%sampletext%') or jcr:like(fn:lower-case(@mobileCoverageLabel),'%sampletext%') or jcr:like(fn:lower-case(@nbiotLabel),'%sampletext%') or jcr:like(fn:lower-case(@nboitDesc),'%sampletext%') or jcr:like(fn:lower-case(@paginationLabel),'%sampletext%') or jcr:like(fn:lower-case(@searchplaceholdertext),'%sampletext%') or jcr:like(fn:lower-case(@showOnMapLabel),'%sampletext%') or jcr:like(fn:lower-case(@getstartedLink),'%sampletext%') or jcr:like(fn:lower-case(@guidetourTitle),'%sampletext%') or jcr:like(fn:lower-case(@layouttitle),'%sampletext%') or jcr:like(fn:lower-case(@enterColumnNumberToSort),'%sampletext%') or jcr:like(fn:lower-case(@nosearchresultstext),'%sampletext%') or jcr:like(fn:lower-case(@seeLessText),'%sampletext%') or jcr:like(fn:lower-case(@seeMoreText),'%sampletext%') or jcr:like(fn:lower-case(@tableTitle),'%sampletext%') or jcr:like(fn:lower-case(@viewLessText),'%sampletext%') or jcr:like(fn:lower-case(@viewMoreText),'%sampletext%') or jcr:like(fn:lower-case(@tabtitlemain),'%sampletext%') or jcr:like(fn:lower-case(@ctatitle),'%sampletext%') or jcr:like(fn:lower-case(@learmore),'%sampletext%') or jcr:like(fn:lower-case(@mediaCTAMainTitle),'%sampletext%') or jcr:like(fn:lower-case(@gridTitle),'%sampletext%') or jcr:like(fn:lower-case(@gacategoryid),'%sampletext%') or jcr:like(fn:lower-case(@gacategorylist),'%sampletext%') or jcr:like(fn:lower-case(@addnbenefitsTitle),'%sampletext%') or jcr:like(fn:lower-case(@benefitsTooltipInfo),'%sampletext%') or jcr:like(fn:lower-case(@benefitsInfo),'%sampletext%') or jcr:like(fn:lower-case(@benefitsInfoMonth),'%sampletext%') or jcr:like(fn:lower-case(@benefitsStrikethrough),'%sampletext%') or jcr:like(fn:lower-case(@onclickfunction),'%sampletext%') or jcr:like(fn:lower-case(@attributeKey),'%sampletext%') or jcr:like(fn:lower-case(@attributeValue),'%sampletext%') or jcr:like(fn:lower-case(@featuresdescription),'%sampletext%') or jcr:like(fn:lower-case(@answer),'%sampletext%') or jcr:like(fn:lower-case(@tooltipdesc),'%sampletext%') or jcr:like(fn:lower-case(@crosspromoplansDescription),'%sampletext%') or jcr:like(fn:lower-case(@shortdesc),'%sampletext%') or jcr:like(fn:lower-case(@featuredescription),'%sampletext%') or jcr:like(fn:lower-case(@paragraph),'%sampletext%') or jcr:like(fn:lower-case(@headingdescription),'%sampletext%') or jcr:like(fn:lower-case(@tiledescription),'%sampletext%') or jcr:like(fn:lower-case(@heroimagedescription),'%sampletext%') or jcr:like(fn:lower-case(@colourDataDescription),'%sampletext%') or jcr:like(fn:lower-case(@maindescription),'%sampletext%') or jcr:like(fn:lower-case(@needhelpDescription),'%sampletext%') or jcr:like(fn:lower-case(@address),'%sampletext%') or jcr:like(fn:lower-case(@maintextdesc),'%sampletext%') or jcr:like(fn:lower-case(@descriptionrte),'%sampletext%') or jcr:like(fn:lower-case(@paragraphrte),'%sampletext%') or jcr:like(fn:lower-case(@formDescription),'%sampletext%') or jcr:like(fn:lower-case(@desc),'%sampletext%') or jcr:like(fn:lower-case(@paragraphboldrte),'%sampletext%') or jcr:like(fn:lower-case(@table),'%sampletext%') or jcr:like(fn:lower-case(@promotionaldescription),'%sampletext%') or jcr:like(fn:lower-case(@toolTipdescription),'%sampletext%') or jcr:like(fn:lower-case(@ctadesc),'%sampletext%') or jcr:like(fn:lower-case(@wasProductTitle),'%sampletext%') or jcr:like(fn:lower-case(@footernote),'%sampletext%') or jcr:like(fn:lower-case(@productdescription),'%sampletext%') or jcr:like(fn:lower-case(@tooltip),'%sampletext%') or jcr:like(fn:lower-case(@promotiondescription),'%sampletext%') or jcr:like(fn:lower-case(@searchnotfound),'%sampletext%') or jcr:like(fn:lower-case(@shortdescription),'%sampletext%') or jcr:like(fn:lower-case(@additionaldescription),'%sampletext%') or jcr:like(fn:lower-case(@quote),'%sampletext%') or jcr:like(fn:lower-case(@storeLocationBodyDescription),'%sampletext%') or jcr:like(fn:lower-case(@textAboveSlider),'%sampletext%') or jcr:like(fn:lower-case(@contextCardDescription),'%sampletext%') or jcr:like(fn:lower-case(@mediaCTAMainDescription),'%sampletext%'))] option(traversal ok)

 

 

PFB warning message in error.log

 

org.apache.jackrabbit.oak.query.QueryImpl Potentially improper use of index /oak:index/pathReference with queryFilterRegex (["']|^)/ to search for value 'is not null'

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi, 

You are getting a 503 error because the service is taking too long to respond. This issue is likely due to the service’s poor performance. I guess that your query works fine locally because you may have less content compared to the environment where you are testing. Ideally, you should avoid using QueryBuilder for these operations, or at the very least, ensure that an appropriate index is associated with it. According to your error message, it seems that this is not happening. Please verify if your index is deployed correctly and ensure that it is taking effect by testing the query with the Query Explorer.

 

Please read more here: https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/operations/query...

https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/operations/index... 

 

Hope this helps



Esteban Bustamante

View solution in original post

3 Replies

Avatar

Level 7

Hi @rajat168 ,

You may have a look https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/operations/remov...

MukeshYadav__0-1722939296770.png

One reason data may more on Cloud instance so it is getting timed out as error suggest

Also is you search string  'is not null'?

Thanks

 

Avatar

Correct answer by
Community Advisor

Hi, 

You are getting a 503 error because the service is taking too long to respond. This issue is likely due to the service’s poor performance. I guess that your query works fine locally because you may have less content compared to the environment where you are testing. Ideally, you should avoid using QueryBuilder for these operations, or at the very least, ensure that an appropriate index is associated with it. According to your error message, it seems that this is not happening. Please verify if your index is deployed correctly and ensure that it is taking effect by testing the query with the Query Explorer.

 

Please read more here: https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/operations/query...

https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/operations/index... 

 

Hope this helps



Esteban Bustamante