Database in sandbox and live the same but dropdown not searching through all data

Ask the community
,
1

Hello all!

My site www.fliesenstore.at has one dropdown one searchbar and a gallery. The # repeater gallery is connected to the database by clicking like in the picture green.

1834×644 257 KB

The dropdown and searchbar are connected by code and # dataset 1 which is connected to my database.
Problem: the gallery shows all content of my database but dropdown and searchbar only shows the items I generate while I was working on the page (edit site).
Other content was generate in dashboard!
Filter from searchbar and dropdown only works with this content.
Synching from sandbox to live done but content seems the same but not working fine :frowning:

pls help me - many thanks in advance!

best regards
Christoph

2

is there nobody who can help me ?

3

Please try to explain your question in a more brief manner and include the code you are using

4

@shantanukumar847
I started wix code and created a database in the edit site menu. Then I wrote this code for filtering dropdown and so on

Code:

// For full API documentation, including code examples, visit Velo API Reference - Wix.com
import wixData from “wix-data”;
import wixLocation from ‘wix-location’;

let lastFilterTitle;
let lastFilterContinent;
let lastPreis;
let debounceTimer;
var cleanList;

$w.onReady( function () {
wixData.query(‘Holzoptik’).limit(1000).find().then(res => {
const uniqueTitles = getUniqueTitles(res.items);
cleanList = buildOptions(uniqueTitles);
cleanList.unshift({
“value”: ‘’,
“label”: ‘Alle Fliesen’
});
$w(‘#iFliesenoptik’).options = cleanList;
})

function getUniqueTitles(items) {
const titlesOnly = items.map(item => item.fliesenoptik);
return [… new Set(titlesOnly)];
}

function buildOptions(uniqueList) {
return uniqueList.map(curr => {
return { label: curr , value: curr };
});
}

$w("#repeater1").onItemReady(($w, dataItem, index) => {

let linkToDynamicPage = dataItem.linker;
$w(‘#button3’).onClick(() => {
wixLocation.to(linkToDynamicPage);
});

    $w('#container1').onClick(() => { 
        wixLocation.to(linkToDynamicPage); 
    }); 
});

});

export function iTitle_keyPress(event, $w) {
if (debounceTimer) {
clearTimeout(debounceTimer)
debounceTimer = undefined;
}
debounceTimer = setTimeout(() => {
filter($w(‘#iTitle’).value, lastFilterContinent, lastPreis);
}, 200);
}

function filter(title, optik, preisFilterEingabe) {
if (lastFilterTitle !== title || lastFilterContinent !== optik || lastPreis !== preisFilterEingabe) {
let newFilter = wixData.filter();
if (title)
newFilter = newFilter.contains(‘title’, title);
if (optik)
newFilter = newFilter.eq(‘fliesenoptik’, optik);
if (preisFilterEingabe < 31){
newFilter = newFilter.lt(‘preis’, 30);
console.log(“if-preis”);
} else (newFilter = newFilter.gt(‘preis’, 1)); //sonst alle

    $w('#dataset1').setFilter(newFilter); 
    lastFilterTitle = title; 
    lastFilterContinent = optik; 
    lastPreis = preisFilterEingabe; 

}

export function iFliesenoptik_change(event, $w) {
filter(lastFilterTitle, $w(‘#iFliesenoptik’).value, lastPreis);
}

export function auswahlGruppePreis_change(event, $w) {
filter(lastFilterTitle, lastFilterContinent, $w(‘#auswahlGruppePreis’).value);
}

Everything was working fine and I added some more content to my database “Holzoptik” , but now not from edit site menu rather from out from dashboard menu .
This new from dashboard added content is shown in my repeater but when I want to choose dropdown then only old (from in site menu added content) is shown .
I tried to synch from sand to live box and it seems that there is no difference between them .
What I am doing wrong ?

Thank you for your help !!!

5

solved !
Problem was my second filter . and all new added products have not get a price value in the database so they every time were filtered out when choosing dropdown or searchbar.