Hello everyone,
I have an issue when displaying data from a collection into a table using drop downs.
The first drop down displays what I am looking for but the second is not displaying anything and is not showing anything when using the control log function. No errors are shown.
Then if possible I would like to implement a filter from my first drop down to the second:
For example if the dance activity queried by the first drop down is tango, the second drop down shall display either males or females looking for such an activity.
I would be grateful if someone can help.
This is my code:
import wixData from “wix-data”
export function searchbutton_click(event)
{ //Add your code for this event here:
// Runs a query on the “recipes” collection wixData.query(“FindPartner”)
// Query the collection for any items whose “Name” field contains
// the value the user entered in the input element
.contains(“fullNameOrUsername”, $w(" #searchBox “).value)
.find() // Run the query
.then(res => {
// Set the table data to be the results of the query
$w(” #table ").rows = res.items;
}); }
export function dropdown1_change(event) {
//Add your code for this event here:
// Runs a query on the “recipes” collection
wixData.query(“FindPartner”)
// Query the collection for any items whose “Name” field contains
// the value the user selected in the dropdown
.contains(“activity”, $w(" #dropdown1 “).value)
.find() // Run the query .then(res => {
// Set the table data to be the results of the query
$w(” #table “).rows = res.items
});}
export function dropdown2_change(event) {
//Add your code for this event here:
// Runs a query on the “recipes” collection
wixData.query(“FindPartner”)
// Query the collection for any items whose “Name” field contains
// the value the user selected in the dropdown
.contains(“gender”, $w(” #dropdown2 “).value)
.find() // Run the query
.then(res => {
// Set the table data to be the results of the query
$w(” #table ").rows = res.items
});}