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):
- Full text search includes conditions other than full text: this is a known limitation due to the technology used for full text searches. Operators supported with a full text search are: greater than (>), greater than or equals (>=), less than (<), less than or equals (<=).
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.