Dependent DB dropdowns

Question

Can anyone help resolve the issue with

Dependent DB dropdowns?

I'm following this documentation but still not able to aplicate it - wiki.vertuna.com/display/CONFIFORMS/Working+with+Dependent+DB+dropdowns

I want to have dependent  EmployyMPK field based on the manager

I have 3 field:

1.

EmployeeManager - Field Definition

Database Dropdown Advanced

SQL code: select DISTINCT [Employee Manager] as id, [Employee Manager] from Employee

2.

EmployeeMPK - Field Definition

Database Dropdown Advanced

SQL code: select DISTINCT [Employee Manager], [Employee MPK],[Employee MPK] as EmployeeManagerMPK from Employee

3.

Rules for Field Definition

Condition: EmployeeManagerMPK:[entry.EmployeeManager.id]

Action to execute *: Applyu filter on a Field

Actionable field name: EmployeeManager

Alex Medved _ConfiForms_ · Answer

select DISTINCT [Employee MPK] as id, [Employee MPK], [Employee Manager] as EmployeeManagerMPK from Employee

Andrzej_9aqyeb · Answer

ah sorry if I wrongly placed this question.

The query is still not working properly, I'm getting the list of Employee Managers with this code but I need to have filtered MPK (assigned to the particular manager).

From you side the code and the approach looks correct?

Alex Medved _ConfiForms_ · Answer

Hi @Andrzej

Not sure why you have tagged this question with a "cloud" labels - there are no database fields in ConfiForms cloud...

Anyway, as the mentioned example suggests you NEED to have a cilumn named (aliased) to be either "id" or "entryId" for BOTH SQLs

So I believe the second SQL should be something like

select DISTINCT [Employee MPK] as id, [Employee Manager],[Employee MPK] as EmployeeManagerMPK from Employee

Alex