Dear All,
In my page, I linked a table with a database. In this table, I have a column for the Date.
I wanted to have a Filter to select the date, so I added a field to enter the wanted date and a button OK with the following code:
export function OK_click(event, $w) {
wixData.query(‘Mois1’)
.contains(‘date’,$w(‘#input1’).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
});
}
For information, Mois1 correspond to my database name, input1 correspond to the field where you can enter the date, table1 to the Table where the data appear on the page.
When, I entered a date in the field and click OK, only selected date appeared in the table. That’s what I wanted, but I have no way to return to the table with all the dates. So I want to create a “All” button to have the possibility to have again all the dates when I will click on this button.
I am a beginner in code, so please could tell me how can I code this “All” button ?
Really thanks in advance for your help,
Best regards,
Francky