Reference to a database view

[gabriel_sk]

Hello team,

I have created a new table where to host a quality review of the incidents created.
Now in the new table's form, I would like to have fields that are referring to a database view I have created (incidents + assessments), is that possible?

Seems it is not possible to create a new column and reference it to the database view (and then using dot walking to add other fields).

Thank you so much:)

[surendarm]

Hi Gabriel,

In my developer instance i could see that i can create a new column referring to an OOTB database view. I reckon it should work for the custom database views as well.

Please find the below screenshot

[gabriel_sk]

Hey Surendar,

Thank you so much for the prompt reply. Yes you are right I could reference from there to the Database view but once I have added the needed fields and saved, they actually don't appear in the form   possible I miss something... I am new with Service now

Any suggestion is appreciated.

Thanks a lot:)

[surendarm]

Hi Gabriel,

Can you provide a screenshot of what you have configured as part of form layout, so that i can let you know if at all you missed something?

Thanks,

Surendar M

[amlanpal]

Hi Gabriel,

As much as I know, this is not possible. As database view is not real time table, you can not refer any field to Database View. This is the same reason because of which you can not join one database view with any other table (say Incident).

I'm also keen to know if any expert provides any helpful insight.

I hope this helps. Please mark correct/helpful based on impact