I would like to extract all the metadata that is associated with cabinet & how they are linked to each other. Is there a dql for this?
Not in a single DQL. Export the values you want to copy from cabinet and then use those values in UPDATE DQL against the document located within that cabinet. Since we dont know metadata field names from cabinet level and/or document level, its hard to show you how to do this.
If you provide an example, we can help you form a starter DQL that you could use.