Dataset setFilter only allowing eq? Errors on ne or isNotEmpty

Ask the community
, ,
1

I have a repeater hooked up to to a dataset to show recently-joined members to my site.

But I only want to show members who’ve entered their nickname. As a test, when I try filtering on “eq” it works:

$w("#latestMembersDataset").setFilter( wixData.filter().eq("nickname","Bob") );

But when I do the real filter:

$w("#latestMembersDataset").setFilter( wixData.filter().isNotEmpty("nickname") );

I get an error: Validation error. Invalid filter operation $ne for field ‘nickname’.

I’ve also tried .ne(“nickname”,“”) and it’s the same. It does’t matter what field I test on, only “eq” works but not “ne” or “isNotEmpty”.

Does anyone have any ides why this is happening?

2

Depending on which database you’re using, it’s worth taking a read over these dosc:

https://www.wix.com/velo/reference/wix-members-backend/"privatemembersdata"-collection-fields
https://www.wix.com/velo/reference/wix-members-backend/"publicdata"-collection-fields
https://www.wix.com/velo/reference/wix-members-backend/"fulldata"-collection-fields

They’ll provide you with information over what can be filtered/sorted according to the fields in each database :slight_smile:

Hope that helps