Total count after filter?

Ask the community
,
1

I have a repeater on a page. And with a piece code, I managed to filter the data. But now, I want to know how many items are shown after the filter. I don’t know how to do this and couldn’t find anything in the corvid API reference that worked.

This is my filter code:

$w.onReady( function() {
    $w('#dynamicDataset').onReady(async () => {
 let item = await $w('#dynamicDataset').getCurrentItem();
 let currentStudio = item._id;
        $w("#dataset1").setFilter( wixData.filter()
        .eq("studio", currentStudio)
        )
    })
})
2

Hi Quin :raised_hand_with_fingers_splayed:

You can use the getTotalCount() function after setting the filter:

let filter = wixData.filter().eq("studio", currentStudio);

$w('#dataset1').setFilter(filter).then(() => {
    let total = $w('#dataset1').getTotalCount();
    console.log('Total count after filter is:', total);
})

Hope this helps~!
Ahmad