topic Alfresco Share :- Lucene Query Doubt in Data WebScript in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263601#M216731 <HTML><HEAD></HEAD><BODY><SPAN>Hi All and Alfresco Team,</SPAN><BR /><BR /><SPAN>I wrote one data webscript which fetches data from Alfresco Repository.</SPAN><BR /><BR /><SPAN>Inside that webscript , I am searching through </SPAN><STRONG>LUCENE </STRONG><SPAN>Query.</SPAN><BR /><BR /><SPAN>I am passing</SPAN><STRONG> one argument </STRONG><SPAN>while calling the webscript which is nothing but a folder name in Alfresco Site.</SPAN><BR /><BR /><SPAN>var level = args.folderPath;</SPAN><BR /><STRONG>var searchQuery = "PATH:\"/app:company_home/st:sites/cm:defaultsite3/cm:documentLibrary/cm:Active"+level+"\" AND TYPE:\"cm:folder\"";</STRONG><BR /><BR /><SPAN>[size=150]I am taking care for putting /cm: before passing argument programatically.[/size]</SPAN><BR /><BR /><SPAN>As I faced issue that from front-end if I am passing </SPAN><STRONG>Retail </STRONG><SPAN>then query goes perfectly , but if I pass </SPAN><STRONG>Customer&lt;space&gt;Report</STRONG><SPAN> –&gt; Customer Report then Space was not recognized and query goes till Customer which should not be the correct one.</SPAN><BR /><BR /><SPAN>So I found the solution and it is as per below </SPAN><BR /><BR /><STRONG>SPACE Solution : - </STRONG><BR /><SPAN>var level = args.folderPath;</SPAN><BR /><SPAN>if(args.folderPath != null)</SPAN><BR /><SPAN>{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;level = level.replace(" ","_x0020_");</SPAN><BR /><SPAN>}</SPAN><BR /><BR /><SPAN>Which works perfectly.</SPAN><BR /><BR /><SPAN>But I am also passing some thing like </SPAN><BR /><BR /><SPAN>1) Health &amp; Insurance or </SPAN><BR /><SPAN>2) Health&amp;Insurance </SPAN><BR /><BR /><SPAN>then the lucene doesn't work</SPAN><BR /><BR /><STRONG>1) Health &amp; Insurance&nbsp; (Health&lt;space&gt;&amp;&lt;Space&gt;Insurance) </STRONG><BR /><BR /><SPAN>var level = args.folderPath;</SPAN><BR /><SPAN>if(args.folderPath != null)</SPAN><BR /><SPAN>{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;level = level.replace(" ","_x0020_");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;level = level.replace(" ","_x0026_");</SPAN><BR /><SPAN>}</SPAN><BR /><BR /><SPAN>then in Query it goes some thing like </SPAN><BR /><BR /><SPAN>Health_x0020_</SPAN><BR /><BR /><SPAN>in place of level which is not correct</SPAN><BR /><BR /><STRONG>2) Health&amp;Insurance&nbsp; (Health&lt;EmperSand&gt;Insurance) </STRONG><BR /><BR /><SPAN>var level = args.folderPath;</SPAN><BR /><SPAN>if(args.folderPath != null)</SPAN><BR /><SPAN>{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; level = level.replace("&amp;","_x0026_"); // or level = level.replace("\&amp;","_x0026_"); or level = level.replace("&amp;amp;","_x0026_"); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // or level = level.replace("amp;","_x0026_");</SPAN><BR /><SPAN>}</SPAN><BR /><BR /><SPAN>then in Query it goes something like only</SPAN><BR /><BR /><SPAN>Health</SPAN><BR /><BR /><SPAN>I tested the same query in Node Browser of Alfresco</SPAN><EM><STRONG>[size=150] it works perfectly for [/size]</STRONG></EM><BR /><SPAN>PATH:"/app:company_home/st:sites/cm:defaultsite3/cm:documentLibrary/cm:Active/cm:Retail " AND TYPE:"cm:folder"</SPAN><BR /><BR /><STRONG>(Customer Report) </STRONG><SPAN> Space :- PATH:"/app:company_home/st:sites/cm:defaultsite3/cm:documentLibrary/cm:Active/cm:Customer_x0020_Report " AND TYPE:"cm:folder"</SPAN><BR /><BR /><STRONG>(Health&amp;Insurance)</STRONG><SPAN> EmperSand :- PATH:"/app:company_home/st:sites/cm:defaultsite3/cm:documentLibrary/cm:Active/cm:Health_x0026_Insurance" AND TYPE:"cm:folder"</SPAN><BR /><BR /><STRONG>(Health &amp; Insurance) </STRONG><SPAN> Space and EmperSand :-&nbsp; PATH:"/app:company_home/st:sites/cm:defaultsite3/cm:documentLibrary/cm:Active/cm:Health_x0020__x0026__x0020_Insurance" AND TYPE:"cm:folder"</SPAN><BR /><BR /><SPAN>Please Guide me how to resolve this Lucene Query Issue Programatically ?</SPAN><BR /><BR /><SPAN>Thanks and Regards,</SPAN><BR /><SPAN>Nove</SPAN></BODY></HTML> Tue, 22 Nov 2011 10:29:04 GMT nove-2011 2011-11-22T10:29:04Z Alfresco Share :- Lucene Query Doubt in Data WebScript https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263601#M216731 Hi All and Alfresco Team,I wrote one data webscript which fetches data from Alfresco Repository.Inside that webscript , I am searching through LUCENE Query.I am passing one argument while calling the webscript which is nothing but a folder name in Alfresco Site.var level = args.folderPath;var search Tue, 22 Nov 2011 10:29:04 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263601#M216731 nove-2011 2011-11-22T10:29:04Z Re: Alfresco Share :- Lucene Query Doubt in Data WebScript https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263602#M216732 <HTML><HEAD></HEAD><BODY><SPAN>You need to ISO9075 encode your QNames.&nbsp; There should be a utility to help you.</SPAN></BODY></HTML> Tue, 22 Nov 2011 11:16:58 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263602#M216732 mrogers 2011-11-22T11:16:58Z Re: Alfresco Share :- Lucene Query Doubt in Data WebScript https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263603#M216733 <HTML><HEAD></HEAD><BODY><SPAN>Dear mrogers,</SPAN><BR /><BR /><SPAN>I forgot to mention in my POST that I have already tried for that but its still not working.</SPAN><BR /><BR /><SPAN>Please Guide sir.</SPAN><BR /><BR /><SPAN>-Nove</SPAN></BODY></HTML> Tue, 22 Nov 2011 11:48:48 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-share-lucene-query-doubt-in-data-webscript/m-p/263603#M216733 nove-2011 2011-11-22T11:48:48Z