Hi everyone,
i’m new in this forum. I’ve got a big issue with my first wix site.
I’m trying to get some specific data from a dataset (Listini), based on a multiple choice form, which saves information in another dataset ( multiStepRegistrationForm2) .
It works well in preview mode, but it doesn’t work online (live).
I checked all the previous discussions about it, but it’s not a matter of permissions or onReady function.
I’ll show you my query code: the goal is getting specific rows from dataset “Listini”, using a filter query “lt(…)” by means of the data submitted live by the user.
The wrong result is getting all the rows of “Listini” dataset.
I’m looking forward to your reply.
Thank you!
p.s. the limit(145) is setted because there are only 145 rows in Listini
and tastiDiScelta3 is one of the radiobuttons in the form
import wixData from ‘wix-data’ ;
import wixWindow from ‘wix-window’ ;
$w.onReady( function () {
let firstItem;
wixData.query( 'multiStepRegistrationForm2' )
.find()
.then((results) => {
if (results.items.length > 0 ) {
firstItem = results.items[ 0 ];
console.log(firstItem);
let myQuery;
if (firstItem.tastiDiScelta3 === “Less than 50000” ) {
myQuery = wixData.query( 'Listini' ).limit( 145 ).lt( 'price' , 50000 );
} **else if** (firstItem.tastiDiScelta3 === "Less than 80000" ) {
myQuery = wixData.query( 'Listini' ).limit( 145 ).lt( 'price' , 80000 );
} **else if** (firstItem.tastiDiScelta3 === "Indifferent" ) {
myQuery = wixData.query( 'Listini' ).limit( 145 );
}
myQuery.find().then((elements) => {
if (elements.items.length > 0 ) {
$w( "#table1" ).rows = elements.items.sort();
console.log(elements.items[ 0 ]);
} **else** {
$w( "#table1" ).collapse();
wixWindow.openLightbox( "LightboxName" , "There are no cars with those characteristics" )
.then((data) => {
let receivedData = data;
});
}
});
} **else** {
$w( "#table1" ).collapse();
}
})
. **catch** ((err) => {
let errorMsg = err;
});
});