Filter

[keith21]

Hi,
I just want to find out, if I select one field that is a database join. It should then filter out all user in another field called keys works. The key works is another database join linked by property id to the property table. Please see picture.

Thanks in advance

 

[troester]

Have a look at the cascading dropdown element.

 

[keith21]

I have done that, although it only show the ID number of that feild. How can I then do a join to that table to show the name off that person rather than the ID?

Thanks
Keith

 

[keith21]

This is my sql query for {subi___AreaManager} field
where do I need to place it to show, as it only show the ID at the moment ?

SELECT
enbi.ENID,
enbi.KnownAsName
FROM opsmanager
INNER JOIN prbi
ON opsmanager.ID = prbi.AreaManager
INNER JOIN enbi
ON opsmanager.ENID = enbi.ID
WHERE prbi.PRID = '' <---- this should be my {subi___AreaManager}

I am using a cascading join as its Watch element is the PRID