# Painless script error in getting sameday documents

**URL:** https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061
**Category:** Kibana
**Tags:** painless
**Created:** [September 1, 2020, 8:12am UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061 "2020-09-01T08:12:56Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 1, 2020, 8:12am UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/1 "2020-09-01T08:12:56Z")

</div>

Hi All,

We are pulling data into elasticsearch using logstash http\_poller and our datasource is servicenow.

We have so many incidents created in a day, i'm trying to write a painless script get get the same day closure tickets for which i'm using the below script, but its throwing an unexceptional error.

```
if ((doc['result.resolved_at'].date.dayOfYear - doc['result.sys_created_on'].date.dayOfYear) ==0)
{
return 0;
} else {
return 1;
}

```

We are using version 7.6.2

Any advice please.

Thanks  
Gautham

---

<div class="post-metadata">

### Author: ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)
#### Post date: [September 1, 2020, 8:38am UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/2 "2020-09-01T08:38:49Z")

</div>

Try this may help

```
if (((doc['result.resolved_at'].value.toInstant().toEpochMilli() - doc['result.sys_created_on'].value.toInstant().toEpochMilli()) / 1000 * 60 * 60 *24) == 0){
	return 0;
} else {
	return 1;
}
```

---

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 1, 2020, 9:32am UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/3 "2020-09-01T09:32:36Z")

</div>

@ylasri

Its working great.. Thanks .....

If i need to calculate for month then should i need to multiply by 12

Thanks  
Gautham

---

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 1, 2020, 11:22am UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/4 "2020-09-01T11:22:02Z")

</div>

@ylasri I also need to write a condition to check the resolved at, because it'll be empty sometimes, any idea in adding that condition along with the provided code.

Thanks  
Gautham

---

<div class="post-metadata">

### Author: ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)
#### Post date: [September 1, 2020, 12:38pm UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/5 "2020-09-01T12:38:28Z")

</div>

Use something like this to check if field exist in the doc

`if (!doc.containsKey('myfield') || doc['myfield'].empty) { return "unavailable" } else { return doc['myfield'].value }`

---

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 1, 2020, 1:23pm UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/6 "2020-09-01T13:23:20Z")

</div>

@ylasri Got it its working perfectly.....

---

<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: [September 29, 2020, 1:23pm UTC](https://discuss.elastic.co/t/painless-script-error-in-getting-sameday-documents/247061/7 "2020-09-29T13:23:26Z")

</div>

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