What does each color mean in reporting

[Nik Amy]

Hi Guys,

What does brown color indicate while dot walking-

On CI rel table, I do a dot walk like:

Parent.business service.environment (when I do this on left side , nothing comes in brown), same if I do on right side then it comes in brown and not all the fields appear on right side which showed up on left side.

[Chuck Tomasi]

Green is shown in the slushbucket field chooser to represent reference fields. When you click one, you get a third option (usually a "+" or tree icon in the middle above < and >) to indicate you can drill in to those and pick fields within that reference. E.g. drilling in to assigned_to will show you user fields like name, phone, country, etc.

The same thing is represented by the blue in the field chooser (we'll have to get these teams together at some point.) 🙂

Brown is information from related lists - records that are related to the one you are looking at - e.g. CIs that belong to a change request. Any table that has a reference field that points to this table is automatically applied here.

[Josh Cooper]

I never knew that.  I just assumed it was from extended tables - i.e. if you're reporting on cmdb_ci, you'll see the fields from cmdb_ci, but any of the classes extended from it would show up in the red/brown at the bottom.  It may amount to the same thing, though.