# Lowercase fields text with dots

**URL:** <https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061>\
**Category:** Elasticsearch\
**Created:** [May 28, 2019, 10:39am UTC](https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061 "2019-05-28T10:39:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fabio-sama](https://avatars.discourse-cdn.com/v4/letter/f/b9e5f3/32.png) [@Fabio-sama](https://discuss.elastic.co/u/Fabio-sama)\
**Post date:** [May 28, 2019, 10:39am UTC](https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061/1 "2019-05-28T10:39:29Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Fabio-sama](https://avatars.discourse-cdn.com/v4/letter/f/b9e5f3/32.png) [@Fabio-sama](https://discuss.elastic.co/u/Fabio-sama)\
**Post date:** [May 28, 2019, 10:46am UTC](https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061/2 "2019-05-28T10:46:59Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 25, 2019, 10:47am UTC](https://discuss.elastic.co/t/lowercase-fields-text-with-dots/183061/3 "2019-06-25T10:47:09Z")

</div>

Closed on June 25, 2019, 10:47am UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
