Query results issues - 6.3

Troubleshooting for MDM SQL Storage

EnrichVersion
6.3
task
Installation and Upgrade
EnrichPlatform
Talend MDM Server

Note that selecting an XML element with no text content will always return an empty string.

As shown in the following example, the selected element, Features, is a wrapper element. The Query will return an XML element "Features" but with no content (XML database may do a value concatenation in this case).

<Product>
    <Features>
        <Colors>
            <Color>Blue</Color>
            <Color>Red</Color>
        </Colors>
    </Features>
</Product>