How to show a Document ID field in a report

[suvro]

Hi,

We want to report on on_call_escalation_comm table to know how many times call was attempted and for which incident. But in this case Incident sys_id is stored in a document ID field.

If we use escaltion field it gives sys_id and if we use Source field of escalation it shows empty in the report.

Please let me know how can we show the incident number in the report

[Ankur Bawiskar]

@suvro 

did you try joining both the tables using Database view and then show the number from the other table?

create report on that database view table

Database view - How to correctly join a table using a document_id field 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi @suvro 

Create a Database View joining on_call_escalation_comm with incident to directly pull incident fields.

View Name: u_incident_oncall_escalation

Table 1 (Incident):

• Table: incident
• Prefix: inc
• Order: 100

 Table 2 (On-Call Escalation):

• Table: on_call_escalation_comm
• Prefix: oncall
• Order: 200
• Left Join: Checked
• Where clause: oncall_incident = inc_sys_id