Dotwalk from task table to child table fields ex. (change_request)

[Tadz]

Hi Everyone,

Is it possible to dotwalk from task table to change_request table.

Example:

I have a field called Parent Record which is referenced to task table so that i can select a record from Incident, Problem, Change and etc.

Problem is, when i try to do a filter on a change record. The fields from change record is not available in the list.

I believe you can only dotwalk from child to parent. 

Is there a way to make that possible? 

Thanks,

Tadz

[Tadz]

Hi Ankur,

This works like a charm.

Question though, does this have performance implications enabling this property?

Thanks,

Tadz

[Ankur Bawiskar]

Hi,

That I am not quite sure whether it would impact or not because it is global property

Regards
Ankur

[DirkRedeker]

Hi

Once, I had the same issue, and the only (maybe poor) solution I found was, to add a custom field to the table having a reference to the child table. with a business rule I synced the reference.

Then, I was able to filter by the dot-walked fields.

Let me know, if that worked for you as well.

BR

Dirk

[Tadz]

Hi Dirk,

Thanks for your response.

Angkur's response on enabling a properties works well for me.

[Anurag Tripathi]

Hi,

You can dot walk from task table to its child tables like below:

taskField.ref_change_request.<change field name>=<value>

On the UI it looks like this

To achieve this, the following property on your system should be true

glide.ui.list.allow_extended_fields

Read more here

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/ta...

-Anurag