Log in to AnswerLog in to Follow
2021-08-02 14-24-41
Giovanna Hortolã
614Views
19Comments
Solved
Filter in DropDown
Question
Usability

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 :)

0
0
19 May 2020
2022-06-09 15-23-03
Orla Dijkink
mvp_badge
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

See solution in context
1
0
19 May 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

See solution in context
1
0
19 May 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

2
0
19 May 2020

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



0
0
19 May 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

1
0
19 May 2020

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


0
0
19 May 2020
2022-06-09 15-23-03
Orla Dijkink
mvp_badge
MVP

Hi Giovanna,

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

1
0
19 May 2020

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 :)

0
0
19 May 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

0
0
19 May 2020

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



0
0
19 May 2020
2022-06-09 15-23-03
Orla Dijkink
mvp_badge
MVP

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

0
0
19 May 2020

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?

0
0
19 May 2020
2022-06-09 15-23-03
Orla Dijkink
mvp_badge
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!


0
0
19 May 2020
2022-06-09 15-23-03
Orla Dijkink
mvp_badge
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

1
0
19 May 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

1
0
19 May 2020

I put it like this, it worked

Thank you for helping me!!

@Orla and @Sam :)

1
0
19 May 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

1
0
19 May 2020

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  .

 

0
0
07 Aug 2020
2021-03-18 21-03-15
Benjith Sam
mvp_badge
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

0
0
07 Aug 2020
2022-06-09 15-23-03
Orla Dijkink
mvp_badge
MVP

No problem! Happy you got it working!

1
0
19 May 2020

Helpful.

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