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

[shubh1992]

Hi Raman ,

Please create your own reference field that will refer to the same table to which document id is referring . You can hide this field from the form but can use it fro values of profiles that will resolve your issue.

PLZ mark this correct if it resolved your issue or feel free to ask if u still have any queries.

Regards,

Shubh

[Chuck Tomasi]

Hi Ramandeep,

Thank you for the update. If the document_id is pointing to different tables (which is exactly what they do), then dot-walking is not possible (as noted before.) It's not something you can workaround due to the nature of document ID fields.

[ramandeepgarg6]

Thank you Chuck,
I hopethis is something taken care by ServiceNow for future release.

Regards

Ramandeep

[Chuck Tomasi]

I invite you to open an enhancement request! Our product managers DO listen.

Enhancement requests: Tell us how you would improve the ServiceNow product

[sabell2012]

Actually, you can dot walk a few values with a document id field:

For example with the Metric Instance table:

metric.id.sys_id
metric.id.sys_class_name
metric.id.getTableName()

So base table stuff.  It will not always give you the values you were thinking it would because it appears to be an in-memory table record construct that is used to tie two tables together (like the m2m/mtom tables) without the physical table being present.

If a real table was present you should be able to do something like this to actually dump the fields available:

for (var property in metric.id) {
     gs.info('---> ' + property);
}

But that does not work, and it does not even give back what you know is there.

It has the feel of just-in-time.

Steven.