Database view on scoped app table issue

[Plamen Nakov]

I am trying to create a database view on one global scope table and one scoped application table, but I can't get it working... First of all is this possible at all?

Since I wasn't able to make it work, I have tried to see what will be the output of this database view on single table. If database view is on the global scope app table,in my case cmdb_ci_appl, everything is OK, all records shown as expected, however if database view is on the scoped app table only - following error message is shown when I try the view:

Syntax Error or Access Rule Violation detected by database (Unknown column 'relx_****_itaas2_base_relationship.sys_mod_count' in 'field list')

The table that is mentioned in the error message is the base table, not the one I am using the database view.

Also I don't have where clause or anything trying to access sys_mod_count or any other field.

Any ideas?

Thanks in advance.

[gauravchoudhury]

Hi Plamen,

You can supposedly resolve this by finding a column titled 'Tags' in the table. By removing it as a displayed column, the data should return to view and the error shall disappear.

[Plamen Nakov]

Hi Gaurav,

I don't have "Tags" column in the scoped table, also none of the columns has Display = true

[gauravchoudhury]

Did you also double-check on the Personalization of your List columns?

[Plamen Nakov]

Yes. I have tried showing only one column on the list, which is neither Tags or sys_mod_count.. Still getting that error message.

In the Personalise List Columns I can see in the Available slush-bucket a field "sys_tags" which is not column in the table though...