# Scripted fields values not getting populated on visualize but are populated during discover

**URL:** https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931
**Category:** Kibana
**Created:** [June 4, 2021, 12:14am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931 "2021-06-04T00:14:11Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![nitish012](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nitish012](https://discuss.elastic.co/u/nitish012)
#### Post date: [June 4, 2021, 12:14am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/1 "2021-06-04T00:14:11Z")

</div>

Hi Kibana Experts,

I am using Kibana scripted fields using painless to populate a URL like this:

```auto
Url Template : https://dummy_url?branch={{value}}&id=abc
Script: 
if (!doc['branch_name'].empty) {
    return (doc['branch_name'].value)
}

```

When I access this scripted field for my index pattern in Discover, the value gets populated correctly and I can access the URL but when I am accessing the same scripted field in "data table" Visualize, the URL is missing the value populated by {{value}}.

Can you please help on how I can populate the scripted field correctly on data table visualize?

I am using Kibana Version, 5.4.1.

Thanks

---

<div class="post-metadata">

### Author: ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [June 4, 2021, 1:40am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/2 "2021-06-04T01:40:11Z")

</div>

Can you show the doc?

---

<div class="post-metadata">

### Author: ![nitish012](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nitish012](https://discuss.elastic.co/u/nitish012)
#### Post date: [June 4, 2021, 6:01am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/3 "2021-06-04T06:01:46Z")

</div>

It is a huge doc but this specific field has values like:

```auto
branch_name

develop
master
release/f1
release/f2

```

and the field details are like the screenshot.

 ![Screen Shot 2021-06-03 at 10.58.32 PM](https://us1.discourse-cdn.com/elastic/original/3X/2/b/2b060ac1bea050bbb4d50a78a92bdc8f589d07a3.png)

---

<div class="post-metadata">

### Author: ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [June 4, 2021, 9:08am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/4 "2021-06-04T09:08:20Z")

</div>

Where is that URL? How is it populated?  
I did not understand your requirements fully.

---

<div class="post-metadata">

### Author: ![nitish012](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nitish012](https://discuss.elastic.co/u/nitish012)
#### Post date: [June 4, 2021, 6:00pm UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/5 "2021-06-04T18:00:50Z")

</div>

The URL is populated by the scripted field like the snapshot and I want to access that URL in my data table visualize but the URL is missing the value populated by {{value}}.  
It shows like this for all the rows:

https://dummy\_url?branch=&id=abc

 ![Screen Shot 2021-06-04 at 10.56.25 AM](https://us1.discourse-cdn.com/elastic/original/3X/5/a/5a2d62c1d954ed4e3c0973afff13b34e895fdca4.png)

---

<div class="post-metadata">

### Author: ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [June 7, 2021, 6:00am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/6 "2021-06-07T06:00:19Z")

</div>

Try using `{{rawValue}}` instead of `{{value}}`

---

<div class="post-metadata">

### Author: ![nitish012](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nitish012](https://discuss.elastic.co/u/nitish012)
#### Post date: [June 7, 2021, 6:38am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/7 "2021-06-07T06:38:55Z")

</div>

Already tried rawValue but that didn't help.

---

<div class="post-metadata">

### Author: ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [June 7, 2021, 6:48am UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/8 "2021-06-07T06:48:18Z")

</div>

Try putting `url?id=abc&branch={{value}}`  
so your arameter will be at the end?!

---

<div class="post-metadata">

### Author: ![nitish012](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nitish012](https://discuss.elastic.co/u/nitish012)
#### Post date: [June 7, 2021, 5:56pm UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/9 "2021-06-07T17:56:30Z")

</div>

Tried that too but that didn't work either

---

<div class="post-metadata">

### Author: ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [June 7, 2021, 11:29pm UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/10 "2021-06-07T23:29:05Z")

</div>

I am using v 7.9.1 and it works fine.  
Last idea, try adding `keyword`  
Like

```auto
if (!doc['branch_name.keyword'].empty) {
    return (doc['branch_name.keyword'].value)
}

```

If that doesn't work it might be a version-specific bug?  
Try contacting Elastic for this issue.

---

<div class="post-metadata">

### Author: ![nitish012](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nitish012](https://discuss.elastic.co/u/nitish012)
#### Post date: [June 7, 2021, 11:48pm UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/11 "2021-06-07T23:48:00Z")

</div>

Tried keyword too but that doesn't work either.

---

<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: [July 5, 2021, 11:48pm UTC](https://discuss.elastic.co/t/scripted-fields-values-not-getting-populated-on-visualize-but-are-populated-during-discover/274931/12 "2021-07-05T23:48:57Z")

</div>

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