ApplySQL Previleges Issue

I wonder if applySQL in a JS Method will work at all. It definitely makes sense that Innovator will restrict direct SQL inside a client Method.

But there are also other factors that can restrict Method execution. Which Innovator version are you using? Innovator 12 or 11?

In Innovator 12 Aras changed default Method "can execute" to "Administrators". You have to change this property to a appropriate user group (not "World" !!). 

Instead of using loadAML, I would use a simpler structure for the query that basically does the same. 

var inn = new Innovator();
var doc = inn.newItem("MyDoc", "get");
doc.setAttribute("select", "id,"); 
doc.setPropertyCondition("xyz","like");
doc.setProperty("xyz","%abc%");
doc = doc.apply();