Skip to main content

Query execution issues

For query execution issues, MDM dumps the parsed query structure (joins, where conditions). For example:

[SELECT]
        Types
                Person
        Selected fields
                [FIELD]
                        Person/firstname
                [FIELD]
                        Address/Street
                [FIELD]
                        Country/name
        Join
                [JOIN]
                        [LEFT]
                                [FIELD]
                                        addresses/address
 
                        [RIGHT]
                                [FIELD]
                                        Address/Id
                                        Address/enterprise
                [JOIN]
                        [LEFT]
                                [FIELD]
                                        Address/country
                        [RIGHT]
                                [FIELD]
                                        Country/id
        Condition
                <NONE>
        Order by
                <NONE>

Common causes of exceptions (full text queries):

  • The contains and full_text operands cannot be used together with other search operators. Since a full text search internally covers conditions from contains or full_text, these operands cannot be combined together.

Common causes of exceptions (all other queries):

  • Join is performed on a field that cannot be reached from the main selected type.
  • A IsEmptyOrNull is performed on a repeatable element.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!