Creating a dot walk of related list

[Promita Das1]

Hi All,

I wanted to create a report which shows those records of control objective which doesn't have entity types associated with it.  The related list of entity type is blank.

I understand that direct filters are not present in the report.

So, I want to achieve via script.

My approach was, there will be a checkbox field in the control objective. So, any control objective which doesn't have any entity type associated with it then the checkbox goes false.

So, from the "checkbox" false records we can display the no. of records in the report.

But I'm not able to write a correct script for it.

Can you please help me out...

[Saurav11 · Accepted solution]

Hello,

if you want to get records which has entity type related list empty for control objective you do not have to write a script just use the below configuration in report:-

Select the marked potion as No and select the related list as entity type and it will work

Please mark my answer as correct based on Impact

[Promita Das1]

Thank You so much.

It is working as expected.

[Vaibhav Sharma1]

Hi Saurav,

I am not getting any related list conditions here, please assist how can I dot walk to a related list.

I need to dot walk of related lists twice to reach another table. Please help..