Query postgresssql
Dear Support,
We have migrated from MYSQL to postgresssql.
We have a report that is not working anymore..
SELECT sdo.DESCRIPTION "Site",pd.PRIORITYNAME "Priority",std.STATUSNAME "Request Status",wos.ISOVERDUE "Overdue Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time", wo.SITEID "siteid", qd.QUEUENAME "Group",ti.FIRST_NAME "Technician" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN CI ci ON sdu.CIID=ci.CIID LEFT JOIN SDOrganization sdo ON ci.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE ((((wo.COMPLETEDTIME >= <from_lastmonth>) AND ((longtodate(wo.COMPLETEDTIME) != 0) AND (longtodate(wo.COMPLETEDTIME) IS NOT NULL))) AND ((wo.COMPLETEDTIME <= <to_lastmonth>) AND (((longtodate(wo.COMPLETEDTIME) != 0) AND (longtodate(wo.COMPLETEDTIME) IS NOT NULL)) AND (longtodate(wo.COMPLETEDTIME) != -1))))) AND wo.ISPARENT=1 AND wo.IS_CATALOG_TEMPLATE=0
Can you help us to make it work on postgresssql?
We have migrated from MYSQL to postgresssql.
We have a report that is not working anymore..
SELECT sdo.DESCRIPTION "Site",pd.PRIORITYNAME "Priority",std.STATUSNAME "Request Status",wos.ISOVERDUE "Overdue Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time", wo.SITEID "siteid", qd.QUEUENAME "Group",ti.FIRST_NAME "Technician" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN CI ci ON sdu.CIID=ci.CIID LEFT JOIN SDOrganization sdo ON ci.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE ((((wo.COMPLETEDTIME >= <from_lastmonth>) AND ((longtodate(wo.COMPLETEDTIME) != 0) AND (longtodate(wo.COMPLETEDTIME) IS NOT NULL))) AND ((wo.COMPLETEDTIME <= <to_lastmonth>) AND (((longtodate(wo.COMPLETEDTIME) != 0) AND (longtodate(wo.COMPLETEDTIME) IS NOT NULL)) AND (longtodate(wo.COMPLETEDTIME) != -1))))) AND wo.ISPARENT=1 AND wo.IS_CATALOG_TEMPLATE=0
Can you help us to make it work on postgresssql?