that is the exact structure of my xml. so i'm sure that i receive it, but why it doesn't appear in the result of my query???
Please can you provide a link to your table definition and the query you are running.
The two usual causes of not seeing any output when you appear to have content are (1) An itemPath in the table that doesnt exist in the return structure (2) Applying a local filter in the WHERE clause that doesn't exist / can't match