How to create a new column in Database view for report?

[alvatindra]

HI,

I have created a database view on a table, I need to create a new column in database view without creating in the main table, So that I can use the newly created column in the report which is on database view table.

How this can be achieved?

[Chetan Sondhi]

Hi Alvatindra,

Database view is a view that joins the tables for reporting purpose but itself is not a table .

So In order to achieve this , new column must be created in a table only.

PS - Please mark Helpful, Like, or Correct Answer if applicable.

Thanks,

Chetan

[alvatindra]

Hi Chetan,

Thanks for the response,

Is there any option to create a new column in excel during report exporting? Where the report is on database view.

[Chetan Sondhi]

Hi Alvatindra,

Unfortunately we are out of luck here !

Creating column on a new table other than your main table and then include the same in database view is something that we can do for this for now.

PS - Please mark Helpful, Like, or Correct Answer if applicable.

-- Chetan

[tony_barratt]

Hi Alvatindra,

Do you perhaps need to create a db view from 2 tables rather than the one you mention?

Use a database view

..

Database views allow you to combine data from tables in your ServiceNow instance that are not connected by default.

About this task

By combining these tables in a database view, you can easily access them by calling up the view, and then select fields from any of the tables included in the view. For example, if you want to report on the number of SLAs breached, you need fields from both the SLA and the Incident tables.

Could you attach a screenshot to show your current db view?

Best Regards

Tony