- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2017 04:38 AM
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.
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.
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2017 05:17 AM
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."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2017 05:17 AM
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."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2017 05:50 AM
Before marking this correct, may i please know if there are any side-effects(if any) on the system?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2017 01:34 PM
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.