Record Notes: Creator/Editor Columns not the note creator/editor

[Jennifer Pringle]

Evergreen 3.9
(tested with concerto and production data)

In the Record Notes tab in a bibliographic record there are Creator and Editor columns that can display.

The value of these columns is always "1" or the username of the account that has an id of "1".

When logged in with a non-global account the Creator and Editor columns always show a value of "1"
When logged in with a global account it the Creator and Editor shows the username of the account with an id of "1"

The Creator field should show the username of the account that created the record note.

The Editor field is currently irrelevant as it's not possible to edit a record note. This field should be removed if editing record notes is not functionality that is wanted long term. Otherwise it should have a null value until it is possible to edit a record note.

These columns shouldn't be used to display the bibliographic record creator/editor as that information is already available on the screen in the Record Summary.

[Britta Dorsey (bdorsey-isl)]

As of 3.9.1, the creator/editor columns only show and link to a consortium-level globaladmin account. It does not show the actual staff username that created/edited the note.

Bug submitted: https://bugs.launchpad.net/evergreen/+bug/2007385

[Tiffany Little (tslittle)]

Marked Britta's subsequent bug report as a dupe because they're the same root issue--admin is being stored as the creator/editor rather than the real creator/editor. It's being shown in both the columns (as Jennifer says) and also in the summary display (as Britta noted).

[Jason Boyer (jboyer)]

So... after looking into this a bit it's because the creator and editor fields are apparently never set and the biblio.record_note table defaults both of them to 1. So the data is being read and displayed correctly, but not saved correctly. This will also likely make it impossible to use user notes if user 1 does not exist.

[Susan Morrison (smorrison425)]

Confirming this is occurring in 3.12 as well.

[Beth Willis (willis-a)]

I don't see any way to edit a record note and have submitted a bug report about this: https://bugs.launchpad.net/evergreen/+bug/2047050

[Terran McCanna (tmccanna)]

For extra weirdness, if I log in as the main admin account, the Creator and Editor show as "admin" but if I log in with any other user they show as "1".

Ideally, they should show the user name rather than the ID.