Want to show all rows in searchpanes but max 63 is appearing

himanshuvora

Link to test case:
Debugger code (debug.datatables.net): ehufax
Error messages shown:
Description of problem: In 2nd column have total 162 distinct values but only 63 shows in searchpanes have tried to change displaylength to 1000 but max 63 only shown. kindly help me to show all rows in searchpanes

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Colin

DeutscherBiber

Hi,
I had the same issue where the data, despite the backend providing around 250 entries, did not display all 250 unique (distinct) values but was instead limited to 64. Although the scrollbar appeared as if more entries were available, only 64 were actually displayed. The remaining values were not hidden but simply not loaded.

In datatables.js or datatables.min.js, there is a configuration called SearchPane.prototype._getPaneConfig, where scrollY is set to 200px. Changing this value to, for example, 600px ensures that all entries are displayed. However, this is not a visually appealing solution, and I strongly advise against modifying the library directly.

Instead, you can configure the searchPanes options using dtOpts:

dtOpts: {
    scroller: {
        displayBuffer: 9
    }
}

The default behavior of displayBuffer is 9 (?). Increasing this value will allow more options to be displayed.