Database search options

Ask the community
, ,
7

Hi Jonathan,

While the syntax for your code appears correct, at the moment it is not possible to execute multiple ORs within a query using this method.
Thank you for bringing it into our attention.

To make this work change your code as per the example below:

import wixData from 'wix-data';
$w.onReady(function () { 
});
export function input1_keypress() {   
 wixData.query('Meditations')
  .or(wixData.query('Meditations').contains('title', $w('#input1').value))
  .or(wixData.query('Meditations').contains('code', $w('#input1').value))
  .or(wixData.query('Meditations').contains('author', $w('#input1').value))
  .find()
  .then(res => {   
     $w('#table1').rows = res.items;
   });
}