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

[former_member520086]

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

[Johan_H]

Hi,

Please try this fms query:

select $[OSCL.createTime] + ISNULL(T1.U_ServTime, 0)
from OHEM T1 
where T1.empID = $[OSCL.technician]
  and ISNULL(T1.U_ServType, 'XXXXXX') = ISNULL($[OSCL.subject], '')

Regards,

Johan