I am working on a scenario, where I need to open a unity form with three dropdowns with cascading filtering. Below is the scenario:
- I have three workview classes : Dept, Role and User.
- Each Dept will have multiple roles. Role will be mapped to a single dept.
- Each Role will have multiple users. Each user will be mapped to one role
- There is another class Ticket. Ticket will be assigned to user (relationship with User class). I need to select multiple tickets in a ticket filter, click on Tasks tab at the top (to execute a system task) and open a Unity form for selection of User for assigning tickets to that user
- In this particular unity form, I want to have three keywords with dropdowns filled using external dataset (using sql query) and also want to have a cascading filtering.
- So, all departments will be filled in Dept keyword dropdown.
- Now, when a department is selected, I want the roles to be filtered for the selected department. Similarly, When a role is selected, I want the users to be filtered based on the selected role
- I have gone through the mrgs and SDK and also community site and found that for this I need to select External keyword dataset configuration with Unity script option and also check “Send existing keyword values from unity forms”
Looking for some sample code or any reference to SDK to implement this functionality.
Thanks
