Hello,
I have a table on my splunk dashboard. I have a search to get the data and I am using fields to filter out the columns that I want to see on my dashboard. I observed that, even if I filter out a couple of columns to display, I am still able to use the other column data (column c or d from below example) that I am not displaying for other purpose. Below is the format that I am using for a splunk table.
<search>
<query>| dbxquery connection=connection query="SELECT a, b, c, d FROM t1"
</query>
</search>
<fields>["a", "b"]</fields>
Now, I have a requirement to create a custom Splunk table using JavaScript. I was able to do the same but I am not sure how to use the <fields> provided by Splunk in JavaScript. The problem that I observed with JavaScript table is that, If I am not displaying a particular column, I will not be able to use that column data for other operations. I basically want to display just a, b columns from my JavaScript query but at the same time utilize the c, d column data for other operations. Kindly suggest a solution for this.
If you are using a TableView in JS, it also appears to support the fields attribute
https://docs.splunk.com/DocumentationStatic/WebFramework/1.0/compref_table.html
If you are using a TableView in JS, it also appears to support the fields attribute
https://docs.splunk.com/DocumentationStatic/WebFramework/1.0/compref_table.html
Awesome. That worked. Thank you so much 😀
I have used myTable.settings.set("fields", ["a", "b", "c"]); after initializing myTable (TableView)