List Collector Not Showing Fields from Extended Tables in Record Producer

TEJAS
Tera Contributor

Hi All,

I am working on a Record Producer with the following variables:
I am not using global scope , i am using another scope

  1. Master Table (Variable Name: master_table)

    • Type: Reference

    • Table: sys_db_object

  2. Select Fields (Variable Name: select_fields)

    • Type: List Collector

    • List Table: sys_dictionary (under type specification)

    • Reference Qualifier:

      javascript:'name='+current.variables.master_table.name;
       
      Below are some screen shot where you can understand 

      TEJAS_0-1742895381994.png

       

      selected master table is : incident

      TEJAS_1-1742895447734.png

      under selected fields i can only see 36 field name which belong to incident but i am not able get the extended table field in incident 



1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

You can modify your Reference qualifier on the List Collector variable like this to include fields from the table the master table is extended from:

javascript:'name='+current.variables.master_table.name+'^ORname='+current.variables.master_table.super_class.name;

 

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@TEJAS  

that's OOB behavior.

please use what @Brad Bowman has shared to include extended fields

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader