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.