This is my code which is working for first dropdown and taking the one unique value but on that value basis its not filtering the second dropdown values. Please help me with the code, to filter the data
import wixData from ‘wix-data’;
$w.onReady(function () {
//TODO: write your page related code here…
uniqueDropDown1();
});
function uniqueDropDown1 (){
wixData.query(“PCategory”)
.limit(1000)
.find()
.then(results => {
const uniqueTitles = getUniqueTitles(results.items);
$w("#dropdown105").options = buildOptions(uniqueTitles);
});
function getUniqueTitles(items) {
const titlesOnly = items.map(item => item.genre);
return [...new Set(titlesOnly)];
}
function buildOptions(uniqueList) {
return uniqueList.map(curr => {
return {label:curr, value:curr};
});
}
}
export function dropdown107_change(event,$w) {
//Add your code for this event here:
uniqueDropDown2();
$w(“#dropdown107”).enable();
}
function uniqueDropDown2 (){
wixData.query("PCategory")
.contains("subcategory", $w("#dropdown105").value)
.limit(1000)
.find()
.then(results => {
const uniqueTitles = getUniqueTitles(results.items);
$w("#dropdown107").options = buildOptions(uniqueTitles);
});
function getUniqueTitles(items) {
const titlesOnly = items.map(item => item.subcategory);
return [...new Set(titlesOnly)];
}
function buildOptions(uniqueList) {
return uniqueList.map(curr => {
return {label:curr, value:curr};
});
}
}
export function dropdown106_change(event,$w) {
//Add your code for this event here:
uniqueDropDown3();
$w(“#dropdown106”).enable();
}
function uniqueDropDown3 (){
wixData.query("PCategory")
.contains("movieTitle", $w("#dropdown107").value)
.limit(1000)
.find()
.then(results => {
const uniqueTitles = getUniqueTitles(results.items);
$w("#dropdown106").options = buildOptions(uniqueTitles);
});
function getUniqueTitles(items) {
const titlesOnly = items.map(item => item.movieTitle);
return [...new Set(titlesOnly)];
}
function buildOptions(uniqueList) {
return uniqueList.map(curr => {
return {label:curr, value:curr};
});
}
}