I want to query the Wix-Events Collection and filter the results to display only future events.
I’m also capturing certain event title elements into a string to populate into a textbox (which works)
Every time i try to filter the ‘Events/Events’ ‘start’ date I get a “.gte not supported” error.
anybody have any advice?
my code
import wixData from ‘wix-data’ ;
$w . onReady ( function () {
let today = new Date (); //populate date as var
const options = { weekday : “short” }; //format the date
wixData . query ( “Events/Events” )
. ascending ( “start” ) // sort collection by start date
.gt(“start”,today) <= this is the bad filter
. find ()
. then (( results ) => {
if ( results.items.length > 0 ) { //check for existing data
let x = 0 ; // set array counter
let Event = “” ; // clear string before capturing info
do { //start loop
let Item = results.items[x ]; //load array into variable
let date = Item . start ; //extract event startdate
// multi line string with the array title and date info
Event = Event + date . toLocaleDateString ( ‘en-US’ , options ) + " " + Item . scheduleStartTimeFormatted + " - " + Item . title + “\n” ;
x = x + 1 ; //increase the array counter
} while ( x < 4 ); //loop 4 times
$w ( “#times” ). text = Event ; // populate the text field
}
})
. catch (( err ) => {
let errorMsg = err ;
});
;
});