Database view is not showing up data

[Majji Koteswar1]

Hi Team,

Requirement: Display the state changes of Control records in a report, including both the old and new values for each change.

I created a database view with the following configuration. While the data displays in my Personal Developer Instance (PDI), it fails to appear in the corresponding table within my client's instance.

Could you please provide recommendations on how to retrieve the data?

Thanks,

Majji

[Ankur Bawiskar]

@Majji Koteswar1 

what's the error you are getting in client instance when you click "Try It" ?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Majji Koteswar1]

Hi @Ankur Bawiskar

Thanks for the response. I didn't see any error. Just no data is retrieved even the data is present in both tables.

[Ankur Bawiskar]

@Majji Koteswar1 

any table level READ ACL on compliance table is blocking?

any query business rule is blocking the data?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @Majji Koteswar1 

Are you sure that sys_id and docmentkey is common between these 2 tables, try to reverse the order.