Database view on extended tables

[sowmyaj]

Hi All,

                            I have a requirement to create database view on two tables. In which one table is extended from some other table and the other is not. I also read "Rotated and extended tables cannot be included in a database view. Also, an existing database view cannot be a component of another database view".

So need to know any other way to combine the tables and write a query on it. Also, need to know other possibilities of joins like union, intersection etc. except left join.

Thanks,

Sowmya

[sowmyaj]

Hi Kalaiarasan,

                            I have configured the fields to get displayed in the result by personalizing the list.

                            I tried with changing the orders too but still not getting the result.

                            In table cmn_skill field name is of type "String" and in table sys_user_has_skill   field skill is of type "Reference".   Is this the problem?

Thanks,

Sowmya

[Kalaiarasan Pus]

Reference expect's a sys id. So that is definitely a problem.. Not sure if dot walking of reference field will work in view.. Try that once.. If not, you might need to add the third table to map Reference>Reference table > second table.

[sowmyaj]

Hi Kalaiarasan,

                  Thanks you, dot walking is not working. Is there any other way to do it instead of creating a third table.   Any other facilities available in Service Now to create and query a tables other than views?

Thanks,

Sowmya

[Kalaiarasan Pus]

Not that I know off.