+4I’m making a custom field to display serial number in Work Task by pulling it from Equipment_Object using the Equipment_Object_API.Get_Serial_No. Though when I go to approve it it displays the below error. The two parameters I have in the expression are the corresponding ones in the JT_Task_UIV view.
Best answer by Bhagya Wickramasinghe
Hi
In the slect statement the view is specified incorrectly. It should be “equipment_object” and not “equpiment_object”.
Hope this helps!
Best Regards,
Bhagya
+11You don’t need to state the application owner against the API, but the arguments should be prefixed with the view notation. Try the following.
Equipment_Serial_API.Get_Serial_No(v.site, v.report_object_id)
+4Tried that and it still had the error. The JT_Task_CFT table doesn’t exist either in our database, as this will be the first custom field for the view.
+11Are you absolutely certain that site & report_object_id exist in the view jt_task?!
+4I checked and JT_Task did not have report_object_id, I was using jt_task_uiv. So I made this instead and it shows this error now.
+31Hi
Try removing the space in “: objkey”. It should be “:objkey”.
Hope this helps!
+4Removing the space worked, it is approved and once it runs it shows this error:
We have a JT_TASK_CFT table but no CFB in our database. Is that the issue here?
Hi
In the slect statement the view is specified incorrectly. It should be “equipment_object” and not “equpiment_object”.
Hope this helps!
Best Regards,
Bhagya
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
