Fields missing from database view report

[Sharique Azim]

Hi All,

I see some fields are missing in the report/ list view of database view made on sys_journal table.

In the below picture (admin view) i can see the fields elements ,element id and Value

But for non admin the fields are missing..

Please suggest.

Regards,

Shariq

[SanjivMeher]

Hi Sharique,

You need to add those field to your database view to display in reports.

Open the Database View, and the underlying table views. There you can add additional field to their corresponding tables.

[Sharique Azim]

Hi Sanjiv,

The fields are already added, as you can see the fields are available for me to see.

Regards,

Shariq

[SanjivMeher]

Did you also create the acl for this table?

You will need ACLs on Database views as well. Bydefault they are only visible to admins.

[Sharique Azim]

Hi Sanjiv,

There are no rules on the fields of value, element or element ID of sys_journal table. And as you can see other fields are available, so ACL on table i think isnt causing the issue.

Regards,

Shariq