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! 🙏