Question on Dot walking to Child Class fields in list filters

RW-43 · ‎10-05-2022

Hey Team

Looking for some info on when the ability to dot walk to child tables via the filter builder was added.

For example, these tables available off the Task table:

It's something that our team discovered just recently and are looking for some documentation on it.

Any assistance is appreciated. Thanks!

Tony Chatfield1 · ‎10-05-2022

Hi, not sure exactly when the functionality was released, but I can find a reference to the use of 'ref_' syntax in 2016 edition of Mastering ServcieNow.

I believe that this is controlled by the system property 'glide.ui.list.allow_extended_fields'
Usage is simply expand the related(child table) + in your filter view and you will be able to select (child)table specific fields for your filter, the resulting query syntax is ref_tablename.fieldname
Covered in this reporting video from about 2:55

//docs.servicenow.com/pt-BR/bundle/quebec-now-intelligence/page/use/reporting/task/t_AccessFieldExtendedTable.html

View solution in original post

Tony Chatfield1 · ‎10-05-2022

Hi, not sure exactly when the functionality was released, but I can find a reference to the use of 'ref_' syntax in 2016 edition of Mastering ServcieNow.

I believe that this is controlled by the system property 'glide.ui.list.allow_extended_fields'
Usage is simply expand the related(child table) + in your filter view and you will be able to select (child)table specific fields for your filter, the resulting query syntax is ref_tablename.fieldname
Covered in this reporting video from about 2:55

//docs.servicenow.com/pt-BR/bundle/quebec-now-intelligence/page/use/reporting/task/t_AccessFieldExtendedTable.html

RW-43 · ‎10-06-2022

Thanks Tony, this is great