Filtering problem with large list

[Patrik]

Hello i have a problem with list that is over 5000 items. When i use this function it filters but returned items are on pages that are not visible i have to manually click on next page buttons function

after applied filter

after clicking twice on next page button

var dt = fd.control('helpdesk');

    dt.ready(function() {
        filterDT();
    });

filterDT() {
let filters = ;

    // Schvaleno musí být true
    filters.push(`
        <Eq>
            <FieldRef Name='Schvaleno'/>
            <Value Type='Boolean'>1</Value>
        </Eq>
    `);

    if (fd.field('Dodavatel').value) {
        filters.push(`<Eq><FieldRef Name='Dodavatel' LookupId='TRUE'/><Value Type='Lookup'>${fd.field('Dodavatel').value.LookupId}</Value></Eq>`);
    }

    if (fd.control('Spolecnost').value) {
        filters.push(`<Eq><FieldRef Name='Spolecnost' LookupId='TRUE'/><Value Type='Lookup'>${fd.control('Spolecnost').value.LookupId}</Value></Eq>`);
    }
    
    if (fd.control('SearchHelpdesk').value) {
        filters.push(`<Eq><FieldRef Name='HelpDesk' LookupId='TRUE'/><Value Type='Lookup'>${fd.control('SearchHelpdesk').value.ID}</Value></Eq>`);
    }
    
    let combinedFilter = '';

    if (filters.length === 1) {
        combinedFilter = filters[0];
    } else {
        while (filters.length > 1) {
            let first = filters.pop();
            let second = filters.pop();
            filters.push(`<And>${second}${first}</And>`);
        }
        combinedFilter = filters[0];
    }

    dt.filter = combinedFilter;
    console.log(combinedFilter);
    dt.refresh();
}

[Margo]

Hello @Patrik,

Can you please share a screenshot of the errors in the browser console?

Additionally, please check the version of the web part and the widget the form is using. To do this, open the form, then open the Developer Tools (F12) > Sources > Page >forms.plumsail.com.
Please share a screenshot of that as well.

[Patrik]

It throws errors when i choose a value from helpdeskid lookup field cuz there are over 5000 items it says something like : The requested operation is prohibited because it exceeds the list view threshold. but after i choose a value it doesnt throw any errors