Attached is a method for implementing multiple metadata driven, dynamic drop-down boxes on a single task screen using PX and an external data source.
Disclaimer: It is important to mention that the attached policies could benefit from an architectural optimization pass or two. Please keep this in mind prior to consideration for any production deployment. I wrote these policies with an emphasis on demonstrating the steps required, not with an emphasis on performance.
Important Notes:
• “Office” is mapped to physical “roomNumber” in my development environment. Please update the attached policies to reference an attribute of your choosing prior to or after importing the _roles.xml. There are two references to this attribute within the attached policies. They are contained within PX100.00 and PX100.16.
• The attached CreateLocationsTable.sql script will execute on MS SQL server only. Sample data to populate this table can be found in the attached SampleLocationData.csv file.
• The “Data Source” data element contained within each applicable PX policy is in JBOSS (post SP6) format (e.g. java:/iam/im/jdbc/jdbc/imFormData). Please edit this value as necessary prior to importing the _roles.xml into your environment.
• After importing the _roles.xml into your environment, you will be required to assign the task “PX Demo - Multiple Dynamic Dropdown Lists” to an admin role of your choice for the task to display within the IME.