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