Skip to main content

Hi,

I am not getting any data when I am running this query in IFS DB:


SELECT *
   FROM JT_TASK_LIGHT_UIV
   WHERE Srv_Req_ID = '607';

But I am getting the data when I am using the same query in quick Reports in IFS CLOUD.


Any idea what could be the issue?

Thanks in advance.

 

What user are you using? You should give your user correct site and company access.


To get the data from JT_TASK_LIGHT_UIV user needs be in User per Site of the site for work task