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.

[kopp820]

Hi plamennkv Do you still   have this question? Sometimes the order column of the database view tables can produce that error message. Try playing around with different orders to see if you get a different result.

[Plamen Nakov]

Thanks for your reply. However in my case I am seeing this error message even when there is only one table in the database view, so the order doesn't do anything in this case.

[Monse Rj]

Do any one have solution for this issue.Actually I want to create a database view for 2 tables one on global scope and one in application scope?