The CreatorCon Call for Content is officially open! Get started here.

How can I show a field from a related table from an extended table in a list

Jay Gamblin
Mega Sage

So I have a list for rm_feature

Extended from that we have rm_defect

We added a reference to rm_story on the rm_defect table.   So its rm_defect.u_story.

Now I want to show rm_defect.u_story.product as a column in the rm_feature list.   It is possible?

7 REPLIES 7

faro
Tera Expert

Sounds to me like dot-walking would be your solution here.


nitin_kumar
Mega Guru

Hi Jay,



It is possible.


Screen Shot 2017-09-26 at 2.41.51 pm.png



Select the reference field and click the tree button which reads 'Expand selected reference field' and you can select the fields from the referenced table.



Thanks,


Nitin.



Hit Like, Helpful or Correct based in the impact of the response


I can do this from the Defects (rm_defect) list but I cannot do this from the Features (rm_feature) list.



product.png


defects list.png


features list.png



From the Features list, the defect record is in an extended table, so then how would I dot walk to the extended table record's related record and display a specific column?


Hi Jay,



If you want to show the extended table fields in list view follow the below steps
1. Navigate to System Properties > UI Properties


2. Locate the property Allow base table lists (task, cmdb_ci, etc.) to include extended table fields (incident_state, os_version, etc.), and allow filtering on extended table fields (glide.ui.list.allow_extended_fields).


3. Select the checkbox to enable the property and you will be able to see the extended table fields in list view of the child tables.



Thanks,


Nitin.



Hit Like, Helpful or Correct based in the impact of the response