The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Database VIEW showing only the count of records not the data

swapnil_singh
Tera Contributor

Hello All,

I have created a Database VIEW which is just showing the count of records not the data present .

I am applying DB view on 2 custom tables in which both of them have CI name as common key , attached the snippet of issue as well as db created .

It would be great if somebody can help me on this.

Thanks in advance

Swapnil

1 REPLY 1

Mani41
Mega Guru

Hi Swapnil,

 

Do you have ACLs on your 2 custom tables ? I think you need the right to READ on your custom table to see data on database view.

Kind regard,

Mani