Failed to execute search

[vamirr]

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 results = search.query(def);


I'm getting the error: Failed to execute search: select e.* from st:site as e where e.cm:name ='mynewsite'

[jordiv]

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.

[andy]

Hi

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

What is the full exception?

Andy