Folders

Calling getSQLResults Tool from a Content:

Query: select * from identifier where id in (select identifier from contentlet where structure_inode in (select inode from structure where structuretype = 5 AND name = 'Page Asset')));

Results: [{hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}]

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

Calling getSQLResults Tool from a Content:

Query: select * from identifier where asset_type = 'htmlpage' and parent_path = '/home/'

Results: [{hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}]

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

Calling getParameterizedSQLResults Tool from a Content:

Query: "select * from identifier where asset_type = ? and parent_path = ?"
Params: 'htmlpage','/home/'

Results: [{hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}]

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

Calling getSQLResults Tool from a Content:

Query: select * from identifier where id in (select identifier from contentlet where structure_inode in (select inode from structure where structuretype = 5 AND name = 'Page Asset')));

Results: [{hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}, {hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}]

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

Calling getSQLResults Tool from a Content:

Query: select * from identifier where asset_type = 'htmlpage' and parent_path = '/home/'

Results: [{hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}, {hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}]

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

Calling getParameterizedSQLResults Tool from a Content:

Query: "select * from identifier where asset_type = ? and parent_path = ?"
Params: 'htmlpage','/home/'

Results: [{hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}, {hasDotConnectSQLError=true, dotConnectSQLError=Content Editor cannot execute the SQLResultsViewTool becase it does not have enough permissions to do it}]

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")

ID: $res.get("id")
Parent Path: $res.get("parent_path")
Asset Name: $res.get("asset_name")
Asset Type: $res.get("asset_type")