We came across a similar issue one of our clients. To correctly generate PM work orders with dates in the right timezone you must do two things. Set the time zone for the asset/location/site/org. No need to set for all the object though. In our case we defined the timezone only at org/site level...
Marvin, Something like this should work: select count(1) from workorder where workorder.jpnum in ('INVEST-LEAK-D','RSPND-GO-D') and exists(select 1 from workorderspec where workorder.wonum = workorderspec.wonum and workorder.siteid = workorderspec.siteid and workorder.classstructureid =...
Hi Everyone, A pleasure being here, I was hoping someone could lend me a hand with the following query, I'm trying to display a number using a KPI through in a startcenter, it deals with "Leak Investigations with no follow up WO's" - I really appreciate your feedback and thank you for such an...
Hi, For some reason I am having trouble responding. The report is in the User application > Login History report. Other reports export fine. Stevie
Hi Steve Looks like pdf is getting corrupted during export. Are you getting this error with exporting all reports or only with the specific report? Also do you have longdescription.ldtext field being used in this report by any chance? If yes can you try removing ldtext field. If rich text is...
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use