topic Re: Failed to execute search in Alfresco Archive

Failed to execute search

vamirr — Tue, 20 Sep 2011 21:08:49 GMT

I'm trying to do a query for a site whose name is equal to an arbitrary variable. I'm not seeing what's wrong with the query below:var mySite = "mynewsite";var def = { query: "select e.* from st:site as e where e.cm:name =' " + mySite + " ' " , language: "cmis-alfresco" }; var resul

Re: Failed to execute search

jordiv — Wed, 21 Sep 2011 08:12:39 GMT

Try using "e.cmis:name" instead of "e.cm:name":


var mySite = "mynewsite";
var def = {
  query: "SELECT e.* FROM st:site AS e WHERE e.cmis:name = '" + mySite + "'", language: "cmis-alfresco" }; 
var results = search.query(def);
‍‍‍‍‍‍

Cheers,
Jordi.

Re: Failed to execute search

andy — Thu, 22 Sep 2011 09:28:50 GMT

Hi

I would suggest the same solution and use the cmis name property.

What is the full exception?

Andy