# Sort script input needed **URL:** \ **Category:** Elasticsearch\ **Created:** [July 13, 2022, 11:41am UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527 "2022-07-13T11:41:53Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ansamHox](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@ansamHox](https://discuss.elastic.co/u/ansamHox)\ **Post date:** [July 13, 2022, 11:41am UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/1 "2022-07-13T11:41:53Z")
I have a dataset like this (sometimes `Source` field does not exist): ```auto Id Source Sender -------------------------------------------------------------------- 1 test@abc.com 2 amy@abc.com 3 Amy's channel amy@abc.com 4 Avery's channel test@abc.com 5 Bill's channel xxx@abc.com ``` I want to sort it by the `Source` field first, but if it doesn't exist, take the `Sender` field, the order should be 3 -\> 2 -\> 4 -\> 5 -\> 1. Tried: ```auto GET emailmessages-sort/_search { "query": { "match_all": {} }, "sort": { "_script": { "script": "if (doc['Source'].size() != 0) doc['Sender'].value; else doc['Sender'].value", "type": "string", "order": "asc" } } } ``` But the last document is **5** (it should be 1) (because it's sorted by `Sender` which is `xxx@test.com` instead of `Source` which is `Bill`. It's **3 -\> 2 -\> 4 -\> 1 -\> 5** and it should be **3 -\> 2 -\> 4 -\> 5 -\> 1** How can I sort by both fields combined, is this even possible? ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [July 13, 2022, 1:57pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/2 "2022-07-13T13:57:57Z")
```auto "sort": [ {"Source": "asc"}, {"Sender": "asc"} ] ``` does not work? ---
**Author:** ![ansamHox](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@ansamHox](https://discuss.elastic.co/u/ansamHox)\ **Post date:** [July 13, 2022, 2:03pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/3 "2022-07-13T14:03:01Z")
Nope, this will sort first by Source, and after that by Sender, it will be 3 -\> 4 -\> 5 -\> 2 -\> 1, which means `"Source = Bill's channel"` will be before `"Sender = amy@abc.com"` ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [July 13, 2022, 2:04pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/4 "2022-07-13T14:04:07Z")
How about the script below? ```auto if (doc.containKey('Source')){doc['Source'].value}else{doc['Sender'].value} ``` ---
**Author:** ![ansamHox](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@ansamHox](https://discuss.elastic.co/u/ansamHox)\ **Post date:** [July 13, 2022, 2:09pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/5 "2022-07-13T14:09:04Z")
This is not working because member method [java.util.Map, containKey/1] is not found, but I guess, by the logic, your answer would sort it in the same way ( 3 - 4 -5 - 2 - 1) which is not good.. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [July 13, 2022, 2:15pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/6 "2022-07-13T14:15:23Z")
Really? `doc.containsKey` also appears in the NOTE of the [official document](https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-scripting-fields.html#modules-scripting-doc-vals). and by the logic this script will sort in 3, 2, 4, 5, 1. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [July 13, 2022, 2:15pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/7 "2022-07-13T14:15:57Z")
Oh, sorry. there was typo. ```auto if (doc.containsKey('Source')){doc['Source'].value}else{doc['Sender'].value} ``` is correct. ---
**Author:** ![ansamHox](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@ansamHox](https://discuss.elastic.co/u/ansamHox)\ **Post date:** [July 13, 2022, 2:23pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/8 "2022-07-13T14:23:26Z")
> [@Tomo\_M](#): > > ```auto > if (doc.containsKey('Source')){doc['Source'].value}else{doc['Sender'].value} > > ``` reason" : "A document doesn't have a value for a field! Use doc[].size()==0 to check if a document is missing a field! bot fields are mapped as a `keyword` btw ---
**Author:** ![ansamHox](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@ansamHox](https://discuss.elastic.co/u/ansamHox)\ **Post date:** [July 14, 2022, 10:40pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/10 "2022-07-14T22:40:15Z")
Ok, I found the issue, it wasn't working because of Capitalized letters, I just put on both fields `"normalizer" : "lowercase"`, and it works now as: ```auto GET emailmessages-sort2/_search { "query": { "match_all": {} }, "sort": { "_script": { "script": "if (doc['Source'].size() != 0) doc['Source'].value; else doc['Sender'].value", "type": "string", "order": "asc" } } } ``` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 11, 2022, 10:40pm UTC](https://discuss.elastic.co/t/sort-script-input-needed/309527/11 "2022-08-11T22:40:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.