I am having an issue with some of the table options. I’d like to limit the table to 10 rows and then allow pagination. Here are my commands (simple xml):
<option name="count">10</option> <option name="showPager">true</option>
While the pagination seems to be working, the count option doesn’t work at all – it defaults to displaying however many rows I had displayed in my saved search (ie, 50) and only does pagination after this point. Are my commands wrong, or is something else the problem? Any ideas?
What is your search that renders the table? I've never experienced this, but my searches tend to be something like "... | table field1, field2". Are you using the table command or something else?
Emily, you're right. The count option has no effect. The showPager option does. See if this workaround works for you:
Alternatively, you (or your Splunk Admin) can correct the viewstate:
This is a bug, which I will file on your behalf. Thank you for bringing this to our attention. 🙂
This is being tracked as SPL-32968. The problem is regarding applying viewstate. When a search is saved, a copy of the current view state is made and stored in $SPLUNK_HOME/etc/users/admin/search/local/viewstates.conf. When the search is loaded, the configuration that is last applied is the viewstate and this is clobbering the XML defined "count" option.
This is going to be fixed in 4.2.3, for anyone who is interested.