Jump to content

Created / logged by "username"


Recommended Posts

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. )

image.png.c62f599f954c0e8abb53d60d250e0c3f.png

Link to comment
Share on other sites

"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.

 

Link to comment
Share on other sites

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. :(

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 :( 

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...