In the Reports module, why is the Task[task] table now showing 300+ extra fields in the Available fields selection list displayed in Red text.

[paula_sylvester]

In the Report's module, when creating a report on the Task[task] table, in the Available fields selection List following the fields that exist on the Task table are additional fields in "Red" available for selection on the report.     There are over 300 of these fields viewable in the Field selection list.   I noticed this "feature" following an Implementation Partner's install of a single module.   I have not found a filter condition that result in data in the fields.   Knowing the module that was implemented I concentrated my review on fields that appear to support the new module but results were the same. No data in these fields however, because of the number of fields is question I have not tested them all.   I suspect that because they are "Red" that they are fields in Tables that are not extended from the Task table but are Referenced from the Task table.   Since they do not appear to have a purpose, in an effort to try to keep the Reporting module uncluttered and easy for an ITIL user to use I would like to remove them from the Available selection list.   Does anyone know why they are there and how I can get rid of them?

[Pradeep Sharma]

Hi Paula,

Can you please share the screenshots. The one with the green for ex Assigned to[+] is the reference field table. I don't think you can get rid of this from the list on the report module.

[paula_sylvester]

Snap Shots of examples:

[Uncle Rob]

Hey Paula,

Does it look like this?

If so, that's actually a really powerful feature.   It allows you to report on child table fields from a parent table.   The first part is the name, and the square brackets contain the child table name.   There's tons of use cases for this in task management and configuration management.

Say you want to list all Tasks, but whenever a task is a Change, you also want to list its Risk rating.   In that case you'd build a task list and add the maroon Risk [Change Request] field.   It will be blank for all tasks that are not changes.

[paula_sylvester]

That would be what I am seeing.   We do not have all modules turned on but i will test with reporting on Incidents to see if I can better understand how to use these.       However 300+ extra fields are extreme clutter if they do not support active modules or our configuration...........   can I turn them off until they are better understood and I can then create a knowledge article explaining to ITIL users how to use them?