using a query to filter table content

Ask the community
,
1

Greetings,

after much tinkering and working through lots and lots of entries, I came up with the following to filter a dataset so that only certain items display:

wixData.query("DailyBetList")
     .eq('finalResults', " ")
    .find()
    .then((results1) => {
 let items1 = results1.items;
 
        console.log(items1);
 
        $w('#TodayRecommendations').rows = items1;
     })
     .catch((err) => {
 let errorMsg = err;
      });

It works fantastically great on the sandbox…but whenever I publish it live (either as part of the page load or as part of a button function), the results are blank…

any suggestions as to what the problem might be?

2

I would believe that you haven’t synced your Data Collection between your Sandbox data and your live data. Go to your Data Collection and Select Sync from Sandbox → Live and you should be good to go.

3

Actually, I figured out the problem: on the sandbox database, using " " works as an identifier, but on the live database, using null works, so that’s what I did, and it works so far.