2029
Views
19
Comments
Solved
Filter in DropDown
Question

Hello everyone,

I would like to filter specific data through a drop-down list (combo box), but I am not sure how to do it. 

It is very complicated? Can anyone help me in this matter?



Thanks in advance :)

2022-06-09 15-23-03
Orla Dijkink
 
MVP
Solution

You need to filer on the SolicitanteId on your aggreagte, now your only filtering on SearchKeyword.

You need something like:

SolicitanteId = nullidentifier() or SolicitanteId = <Your_Entity>.SolicitanteId

2021-03-18 21-03-15
Benjith Sam
 
MVP
Solution

As mentioned by Orla in the previous comment, the GetProcessoStaffing Aggregate Filter conditions should be as shown below..

From the shared screen prints, It is quite obvious that you are having a Search Input widget in the Listing screen, which is mapped with a local variable i.e. SearchKeyword

But If you want to filter on the basis of end-user Dropdown selection, you will have to use the local variable mapped with the respective Dropdown widget in the Aggregate Filter section to filter the aggregate records.


Hope this helps you!

Regards,

Benjith Sam

2021-03-18 21-03-15
Benjith Sam
 
MVP

Hi Giovanna Hortolã,

I create a sample application based on your requirement.

Check this:  Sample_Dropdown_Department_Filter_Reactive_App


PFA - includes the .oml solution file


Hope this helps you!


Regards,

Benjith Sam

DropdownFilterReactiveTestApp.oml
2026-01-26 20-55-56
Giovanna Hortolã

Benjith Sam wrote:

Hi Giovanna Hortolã,

I create a sample application based on your requirement.

Check this:  Sample_Dropdown_Department_Filter_Reactive_App


PFA - includes the .oml solution file


Hope this helps you!


Regards,

Benjith Sam

Hi Sam, 

I did that, but I still can't filter :( kk



2021-03-18 21-03-15
Benjith Sam
 
MVP

Giovanna Hortolã wrote:

Hi Sam, 

I did that, but I still can't filter :( kk

Please validate the implementation on the basis of below mentioned Steps

1) Check the respective Aggregate Filter condition

2) Define the onchange action to the filter Dropdown

3) The OnChange Handler (screen action) action flow, must contain the Refresh Data node/element

If possible, could you please share the .oml file or the action flow screen prints...


Regards,

Benjith Sam

2026-01-26 20-55-56
Giovanna Hortolã

Benjith Sam wrote:

Giovanna Hortolã escreveu:

Olá Sam, 

Eu fiz isso, mas ainda não consigo filtrar :( kk

Valide a implementação com base nas etapas abaixo mencionadas

1) Verifique a respectiva condição de filtro agregado

2) Defina a ação onchange no filtro suspenso

3) O fluxo de ação do OnChange  Handler (ação de tela) deve conter o nó / elemento Atualizar Dados

Se possível, compartilhe o arquivo .oml ou a tela do fluxo de ação será impressa ...


Saudações,

Benjith Sam

Sam, see below


2022-06-09 15-23-03
Orla Dijkink
 
MVP

Hi Giovanna,

Are you filtering on the value of the dropdown in you aggregate?

2026-01-26 20-55-56
Giovanna Hortolã

Orla Dijkink wrote:

Hi Giovanna,

Are you filtering on the value of the dropdown in you aggregate?

Hi Orla, 

I just sent in the topic above :)

2021-03-18 21-03-15
Benjith Sam
 
MVP

Sorry Giovanna, we need more information like Aggregate Name with Filter condition and Table Record Property screen prints to help you...

Regards,

Benjith Sam

2026-01-26 20-55-56
Giovanna Hortolã

Benjith Sam wrote:

Sorry Giovanna, we need more information like Aggregate Name with Filter condition and Table Record Property screen prints to help you...

Regards,

Benjith Sam

Sorry, look



2022-06-09 15-23-03
Orla Dijkink
 
MVP

If you are using traditional web, you also need an AJAX refresh of the table after refresh of the aggregate.

2026-01-26 20-55-56
Giovanna Hortolã

Orla Dijkink escreveu:

Se você estiver usando a Web tradicional, também precisará de uma atualização AJAX da tabela após a atualização do agregado.

I'm making the application react, does it interfere?

2022-06-09 15-23-03
Orla Dijkink
 
MVP

Giovanna Hortolã wrote:

Orla Dijkink escreveu:

Se você estiver usando a Web tradicional, também precisará de uma atualização AJAX da tabela após a atualização do agregado.

I'm making the application react, does it interfere?

I just saw it's react, in React you don't need/have Ajax. I will keep thinking!


2022-06-09 15-23-03
Orla Dijkink
 
MVP
Solution

You need to filer on the SolicitanteId on your aggreagte, now your only filtering on SearchKeyword.

You need something like:

SolicitanteId = nullidentifier() or SolicitanteId = <Your_Entity>.SolicitanteId

2021-03-18 21-03-15
Benjith Sam
 
MVP
Solution

As mentioned by Orla in the previous comment, the GetProcessoStaffing Aggregate Filter conditions should be as shown below..

From the shared screen prints, It is quite obvious that you are having a Search Input widget in the Listing screen, which is mapped with a local variable i.e. SearchKeyword

But If you want to filter on the basis of end-user Dropdown selection, you will have to use the local variable mapped with the respective Dropdown widget in the Aggregate Filter section to filter the aggregate records.


Hope this helps you!

Regards,

Benjith Sam

2026-01-26 20-55-56
Giovanna Hortolã

I put it like this, it worked

Thank you for helping me!!

@Orla and @Sam :)

2021-03-18 21-03-15
Benjith Sam
 
MVP

Giovanna Hortolã wrote:

I put it like this, it worked

Thank you for helping me!!

@Orla and @Sam :)

Kudos, you got it solved :)

You're welcome, Giovanna :)


Regards,

Benjith Sam

2020-10-12 05-46-33
Nikhil Gondane

Benjith Sam wrote:

Giovanna Hortolã wrote:

I put it like this, it worked

Thank you for helping me!!

@Orla and @Sam :)

Kudos, you got it solved :)

You're welcome, Giovanna :)


Regards,

Benjith Sam

 Thanks Benijith Sam , this solution is also help for me  .

 

2021-03-18 21-03-15
Benjith Sam
 
MVP

Nikhil Gondane wrote:

Thanks Benijith Sam , this solution is also help for me  .

 You're welcome, Nikhil :)

Glad it helped you :)


Regards,

Benjith Sam

2022-06-09 15-23-03
Orla Dijkink
 
MVP

No problem! Happy you got it working!

2022-02-08 09-40-14
Chandrashekhar Mankar

Helpful.

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