Fetching information from the current database can be done using both the “code” and “design” methods, which are given below the related description:

bpmAppService.BPMSServices.HQLService.ExecuteHqlQuery (input1);
input1: String “Required Query” (string q = string.Format (“FROM BPMAPP_HGRequest WHERE Shop IS NULL”)
Output: List (Query result)