How do I filter wixdata with 'does not contain'

Ask the community
,
1

In a dataset I can set the ‘does not contain’ filter. But when I code in velo, there is no ‘doesnotcontain’ filter available. I have a tags field in my collection, which is a comma separated words list. I want to filter out certain tags using ‘does not contain’ for that field in my velo code. Please help.

I have the following lines to filter out a membership list to find people who have yet to pay their dues (if they had paid dues the previous years). The duesYear is set to the current year.

   let   newFilter  =  wixData . filter (). eq ( 'paid' ,  duesYear - 1 ) 
                . or ( wixData . filter (). eq ( 'paid' ,  duesYear - 2 )) 
                . and ( wixData . filter (). doesnotcontain ( 'tags' ,  'lifetime' )) 
                . and ( wixData . filter (). doesnotcontain ( 'tags' ,  'student' )) 
                . and ( wixData . filter (). doesnotcontain ( 'tags' ,  'dead' )); 

    $w ( '#duesunpaidDS' ). setFilter ( newFilter );

It does not accept ‘doesnotcontain’.

2

Hey! Did you try .ne()?

API docs

3

Try out

let newFilter = wixData.filter()
  .eq('paid', duesYear - 1)
  .or(wixData.filter().eq('paid', duesYear - 2))
  .and(wixData.filter().not(wixData.filter().contains('tags', 'lifetime')))
  .and(wixData.filter().not(wixData.filter().contains('tags', 'student')))
  .and(wixData.filter().not(wixData.filter().contains('tags', 'dead')));

$w('#duesunpaidDS').setFilter(newFilter);