We are using SD plus 8.2.0 Build 8212.

in Reports, I run a report thats get formatted as expected. When opening the Query editor for making an adjustment to the Query, the Query editor mess up the field format for one particular field. Please note that this happens as soon as I save the Query regardless if I make any Changes or not. I discovered this while trying to modify a specific fields number formatting.

This is the Query thats works fine in SD plus as long as I dont re-save it in Query editor  (no Changes made in Query)

SELECT sdo.NAME "Site",wo.WORKORDERID "Request ID",sdo.NAME "Site",aau.FIRST_NAME "Requester",wo.TITLE "Subject",std.STATUSNAME "Request Status",longtodate(wo.COMPLETEDTIME) "Completed Time",ct.DESCRIPTION "Time Spent Description",ct.TIMESPENT "Time Spent",ct.TOTAL_CHARGE "Time Spent Total_Charge" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN RegionDefinition regionDef ON siteDef.REGIONID=regionDef.REGIONID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((regionDef.REGIONNAME = 'Hyresgäster') AND (((wo.RESOLVEDTIME >= 1385852400000) AND ((wo.RESOLVEDTIME != 0) AND (wo.RESOLVEDTIME IS NOT NULL))) AND ((wo.RESOLVEDTIME <= 1388530799000) AND (((wo.RESOLVEDTIME != 0) AND (wo.RESOLVEDTIME IS NOT NULL)) AND (wo.RESOLVEDTIME != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1, 4, 6,  wo.CREATEDTIME

//end of query

This runs fine, but I need to modify field ct.TOTAL_CHARGE  to be an integer or string. I therefore use Query editor and make this:

SELECT sdo.NAME "Site",wo.WORKORDERID "Request ID",sdo.NAME "Site",aau.FIRST_NAME "Requester",wo.TITLE "Subject",std.STATUSNAME "Request Status",longtodate(wo.COMPLETEDTIME) "Completed Time",ct.DESCRIPTION "Time Spent Description",ct.TIMESPENT "Time Spent",REPLACE(ct.TOTAL_CHARGE, '.00', '') "Time Spent Total_Charge" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN RegionDefinition regionDef ON siteDef.REGIONID=regionDef.REGIONID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((regionDef.REGIONNAME = 'Hyresgäster') AND (((wo.RESOLVEDTIME >= 1385852400000) AND ((wo.RESOLVEDTIME != 0) AND (wo.RESOLVEDTIME IS NOT NULL))) AND ((wo.RESOLVEDTIME <= 1388530799000) AND (((wo.RESOLVEDTIME != 0) AND (wo.RESOLVEDTIME IS NOT NULL)) AND (wo.RESOLVEDTIME != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1, 4, 6,  wo.CREATEDTIME

//end of Query//

the Query works but now the field format of "st.TIME_SPENT" have changed from example "00:20:00" to "2400000" (representing 20 minutes time spent).

So, I appreciate help from you guys with modified script and/or explanation why the Query editor makes different results than running the report in the GUI.

best regards, Ragnar in Sweden