Message "Loading filtering options..." not shown

hkuesters

HI!
I have a problem, because at my datatable with searchPanes the message "Loading filtering options..." (from SearchPane) will not be shown.
Link to my case: https://p582810.webspaceconfig.de/suche-dynamic Press the button "Suchen" and the datatable will come... It is with about 18.000 datasets.

My Configuration (part)

    $('#tbl_spbsdyn').DataTable( {
        "language": {
            "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/German.json",
        },
        "dom": 'PlfrtipB',
        "deferRender": true,
        "searchPanes": {
            i18n: {
                loadMessage: 'Loading filtering options...'
            },
            threshold: 1,
            viewTotal: true,
            columns: [3, 5, 6, 7, 11, 12],
            layout: 'columns-6',
            controls: false,
            cascadePanes: true,
            emptyMessage: '-',
            dtOpts:{
                select:{
                    style: 'multi'
                }
            },
        },

The message "Is loading..:" will not come. What's rong?

Thanks for your help!
Hubert

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

sandy

Hi @hkuesters ,

It's not working because you are loading the data entirely from the dom! I'd strongly suggest that you move to loading your data over ajax using ajax. The page will load much faster, and the message will show!

Thanks,
Sandy

hkuesters

Hi Sandy!

Thank you very much - I understand!
But my dataset is always different, depending on the user selection in the form before. So i cannot write a static json-file and use it as datasource.
I look forward for another way handling the result-datasets.

Thanks
Hubert

sandy

Hi @hkuesters ,

You could create the dataset dynamically? Just set some form parameters as part of the ajax request.

Thanks,
Sandy