ITSM Report Builder Reference Attributes

[Raymond Tapper]

Is it possible to add columns to the results in the report builder? I would imagine mine is not not the only organization having multiple people with the same names.

I went as far as getting a PDI and adding ",ref_ac_columns=first_name;last_name;user_name" to all reference fields matching this query: 

internal_type=reference^attributesNOT LIKEref_ac_columns=first_name^active=true

That still didn't do anything. I imagine this is in a widget or page config.

[AndersBGS]

Hi @Raymond Tapper  ,

 can you please clarify your question a bit? You are both talking about the native report builder and a reference qualifier. What if you business requirement?

[Raymond Tapper]

Hello.
Yes, the report builder is what I was talking about, but not a reference qualifier.

I was hoping to add additional information similar to what you would see on a reference field. This is an example from the Caller column on the Incident table in my instance:

ref_ac_columns=first_name;last_name;user_name

I am hoping to allow my users to see more information when they are building reports. In my screenshot, what I was hoping to add would be user_name. That way, when they search a name it would Show the user's name and user_name.

Hopefully that answers your question.

- Ray

[Dr Atul G- LNG · Accepted solution]

Hi @Raymond Tapper  

No, this won't work in the report builder. In the report builder, you can only view it as it currently appears.

[AndersBGS]

Hi @Raymond Tapper  ,

Agree with @Dr Atul G- LNG  - this is not possible in the report builder.