Dotwalk fields using custom relationships

[G Balaji]

Hello,

Is there anyways to dot-walk in a report and filter based on the custom relationship created?

Background is as follows,

I've a custom workflow running on a custom table which will insert records in Profile table of GRC application. "Applies to", which couldn't be dot-walked in report refers to a record in custom table. We want to run a report on profile table with filters and columns from custom-table based on "Applies to" field.

I understand to dot-walk parent-child relationship is required. However, our community could share if some of us have implemented this using custom relationship(as in related list).

Thanks.

[Ravikant3]

I would prefer creating an m2m table which captures relationship between Custom table and Profile table.

To create a ServiceNow M2M relationship, use the sys_m2m table.

In relationship table you can create relationship with any reference field to get related data associated with particular filed. 

[Ankur Sharma]

Hi G Balaji,

Have a look at these documents:

Dot-walking examples

Reporting on extended table fields using dot-walking

Also, ensure you have selected the 'Show Related Fields' (last option) in the filter drop down.

Let me know if it helps.

[Prriyanka]

Hi balaji,

Is this resolved ? I am also facing the same issue unable to dot walk on applies to record field.
If you have resolved this please let me know