Retrieving Item Structure Based on Revision Number from Product Development Area

Su

Hi Experts,

We are currently working on a requirement to retrieve the item structure for a given item. Our query is built using the egp_structures_b and egp_components_b tables, which pull the structure as available in Product Information Management (PIM).

However, the client has a requirement to pull the item structure from the Product Development area, where there is an option to view the structure based on a selected Revision number. I have reviewed the ego_change_audit_entities and ego_change_audit_redline_attrs tables, but these do not provide all the changes between revisions.