I wrote a piece of code to display the search result from database and it worked when I tried it in preview mode. But after I published the site and tried to search it again, it was just blank. I have synchronized the sandbox and Live database already. The code shouldn’t have problems since I find it in the official tutorial and I worked when I test it in the preview mode. I just get confused why I could search data in preview mode but not after published. It doesn’t make sense! Can anyone help me fix it? Thanks a lot!
This image shows that I worked when I search in the preview mode.
This image shows that it doesn’t work after published.
The code is:
import wixData from ‘wix-data’;
$w.onReady( function () {
$w(“#table1”).hide();
});
export function button1_onclick(event) {
$w(“#table1”).show();
wixData.query(‘Order’)
.contains(‘email’, $w(‘#input1’).value)
.find()
.then((results) =>{
$w(‘#table1’).rows = results.items;
});
}