16:46:05 - IsConnectionValid True
16:46:06 - IsConnectionValid True
16:46:12 - IsConnectionValid True
16:46:12 - IsConnectionValid True
16:46:16 - IsConnectionValid True
16:46:22 - IsConnectionValid True
16:46:22 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
17:53:39 - IsConnectionValid True
17:53:52 - IsConnectionValid True
17:54:28 - IsConnectionValid True
17:54:46 - IsConnectionValid True
17:54:46 - SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
17:54:48 - IsConnectionValid True
17:54:49 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
17:55:07 - IsConnectionValid True
17:55:07 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND Code LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
17:55:33 - IsConnectionValid True
17:55:33 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND Code LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
17:55:38 - IsConnectionValid True
17:55:53 - IsConnectionValid True
17:55:54 - IsConnectionValid True