For Loop to retrieve column from DB

Ask the community
,
1

Hi, I’m trying to extract a date type column form by DB and disable these dates on a Date Picker.
Apparently having issued on my FOR Loop because it won’t go through the code after the loop. I appreciate your help.

$w.onReady( function () {
$w(“#dataset1”).onReady( () => {
$w(“#dataset1”).getItems(0, 5)
.then( (result) => {
let items = result.items;
let fechasOcupadas = [];
for ( var i = 0; i < 5; i++) {
fechasOcupadas.push({“label”: items[i].fechaYHora.toDateString()});
}
$w(“#datePicker1”).disabledDates = fechasOcupadas;
})
. catch ( (err) => {
});
});
});

2

@amonsalvek Just a slight adjustment, and you’re there. No need to create an object and assign a string date value to a label. The disabledDates property expects an array of dates. So your “push” statement would be

fechasOcupadas.push(items[i].fechaYHora);
3

Hi anthony. Thanks for your response.
For some reasone I’m having two problems:

1st the code isn’t reading beyond the FOR Loop (even tried console.log and it won’t go through it)
2nd I changed the code to the one you said, and I also put the disableDates inside the Loop, but it shows the following error:
“Wix code SDK error: The disableDate parameter of item at index 0 that is passed to the disabledDates method cannot be set to the value [object Object]. It must be of type date.”

4

@amonsalvek I’ve tested the following code, and it disables certain dates in a datePicker element without errors:

$w.onReady(function () {
    $w("#dataset1").onReady( () => {
        $w("#dataset1").getItems(0, 5)
        .then( (result) => {
            let items = result.items;
            let fechasOcupadas = [];
            for (var i = 0; i < 5; i++) {
                fechasOcupadas.push(items[i].fechaYHora);
            }
            $w("#datePicker1").disabledDates = fechasOcupadas;
        })
        .catch( (err) => {
        });
    });
});
5

thank you so much! it worked!!