This page is using database connectivity
SQL = SELECT TOP 99 * FROM ( SELECT T1."WorkItemScheduleID", T1."ScheduleOrder", T1."Description", T1."LineType", T1."LineStatus", to_varchar("PlanDate", 'YYYY-MM-DD HH24:MI:SS') AS "PlanDate", T1."FullFillDate", T1."FullFillSource", T1."FullFillReference", T2."WorkItemID", T2."WorkItemDocNum", T2."Matchcode", to_varchar("WorkItemStart", 'YYYY-MM-DD HH24:MI:SS') AS "WorkItemStart", to_varchar("WorkItemEnd", 'YYYY-MM-DD HH24:MI:SS') AS "WorkItemEnd", CAST(LEFT(T2."WorkDescription",255) AS NVARCHAR(255)) AS "WorkDescription", CAST(LEFT(T2."WorkNotes",255) AS NVARCHAR(255)) AS "WorkNotes", T2."RegisterProcess", T2."VisibilityPortal", T2."WorkItemType" FROM "MARIWorkItemScheduleDates" As T1 INNER JOIN "MARIWorkItem" As T2 ON T1."WorkItemID" = T2."WorkItemID" WHERE T1."FullFillReference" IS NULL OR T1."FullFillReference" = '' UNION ALL SELECT T1."WorkItemScheduleID", T1."ScheduleOrder", T1."Description", T1."LineType", T1."LineStatus", to_varchar("PlanDate", 'YYYY-MM-DD HH24:MI:SS') AS "PlanDate", T1."FullFillDate", T1."FullFillSource", T1."FullFillReference", T2."WorkItemID", T2."WorkItemDocNum", T2."Matchcode", to_varchar("WorkItemStart", 'YYYY-MM-DD HH24:MI:SS') AS "WorkItemStart", to_varchar("WorkItemEnd", 'YYYY-MM-DD HH24:MI:SS') AS "WorkItemEnd", CAST(LEFT(T2."WorkDescription",255) AS NVARCHAR(255)) AS "WorkDescription", CAST(LEFT(T2."WorkNotes",255) AS NVARCHAR(255)) AS "WorkNotes", T2."RegisterProcess", T2."VisibilityPortal", T2."WorkItemType" FROM "MARIWorkItemScheduleDates" As T1 RIGHT OUTER JOIN "MARIWorkItem" As T2 ON T1."WorkItemID"=T2."WorkItemID" ) As A WHERE A."WorkItemType"=492 AND A."VisibilityPortal"=4 AND CASE WHEN A."PlanDate" IS NOT NULL THEN A."PlanDate" ELSE A."WorkItemStart" END>'2026-10-24 07:30:18' ORDER BY CASE WHEN A."PlanDate" IS NOT NULL THEN A."PlanDate" ELSE A."WorkItemStart" END