11:12:54 - IsConnectionValid True 11:13:06 - IsConnectionValid True 11:13:10 - IsConnectionValid True 11:13:10 - IsConnectionValid True 11:13:12 - IsConnectionValid True 11:13:20 - IsConnectionValid True 11:13:20 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:13:26 - IsConnectionValid True 11:13:26 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 11:13:26 - IsConnectionValid True 11:13:26 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 11:13:29 - IsConnectionValid True 11:14:00 - IsConnectionValid True 11:14:08 - IsConnectionValid True 11:14:10 - IsConnectionValid True 11:14:10 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:14:16 - IsConnectionValid True 11:14:16 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 11:14:16 - IsConnectionValid True 11:14:16 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 11:14:20 - IsConnectionValid True 11:24:33 - IsConnectionValid True 11:24:34 - IsConnectionValid True 11:24:34 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:24:36 - IsConnectionValid True 11:24:44 - IsConnectionValid True 11:24:44 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 11:24:44 - IsConnectionValid True 11:24:44 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 11:24:46 - IsConnectionValid True 11:28:48 - IsConnectionValid True 11:28:48 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.JobID = @val2 AND CAST(E.dateleft AS Date) = @val3 GROUP BY J.Name Query 11:28:49 - IsConnectionValid True 11:36:30 - IsConnectionValid True 11:36:32 - IsConnectionValid True 11:36:32 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:39:30 - IsConnectionValid True 11:39:31 - IsConnectionValid True 11:39:31 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:39:35 - IsConnectionValid True 11:39:36 - IsConnectionValid True 11:39:36 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:44:05 - IsConnectionValid True 11:44:09 - IsConnectionValid True 11:44:09 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 11:44:24 - IsConnectionValid True 11:44:28 - IsConnectionValid True 11:44:28 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 12:04:04 - IsConnectionValid True 12:04:10 - IsConnectionValid True 12:04:10 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query