Auto filtering database field

Andrzej_9aqyeb

Hello,

 

I need some help to filter/narrow down the output from the 'database advance field'.

I tried several ways like 'Applying filter on a field' or using smart classifier but it's still not working as expected.

Let's say I have some workers and I need to assign the proper manager to the given employee. How can I do it?

My sql statemant to retrives all employee (based on selected employee I need to assigne proper manager).

The scond field shoud also be dropdown or auto assigning value.

 

 

 

Sahir Maharaj_28wu8p

Hello @Andrzej

To dynamically filter and assign the appropriate manager to a selected employee, you can create a dependent dropdown field or use a smart classifier in your database interface.

I recommend to write a SQL query that retrieves the manager based on the employee’s department or role, ensuring the output is limited to relevant records.

If this setup isn’t functioning as expected, double-check the query logic and ensure the filtering criteria match the database schema.