Platform for NGO and Social Projects needs your help with dropdown filter for repeater

Hello guys,

I’m a uni student and developing a new web platform for NGO and social projects to connect with possible new volunteers.
Our main feature, and need to correct/update to work properly, is the dropdown filter for regions in Brazil.
I’ve been searching through this fórum for solutions, but none of them worked for my website :frowning:

I’ve created a database and all the projects can be registered in “Inscreva seu Projeto” (Register your Project).

The problem I have is that my filter doesn’t show only the projects from the city chosen. The dropdown filter is located on “Projetos” and named as “Escolha sua cidade” (choose your city).

Here is the last code I tried using:

import wixData from “wix-data”;

$w.onReady(function () {
$w(“#repeater1”).onItemReady(($w, itemData) => {
$w(“#image1”).src = itemData.imagem;
$w(“#text21”).text = itemData.title;
$w(“#text22”).text = itemData.inicio;
});
});

export function dropdown1_change_1(event, $w) {
// Runs a query on the “AnoviaBusinesses” collection
wixData.query(“Projetos”)
// Query the collection for any items whose “Name” field contains
// the value the user selected in the dropdown
.contains(“regiao”, $w(“#dropdown1”).value)
.find() // Run the query
.then(res => {
// Set the table data to be the results of the query
});

}

Here is my website: https://matheusrodriguesco6.wixsite.com/

I have to show my MVP on next Monday (June 10th), if you could help me I really appreciate.

Thanks in advance.

https://www.wix.com/corvid/forum/community-discussion/filtering-repeater-with-a-dropdown
https://www.youtube.com/watch?v=r0DLqkRDJ34
https://www.youtube.com/watch?v=EhXed0u6wh0
https://www.youtube.com/watch?v=QhMKnm1f6EU
https://www.wix.com/corvid/forum/community-discussion/filter-dropdown-list
https://www.wix.com/corvid/forum/community-discussion/need-help-filtering-a-dataset-with-a-dropdown-adding-search
https://www.wix.com/corvid/forum/corvid-tips-and-updates/how-to-create-a-search-for-your-database
https://www.wix.com/corvid/forum/community-discussion/equal-to-or-more-than

thanks!!!
I will take a look.

Any more sources I still appreciate