109
Views
18
Comments
Solved
Use DropdownSearch to filter a List
Question

Hey guys!

I am currently trying to filter a List by using a DropdownSearch and i cant figure out how to get it to work or what I am doing wrong. 

Here is my latest attempt:


Test_Application.oml
2023-08-28 07-00-10
Paulo Torres
Champion
Solution
2019-11-08 14-27-49
Miguel Riso Almeida

Hello Fritz, 

Your aggregate needs to be filtered by your variable, filterByName.

Or you should mapping the value that you have in filter by name onto the SearchKeyWord variable.


Hope I could help you

2022-08-03 04-32-50
Ravi Punjwani

The screen looks incorrectly set up in terms of variables and sequence of execution after data fetch happens. Kindly share your OML file, it might be possible for us to find out what's wrong exactly and how to fix it.

Also please explain in brief, what is your requirement for this piece of code. I also need to see how are you fetching the aggregate GetMovies.

UserImage.jpg
Fritz Wagner

I edited my question and uploaded the oml :)

2023-08-28 07-00-10
Paulo Torres
Champion

You need another query for Table. If you filter your query you will affect Dropdown and table. After you need a local variable to hold the value selected and filter the query. If I understood well what you want achieve.

UserImage.jpg
Fritz Wagner

Hey could you somehow show me what you mean exactly ? I'm still a beginner and don't really know what to do with your information :D

2023-08-28 07-00-10
Paulo Torres
Champion
2023-08-28 07-00-10
Paulo Torres
Champion

Here it is. Let me know if you have doubts!

Test_Application.oml
UserImage.jpg
Fritz Wagner

Thank you ! But are you sure you uploaded the correct version because i get an error when i open it ? The FilterByName Variable doesnt exist


2023-08-28 07-00-10
Paulo Torres
Champion

Hi Fritz,

Correct but with a mistake, didn't notice.

Now the correct file attached

Test_Application.oml
UserImage.jpg
Fritz Wagner

Sry for the late answer. This doesnt work for me still, the selected value in the dropdownsearch instantly disappears after selecting and the List does not change. Maybe you are using another version of outsystems ? Thank you for helping though really appreciate it.

2023-08-28 07-00-10
Paulo Torres
Champion

Let me check, I'll publish on my side to understand what you mean and make a video probably for you.

2023-08-28 07-00-10
Paulo Torres
Champion
Solution
Test_Application.oml
UserImage.jpg
Fritz Wagner

Nice thank you, that's what i was looking for! Really appreciate it

2023-08-28 07-00-10
Paulo Torres
Champion

Good to know.

It was a mistake when I did this on the first time, even on low code we can create bugs :)


2023-10-27 13-43-55
Mafalda Melo Oliveira

Hello Paulo

https://success.outsystems.com/documentation/how_to_guides/front_end/how_to_use_the_dropdown_search_to_filter_an_aggregate_with_a_single_attribute/


based on this, but having records not repeated.. cant have the output list as here.. dont want repeated records


Your oml has a list, but imagine you have duplicated records

2023-08-28 07-00-10
Paulo Torres
Champion

Hi Mafalda,

To not have repeated record depends of your SQL query.

Thanks

2023-10-27 13-43-55
Mafalda Melo Oliveira

I had already tried it

Also i disabled multiple selection in odc and it still does it sometimes.. Is it a bug? In o11 it was fine 

Thanks. 


2023-08-28 07-00-10
Paulo Torres
Champion

Answer on the private chat you open with me as this topic is very old :)

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.