Database view - Incident and sc_req_item

[David Santel]

We have setup an choice field on incident form. Choice field= Ticket Type:  Incident or Request Type.

On incident form we have Category EOL , subcategory - laptop replacement. 

On sc_req_item we have EOL item.

I need to merge the 2 reports to understand total EOL upgrades for x time. 

 Is this possible? If so how would the database view be configured?

Thanks!

[Jaspal Singh]

For the field Ticket type did you get below configured? As highlighted in my comments before?

1. For the Ticket type field (selectbox) that you have on incident form with selection as Incident or Request

pass value for Request as sc_req_item  while the label will be Request

& pass value for Incident as incident while the label to be Incident

[Community Alums · Accepted solution]

Hi David,

Could you please created database view as I created below. It's working for me.

In the Incident and Requested Item tables, we have common thing is parent table i.e. Task. So I have configured as below.

Kindly let me know if it is helpful for you.

[David Santel]

The database view works! I can see all fields from INC and Sc_REQ_item

How would i generate report to show all 

items= Laptop replacement program

Ticket Type = Service Request

Can you show me sample to get started..

[David Santel]

Also thank you for all your help. I really appreciate it. 

David

[Jaspal Singh]

Hi David,

All you need is to apply filter in the report.

Apply below filter to existing filter that is currently on report.

Item | is | Laptop Replacement

Ticket Type | is | Service Request