# Can i show only specific field in visualization data table?

**URL:** <https://forum.opensearch.org/t/can-i-show-only-specific-field-in-visualization-data-table/9144>\
**Category:** OpenDistro\
**Tags:** configure\
**Created:** [April 6, 2022, 2:27am UTC](https://forum.opensearch.org/t/can-i-show-only-specific-field-in-visualization-data-table/9144 "2022-04-06T02:27:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![parkjp](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@parkjp](https://forum.opensearch.org/u/parkjp)\
**Post date:** [April 6, 2022, 2:27am UTC](https://forum.opensearch.org/t/can-i-show-only-specific-field-in-visualization-data-table/9144/1 "2022-04-06T02:27:26Z")

</div>

AWS opensearch service, v1.2.

In my data, for example,  
[  
{  
“@timestamp”: “Apr 5, 2022 @ 11:00:00”,  
“level” : “INFO”,  
“name”: “Login”,  
“type”: 1,  
“service” : “my-service”,  
“jsonpayload”: {  
“key1” : “data1”,  
“key2” : “data2”  
}  
},  
{  
“@timestamp”: “Apr 5, 2022 @ 11:01:00”,  
“level” : “INFO”,  
“name”: “Logout”,  
“type”: 1,  
“service” : “my-service”,  
“jsonpayload”: {  
“key5” : “data5”, // ( key is different with above )  
“key6” : “data6”,  
}  
}  
]

And I want to visualize using data table select only “jsonpayload”.  
I tried to make saved query in discover.  
Add filter → Edit as Query DSL like this  
{  
“\_source”: {  
“includes”: [“jsonpayload”],  
“excludes”:   
},  
“query”: {  
“match” : {  
“type”: 1  
}  
}  
}

but it shows all fields of my data.  
it seems to be not working “includes” in DSL.

Are there other ways to show only specific field in data table for visualization?  
I want to show just “jsonpayload” field in data table.  
Somebody can help me?

---

<div class="post-metadata">

**Author:** ![kris](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/kris/32/2208_2.png) [@kris](https://forum.opensearch.org/u/kris)\
**Post date:** [February 7, 2023, 6:45pm UTC](https://forum.opensearch.org/t/can-i-show-only-specific-field-in-visualization-data-table/9144/2 "2023-02-07T18:45:44Z")

</div>