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!

[David Santel]

I need to report on the sc_req_item table.....Requsted for, Assignment group, Item.

Also I need in same report fields from Incident table - Table Type = Service Request and The categories/sub categories. 

How would i set this report up?

I am very new to reporting.....Please help!!!!!!!!!!!!!!!

[Jaspal Singh]

Hi David,

Do you have a field or something that relates Incident record to Request?  As database view to function there needs to be something common between the tables.

For RITM & Incident do you have a field that is common between them? Something, like we have for every Catalog Task (Request Item) field that stores the RITM no.

[David Santel]

I do not. ☹ I think im stuck? Any ideas?

[Jaspal Singh]

In that case do something as below.

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

2. Once done in the database view that you have created above

For incident entry make sure you pass Variable prefix as inciis

For sc_req_item entry make sure you pass Variable prefix as ritmis & Where clause only for this entry as ritmis.sys_class_name=inciis.u_ticket_type

3. Save the form & click on Try It

Hit Helpful or Correct on the impact of response.

[David Santel]

What did i do wrong?