WebScript: query fails

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

mduduzi

Hi all,

I am new in webscripts. I have created the following components in /com/greenenergy/em/lab3/:

1. Descriptor xml

<webscript> 
   <shortname>Get ConfigDoc Test</shortname>
   <description>Get ConfigDoc Test</description>
   <family>Green Energy</family>
   <url>/com/greenenergy/em/lab3/getconfigdoc/{serialnum}</url>
   <format default="html"/>
   <authentication>user</authentication>
</webscript>
‍‍‍‍‍‍‍‍‍‍

2. Controller js

var serialnum = url.templateArgs["serialnum"];
var docquery = 'select e.* from geem:equipment as e where e.geem:serialnum='+serialnum;
var def = {query:docquery,language:"cmis-alfresco"};
var results = search.query(def);
if(results!=null)
 {
    doc = results[0];
   model.docnode = doc;
 }
else
 {
   status.redirect=true;
   status.code=401;
   status.message="Equipment document with serial number: " + serialnum + ", was not found!";
 }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

3. Template ftl

<a href="${url.serviceContext}/api/node/content/${docnode.nodeRef.storeRef.protocol}/${docnode.nodeRef.storeRef.identifier}/${docnode.nodeRef.id}/${docnode.name?url}">${docnode.name}</a>
‍‍‍

I am getting the following error when I call the webscipt:

08260046 Wrapped Exception (with status template): 08260338 Failed to execute script '/com/greenenergy/em/lab3/getConfigDoc.get.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts Extensions)': 08260337 Failed to execute search: select e.* from geem:equipment as e where e.geem:serialnum=77777
‍‍‍

Please note the I have checked for the existence of geem:serialnum in the custom type geem:equipment. I am using alfresco 4 community.

Thanks!

lementree

Hi,

I am not familiar with CMIS query, but You can acheive the same with Lucene query.

var serialnum = url.templateArgs["serialnum"];
var results = search.luceneSearch("@geem\:serialnum:\"'+serialnum+"\""); 
if(results!=null)
{
   doc = results[0];
   model.docnode = doc;
}
else
{
   status.redirect=true;
   status.code=401;
   status.message="Equipment document with serial number: " + serialnum + ", was not found!";
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍