The argument in the following SQL statement for my v11 grid causes Alpha to lockup whenever I attempt to go back into the "Edit Sql in Query Builder" button. If I remove the WHERE clause containing the argument, it will bring up the builder correctly. Although, it does load much more slowly than normal. I have many other similar grids, some with much larger SELECT statements, using this same argument and have had no problems.
If I add the WHERE clause and Execute the query, it returns data properly in the Preview window.
But, if I close the SQL genie and then try to come back into it, it locks up.
I have created started over with a completely new grid and rebuilt it from scratch and ended up with the same problem.
SELECT workflowtracking.pkid, workflowtracking.cid, workflowtracking.empid, suffix.suffixclassid, Concatenate( If(employees.firstname IS NULL , '', employees.firstname) , If(employees.middlename IS NULL , '', Concatenate(' ', employees.middlename) ) , If(employees.lastname IS NULL , '', Concatenate(' ', employees.lastname) ) , If(suffix.suffix IS NULL , '', Concatenate(', ', suffix.suffix) ) ) AS EmployeeName, workflowtracking.orderid, workflowtracking.deptid, department.departmentenglish, workflowtracking.description, workflowtracking.rollid, workflowtracking.timestamp, workflowtracking.moddatetime, workflowtracking.modempid
FROM (workflowtracking workflowtracking
LEFT OUTER JOIN department department
ON workflowtracking.cid = department.cid AND workflowtracking.deptid = department.deptid
LEFT OUTER JOIN (employees employees
LEFT OUTER JOIN suffix suffix
ON employees.cid = suffix.cid AND employees.suffixclassid = suffix.suffixclassid )
ON workflowtracking.cid = employees.cid AND workflowtracking.empid = employees.empid )
WHERE workflowtracking.cid = :companyid
Thanks for looking.......
If I add the WHERE clause and Execute the query, it returns data properly in the Preview window.
But, if I close the SQL genie and then try to come back into it, it locks up.
I have created started over with a completely new grid and rebuilt it from scratch and ended up with the same problem.
SELECT workflowtracking.pkid, workflowtracking.cid, workflowtracking.empid, suffix.suffixclassid, Concatenate( If(employees.firstname IS NULL , '', employees.firstname) , If(employees.middlename IS NULL , '', Concatenate(' ', employees.middlename) ) , If(employees.lastname IS NULL , '', Concatenate(' ', employees.lastname) ) , If(suffix.suffix IS NULL , '', Concatenate(', ', suffix.suffix) ) ) AS EmployeeName, workflowtracking.orderid, workflowtracking.deptid, department.departmentenglish, workflowtracking.description, workflowtracking.rollid, workflowtracking.timestamp, workflowtracking.moddatetime, workflowtracking.modempid
FROM (workflowtracking workflowtracking
LEFT OUTER JOIN department department
ON workflowtracking.cid = department.cid AND workflowtracking.deptid = department.deptid
LEFT OUTER JOIN (employees employees
LEFT OUTER JOIN suffix suffix
ON employees.cid = suffix.cid AND employees.suffixclassid = suffix.suffixclassid )
ON workflowtracking.cid = employees.cid AND workflowtracking.empid = employees.empid )
WHERE workflowtracking.cid = :companyid
Thanks for looking.......
Comment