13.1.2.2.8.8. Method – ExecuteSQLQuery (SQLService)

This sample script demonstrates how to execute an SQL query and get a result.

Syntax

IList ExecuteSqlQuery(string query)
IList ExecuteSqlQuery(string query, Dictionary Parameters)
IList ExecuteSqlQueryFromDB(string query)
IList ExecuteSqlQueryFromDB(string query, Dictionary Parameters)

Applicability

This functionality is available anywhere users can write C# code.

Code Sample

var cnt = (int)bpmAppService.BPMSServices.SqlService.ExecuteSqlQuery("select count(*) from ray.BPMAPP_ACAN_Document where groupId = '" + domainObject.GroupId.ToString() +"'")[0];

var q = string.Format("Select Document from ray.BPMAPP_ACAN_DocumentOwners where Owner ='0'", formObject.Owner);
var filteredIDs = bpmAppService.BPMSServices.SqlService.ExecuteSqlQuery(q);
includedId.AddRange(filteredIDs.Cast());

var fleetList = bpmAppService.BPMSServices.SqlService.ExecuteSqlQueryFromDB(string.Format("select * from ray.BPMAPP_ACAN_ExternalUserPermissionFleet where [UserPermission] = '0'", profile.Id));

var seq = bpmAppService.BPMSServices.SqlService.ExecuteSqlQuery("select isnull(max(DrawingSeqMajor),29999) + 1 seqno from ray.BPMAPP_ACAN_Document")[0];
formObject.NextMajor = (int)seq;