How to get extended fields in reports column

Sharique Azim
Mega Sage

Hi ,

<this is a repeat question as previously i could not find any relevant   help with How to get embedded list/relationship in reports column >

I can see a report on task that shows relationship/ embedded list in the available field columns.

find_real_file.png

Please find the screenshot attached. Normally these fields in red   font   do not appear   in the available list.

I want to bring the same for sub-production instances,which not shown by default.

1 ACCEPTED SOLUTION

Uncle Rob
Kilo Patron

Hey Sharique,



Red fields in report interfaces like that means you can leverage fields from child tables.   Thus if you're reporting from Task, you could still grab fields from Change, Project, Incident, etc.



The system property that controls this is called glide.ui.list.allow_extended_fields


On Jakarta, you can find it under UI Properties as "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."



find_real_file.png


View solution in original post

3 REPLIES 3

Uncle Rob
Kilo Patron

Hey Sharique,



Red fields in report interfaces like that means you can leverage fields from child tables.   Thus if you're reporting from Task, you could still grab fields from Change, Project, Incident, etc.



The system property that controls this is called glide.ui.list.allow_extended_fields


On Jakarta, you can find it under UI Properties as "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."



find_real_file.png


Before marking this correct, may i please know if there are any side-effects(if any) on the system?


Performance wise?   Extremely improbable.
The *only* time I've seen reporting slowness in 10 years is when a combination of hte following happen:
- Ludicrously sized table


- Ludicrously large result set


- Queries using "contains" / "does not contain" especially when combined with the volume mentioned above and


- Lots of OR statements.