queryUsingSQL()

Syntax

Concept[] queryUsingSQL(String conceptURI, String sql, boolean queryChildren)

Where, conceptURI is the URI of the result concept type, and sql is the SQL statement to be executed. If queryChildren boolean is set to true, concept properties are recursively queried. The function returns an array of result concepts.

Example

Database.setCurrentConnection("/SharedResources/Mainframe");
Database.beginTransaction();
Concepts.BEUSER.CAR_TABLE []ct = Database.queryUsingSQL("/Concepts/BEUSER/CAR_TABLE","select * from BEUSER.CAR_TABLE",true);
for(int i=0;i<ct@length;i=i+1)  {
   System.debugOut(""+ct[i].CAR_ID+ct[i].TIRE_TABLE[0].CAR_ID+ct[i].TIRE_TABLE[0].TIRE_ID);
}
Database.unsetConnection();