WebScript: query fails

[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!";
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[mduduzi]

Hi,

Thanks I have now got both queries working, the Lucene and cmis.

[mduduzi]

Hi,

I am following the example on the ff url : https://partage.inria.fr/share/service/script/org/alfresco/modules/create-event.get

It is failing with the following error:

09150016 Wrapped Exception (with status template): 09150114 Failed to execute script '/com/greenenergy/em/Calendar Event/create-event.get.js (in repository store workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts Extensions)': syntax error (workspace://SpacesStore/Company Home/Data Dictionary/Web Scripts Extensions/com/greenenergy/em/Calendar Event/create-event.get.js#7)
‍‍‍

in the ff javascript:

<import resource="classpath:alfresco/site-webscripts/org/alfresco/callutils.js">
if (args['uri']) 
{
 

      
   var uri = unescape(args['uri']);
   // Call the repo for the event information
   model.event = doGetCall(uri);
   model.edit = true;
}
else
{
   model.event = {};
   model.event.what = model.event.location = model.event.description = '';
   model.edit =false;
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍