Description Carlos García-Mauriño 2022-05-26 15:59:07 CEST

Kelvin GET endpoint `/useres/` allows to search users filtering by their attributes. While filtering by other attributes work, filtering by `expiration_date` does not find users with the searched value.

This happens at least in versions 1.5.1, 1.5.2 and 1.5.5. Tested uding docker.software-univention.de/ucsschool-kelvin-rest-api:1.4.3 and docker.software-univention.de/ucs-master-amd64-joined-ucsschool-udm-rest-api-only:stable-4.4-8.

To replicate create the following user:

```
{
    "dn": "uid=kimcorey,cn=lehrer,cn=users,ou=DEMOSCHOOL,dc=ucs-test,dc=intranet",
    "url": "https://<fqdn>/ucsschool/kelvin/v1/users/kimcorey",
    "ucsschool_roles": [
      "teacher:school:DEMOSCHOOL"
    ],
    "udm_properties": {
      "title": null
    },
    "name": "kimcorey",
    "school": "https://<fqdn>/ucsschool/kelvin/v1/schools/DEMOSCHOOL",
    "firstname": "HoJohnson",
    "lastname": "Ho",
    "birthday": "2010-02-24",
    "disabled": false,
    "email": null,
    "expiration_date": "2030-03-10",
    "record_uid": "kimcorey",
    "roles": [
      "https://<fqdn>/ucsschool/kelvin/v1/roles/teacher"
    ],
    "schools": [
      "https://<fqdn>/ucsschool/kelvin/v1/schools/DEMOSCHOOL"
    ],
    "school_classes": {},
    "source_uid": "TESTID"
  }
```

And then run:

```
curl -X 'GET' \
  'http://<fqdn>/ucsschool/kelvin/v1/users/?name=kimcorey&expiration_date=2030-03-10' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer ...'

```

Which will return `[]`. While filtering by another date date attribute (birthday) works:

```
curl -X 'GET' \
  'http://<fqdn>/ucsschool/kelvin/v1/users/?name=kimcorey&birthday=2010-02-24' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer ...'
```

Returns a list with one element (the created user).

I stumbled upon this bug while running the tests of `kelvin-rest-api-client` (a8257c34) and seeing that `tests/test_user.py::test_search_exact[expiration_date]` fails because no objects are found.

Nevertheless, the TravisCI pipeline in GitHub passes (uses `ucs5.0-1e175-ucsschool5.0v1-kelvin151`): https://github.com/univention/kelvin-rest-api-client/runs/6112658327?check_suite_focus=true

Might be related to:
  * https://forge.univention.org/bugzilla/show_bug.cgi?id=54159
  * https://forge.univention.org/bugzilla/show_bug.cgi?id=54126
  * https://forge.univention.org/bugzilla/show_bug.cgi?id=54116