servoy 3.1.5 audit log user_name shows number

Classic Servoy
1

Hi all,

I’m using servoy 3.1.5 and i’ve been using the built in audit log. However, the user name column of the audit log is showing the ID number of the user rather than the actual user name. We also use Servoy 2.2.7 and it shows the audit log as the actual user name. Is there a way to change it back to show the actual user name instead of the ID number?

Thanks,

sammy

Server Information
Servoy version 3.1.5-build 409, repository version 29
java.vm.version=1.5.0_06-b05

2

You can find an “explanation” here: Tracking now tracks userID instead of userName - Classic Servoy - Servoy Community

I really dislike this change in functionality. Hopefully somebody takes another look into the “concept” of this if you complain, too…

3

In the meantime (if you display your logs inside the Servoy solution as I do) you can build a valuelist with UUIDs as return values and usernames as display values.

4

I still dislike it if my functionality breaks simply by updating. But yes, thanks, that is a workaround…

5

Thanks for the reply Patrick and ngervasi. You guys are right, we use the audit trail extensively and see that “change” isn’t good. Extra work to program in a workaround.

thanks for the info tho.
Sammy

6

patrick:
I still dislike it if my functionality breaks simply by updating.

At Servoy we do everything we can preventing to break any thing, but improving/adding functionality (like LDAP Support) sometimes means changing existing behavior.

As I explained on another forum post we decided the fill the username in the log table with the user_uid (in case of LDAP this is the only solution this makes sense), and the new user_uid can be filled by you, via the security object in scripting.
By default we filled the user_uid with the user_id instead of the username (since UID implies more a number than a name)
You are free to fill you user_uid field for all users, using the username, which results in the username in the log table being filled with the same values as before the change.

7

Hello Jan,

my problem is that I am using the user_uid column. Why don’t you simply add a column user_uid to the log table and we are all happy?

Thanks
Patrick

8

well many systems do already have a log table with the user_name column, but we could check to see if the user_name or user_uid is present.

9

Will be so in Servoy 3.5 rc2

10

Couldn’t you simply say: if you want the user_uid, please provide a column called “user_uid”, if you want the name, provide a column “user_name” and if you have both, great too? If I create the log table through Servoy, it will create and fill both.

11

No, since we don’t necessarily have the user name (in case of LDAP), Servoy 3.5 rc2 and later will create a column user_uid in a new log table
Or if only a username columns exists in existing log table it will fill the user_name column with the user_uid ( which in turn could contain the username)