Splunk Search

Change TableElement option in Javascript

MaryvonneMB
Path Finder

Hi,

I would like to create a "results per page" dropdown in a table I display in a dashboard.
First I create a dropdown input like the following:

<label>Select number of rows</label>
<choice value="10">10</choice>
<choice value="20">20</choice>
<choice value="50">50</choice>
<default>10</default>
</input>

Then in a javascript file I retrieve the value of $row_number$ and naively I tried to change the "count" option of my table to change the table vizualisation

 var tokensDefault=mvc.Components.get('default');
            tokensDefault.on('change:row_number',function (model, value, options) {

                var rowNumber=tokensDefault.get('row_number');
                console.log(rowNumber);
                var resultTable=mvc.Components.getInstance('resultTable');
                resultTable.set('count',rowNumber);
                resultTable.render();
            });

But I have error: like resutTable.set is not a function.
Does anyone have an idea on how I can fix it?
Thanks in advance for any help!

0 Karma

jeffland
SplunkTrust
SplunkTrust

There are two things about that. First of all, the error you're seeing is most likely because you didn't give your table the id resultTable in Simple XML. You need exactly the same name:

  <row>
    <panel>
      <table id="resultTable">
        <search> ...

"foo.set is not a function" is javascript's way of telling you that resultTable is undefined (pretty obvious, I know). You can verify this if you set a breakpoint on the line where you try to call set() and check what resultTable is. If it's not an object, you didn't "get" it from mvc.Components in the first place. Unfortunately, this is where you have to know js well enough and/or be able to debug it, because mvc.Components.get() doesn't tell you if it was successful. At any rate, giving your table the same id you try to get() in js should solve this problem. Oh and by the way, getInstance() is for getting token models and get() for anything else, see here for docs - however, I just use get() for all things and never had any problems with that.
As soon as that works, what you want to set in order to change the number of rows displayed in your table is an option named pageSize in resultTable.visualization, not in resultTable itself. Code in js would look something like this:

var resultTable = mvc.Components.get("resultTable");
var defaultTokenModel = mvc.Components.get("default");
defaultTokenModel.on("change:count_tok", function(model, value) {
    resultTable.visualization.settings.set("pageSize", value);
    console.log(value);
});

Hope I could be of help 🙂

0 Karma
Get Updates on the Splunk Community!

New Dates, New City: Save the Date for .conf25!

Wake up, babe! New .conf25 dates AND location just dropped!! That's right, this year, .conf25 is taking place ...

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...