How to create dependent dropdown column for ITshop request

Hi,

This cannot be defined in the request property data model. You will have to build a UI component that knows about the dependency.

HTH

Can I not add in the condition of second parameter and add first parameter reference in where clause?

No

I think you might be able to do some filtering in the request properties. IF you define a request property in a UID, I believe the system allows you to set a filter, although it won't be a drop-down instead the control will be a picker

e.g.

If you column is CCC_UID_Person, then the filter on CCC_UID_AERole will be something like UID_AERole IN (Select UID_AERole from PersonInAERole where UID_Person='%CCC_UID_Person%')

Thank you so much Kinshasa. I tried this now and it worked. Thanks again :-)