Question

Not getting data from views in IFS cloud

+4

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.

+10

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

+1

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

Sign up