Lowercase fields text with dots

[Fabio-sama (Fabio)]

Hi!

I'm having a problem trying to interact with some fields created by the rollup job.

Once the job has finished running, it creates a given index where for example the previous usernames are now saved in fields called username.keyword.terms.value and username.keyword.terms.count.

Though, the value field is both case sensitive (keyword) and not made of nested objects (despite the dots).

I cannot find a way to access it to make, for example, all the aggregated usernames lowercase.

Ideas? Thanks!

[Fabio-sama (Fabio)]

General problem is the following:

I need to compare two indices, one where the username is in a field Username (I can basically do everything with it), another one where the username is in this username.keyword.terms.value.

How can I case insensitively compare the two?

Thanks!