List Collector Not Showing Fields from Extended Tables in Record Producer

[TEJAS]

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 

     
     

     selected master table is : incident
     
     

     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 
     
     
     

     
     

[SupriyaWaghmode]

@TEJAS  

The above mentioned "Reference Qualifier:" select the "Incident" table in query. If you are looking for extended values please include extended table name ["task "] in the query. 

--

Thanks & Regards ,

Supriya Waghmode |ServiceNow Consultant

www.linkedin.com/in/supriya-waghmode

[TEJAS]

@SupriyaWaghmode 
Can you give with an example please

[Brad Bowman · Accepted solution]

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;

[TEJAS]

Thank you so much @Brad Bowman