Is it possible to query a database for an item that DOES NOT include a specific value?

Ask the community
,
1

I’d like to for example query my database for all items which exclude the text “value”

import wixData from 'wix-data';

wixData.query("myCollection")
  .DOES NOT INCLUDE("identifier", "value")
  .find()
  .then( (results) => {
  } )
  .catch( (err) => {
    let errorMsg = err;
  } );
2

Try using ne( ) . Depending on your use case, you might be able to use not( ) .

3

ne( ) wont work in this instance, I’ll give not( ) a try and report back:

Thank you

wixData.query("myCollection")
 .isNotEmpty("identifier")
 .not(wixData.query("myCollection")
 .contains("identifier", "value")
 )
 .find()