Hey @lexveldkamp
This is a known limitation when drilling down from a CMDB Query Builder-based Pivot Table.
The drill-down list is generated from the underlying table records, not from the report's aggregated dataset. As a result, dot-walked fields used in the report are typically not available as columns in the resulting list view because they do not exist as native fields on the base table.
Possible approaches:
Verify whether the dot-walked field exists directly on the target table. If not, it cannot be added to the list layout.
Create a Database View that joins the required tables and exposes the value as a direct field, then build the report from that view.
Store the value on the target record using a Business Rule, Flow Designer, or scheduled job if it needs to be available in list views frequently.
Review the drill-down configuration and release-specific documentation, as CMDB Query Builder report drill-down functionality has some limitations compared to standard table-based reports.
Could you provide:
- The exact dot-walked field being used?
- The table displayed in the drill-down list?
- Your ServiceNow release (Washington DC, Xanadu, Yokohama, etc.)?
That information would help determine whether there is a supported workaround for your specific scenario.
**************************************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.
Regards
Vaishali Singh
Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb
