Report on a table containing Document ID field

[ramandeepgarg6]

Hi Friends,

I need to create a report on a table. This table contains a Document ID field named "Profile". I need to dot walk('+") to this "Profile" and add few fields from there to my report. While creating report I could not find "+" option with "profile" field. Now could you please tell what is the solution to create such report? Is there any other option available to create such report?

Regards

Ramandeep

[Chuck Tomasi]

Document ID fields do not allow dot-walking. They are similar to reference fields, but also include information about the table which makes them table agnostic and does not allow dot-walking - unlike reference fields which always point to the same table.

Is there a possibility of changing your document_id field to a type reference?

[ramandeepgarg6]

Hi Chuck,

Thanks for the reply! This is "Applies to" field from "Profile" table and is part of GRC (Governance Risk and Compliance). This is OOB field and cant be changed to normal reference field.

Is there any possible solution though the difficult one?

Regards

Ramandeep

[Chuck Tomasi]

You could try the trick used on the sysapproval_approver table. Copy the value of the document_id field in to a different reference field where you know what table that reference field points to. The value is the same for document_id and reference fields.

[ramandeepgarg6]

Hi chuck,

This is not the complete solution. Document ID field taking data from multiple tables. So if we create a new reference field then we can use only one table and it will not always be populated.

Regards

Ramandeep