Monday, April 13, 2020

SQL to list Components with Drop Zones

PeopleTools 8.57 introduced the concept of Drop Zones in fluid components. Now with the latest release (PeopleTools 8.58), Drop Zone capability is available in classic components.

While the Drop Zone functionality is a PeopleTools feature, the Applications teams will need to deliver/enable Drop Zones in various components (both classic and fluid). We can find the list of delivered components by reviewing PeopleBooks for each application. As an example, here is the list for FSCM.

FSCM - Understanding Drop Zones

In an effort to quickly identify any delivered classic components with Drop Zones, I wrote a SQL that can be run against any database to list all components which contain Drop Zones along with the type (fluid/classic). Unfortunately, at the time of writing, I have not found any delivered Classic Components in HCM as well as FSCM. We may need to watch the next PUM images for examples of Classic Components with Drop Zones.

No comments:

Post a Comment