Issues filtering .isEmpty option

Ask the community
,
1

Hi,
I have a dataset that I would like to filter. In the repeater I would like to only show items where “referat” is empty but the filter I has set up does not seems to work. The other two criteria (.le and .eq) is working fine, but not the .isEmpty.

Anyone who has an idea what I am doing wrong?

 //filter then load dataset2 into repeater 7
    $w("#dataset2").onReady(() => {
 let today = new Date();
        console.log(today)
        today.setHours(23);
        today.setMinutes(59)
        today.setSeconds(59)
        console.log(today)
        $w("#dataset2").setFilter(wixData.filter()
        .isEmpty("referat")
        .le("datoOgTidspunkt", today)
        .eq("aktivt", Boolean(true))
        );
        console.log("dataset2 filter set")
        $w("#dataset2").onCurrentIndexChanged((index) => {
 let newIndex = index;
            $w("#preLoader2").collapse();
            $w("#repeater7").expand();
        });
    });
2

Note that isEmpty() only matches items where the value of the specified property is null or undefined or the property does not exist. If the field contains an empty string (that is: “”) or an invalid value, it will not filter.

3

Thanks. How can I then filter the items where this rich text field has not yet been filled out?

4

If the issue is a blank field “”, then you might be able to test for .isEmpty(‘referat’) or .eq(‘referat’, “”).