The Creator column can only be filtered by username

[ane-gabriela]

Preconditions: Have at least 3-4 calendars created. with different users that have/don't have First and Last name.

1. Click on Calendar from Applications
2. Scroll down to the "Overview of all calendars" section
3. Filter the calendars by Creator
   

Expected results: The filter works properly.

Actual results: The filter works only when using the username. The filter doesn't work by First or Last name.

Environment: Windows 11, XWiki 14.10.10 with MySQL 8.0, Chrome 114, Calendar Application (Pro) 2.13

[lucaa]

@ane-gabriela do you have any information about whether this is a regression (for XWiki 14.10.10 or Calendar app 2.1.3 ) or it has been like this for a while already?

[ane-gabriela]

It appears to be an old issue - Tested with Calendar 2.12 and XWiki 14.10.5 and the issue reproduces

[snazare]

The issue is caused by the livetable feature, not the extension. The livetable is sorting based on the database property, not the display name.

[lucaa]

The issue is caused by the livetable feature, not the extension. The livetable is sorting based on the database property, not the display name.

Indeed, the sorting is based on the username but for filtering, in the standard livetable there is a picker to pick a user based on first name + last name and then filter by this user.