Created / logged by "username"

[Smurfy]

Hi

Is it possible to have a column that's added for access in the reporting that has the logged analysts username rather than ID?

So a bit like "resolved by username" I would like a "logged by username" or "created b username" At the moment all I can find is a "created by" which (maybe how we are set up) is just the analysts employee number. 
I note that Close by, resolve by and re-opened by all have a "username" option in the reporting.

Is this possible?

(It would be good to be able to add it into columns in the request lists too. )

[Steve Giller]

"in the reporting" is somewhat ambiguous, but if you are building a report then you can just join the h_sys_accounts table and match on the UserID, then you can take the Name/Handle etc. from there.

 

[Smurfy]

I would like to be able to see it in the request lists too?

I can see closed by and updated by and resolved by as names. But created by is a number.

[Steve Giller]

51 minutes ago, Smurfy said:

I would like to be able to see it in the request lists too?

The Request List View shows data from the Requests table. 

 

55 minutes ago, Smurfy said:

But created by is a number

Technically h_created_by is a UserId - it'll show as a number in your Instance as that's how you have it set up.
If you have a pressing need to see the Username of the person who created the Request you can look that up in your Business Processes, add it to a Custom Field, and display that field in a View that you create - however you would need to be consistent across all your Processes for that to work reliably.

[Smurfy]

Thanks Steve
That is a workaround.

Its a shame that there isn't consistency in the table.

Resolved, closed and updated by all show the name. Created by is the only one which doesn't