[OutSystems Data Grid] Dependent Dropdowns

Back to Forums

Gonçalo Aguiar

Solved

Question

DataGrid

Reactive

Forge

Application Type

Reactive

Hi everyone,

I have a problem with the dependent dropdowns after I applied the fix to be able to display inactive values from this post.

https://www.outsystems.com/forums/discussion/95548/outsystems-data-grid-display-inactive-values-from-dropdown/

Previously I had Sample_Employee.Department that was an Id and now had to change to a label to display inactive departments in the table but not in the dropdown.

Now the column Employee dropdown only works after the Department is selected again.

Tryed several things for the ParentId:

If I use Sample_Department.Id or Sample_Employee.Department the dropdown is empty but works after changing the Department.

If I use Sample_Department.Name it will show the records in dropdown but not after I change the Department, so its the reverse.

What is the proper way to have the dependent dropdowns and also be able to display inactive values that are not shown in the dropdown selection?

Thanks.

Regards,

Gonçalo Aguiar

15 Mar 2024

Chris Andre Sitompul

Solution

Hi @Gonçalo Aguiar,

You can follow some steps like these:

Put join to Department when fetching the employee data to Grid, so you get the Department Name and put it as the binding for department column.
When create the dropdown list for Employee, you need to join with Department table then you can assign the value like these:
When create the dropdown list for Department, here I already filter the dropdown list to not showing the "Services"
4. Don't forget to assign the parent binding in Employee data grid column

You can refer to this OML also.

DropdownDatagrid.oml

18 Mar 2024

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

See the full guidelines