Skip to Content
0
May 08, 2018 at 06:24 AM

FMS query for adding extra hours to service call creation time through user defined field

90 Views

Hi,

I have tried to add the extra hours to the service call creation time.when I used hard code value it works

Ex.select $[OSCL.createTime] + 200 it give me proper result.

But my hours value changes as per the service subject and its technician. so that I created user defined field with numeric datatype for hours and the service type field with char type. and tried the following queries but it doesn't give me result

1)select $[T0.createTime.number ] + $[T1.U_ServTime.number ] from OSCL T0 left join OHEM T1 on T0.technician=T1.empID where T1.U_ServType=$[T0.subject] ....it gives me error

2)select T0.createTime+ T1.U_ServTime from OSCL T0 left join OHEM T1 on T0.technician=T1.empID where T1.U_ServType=T0.subject....it gives me wrong output

I want the addition of current selected time and user defined hours to another user defined field..

Anyone can help me

Thank you.

Regards,

Sapna