• State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 95 subscribers
  • Views 4685 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to create dependent dropdown column for ITshop request

ruchita.mantri
over 5 years ago

Hi,

I have 2 parameters in my request properties and both will be drop downs. One for UID_Person and one for UID_AERole. I want that user will select UID_Person first and then accordingly UID_AERole should be displayed. Meaning, I want user to select employee first and then show the roles the selected employee is holding. How can I implement this functionality?

Parents
  • +1 over 5 years ago

    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%')

Reply
  • +1 over 5 years ago

    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%')

Children