Failed to execute search

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.

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.