Capability

Description

QUERY

The connector implementation supports queries.

QUERY_BLACKBOX_JOIN

Supports the execution of queries that contain black box relations. However, a black box relation is a join relation that can only be interpreted by a connector; it is not a simple key comparison of type A.x=B.y, but may be a function name or some other string token. The source with this capability may or may not be able to process other join relationships according to other capabilities.

QUERY_CRITERIA_PREDICATE_ATTRIBUTE_EQUALS_CONSTANT

Supports only predicate criteria of the following type in the WHERE clause:

businessObject.attribute = CONSTANT

QUERY_FROM_INNERJOIN

Supports inner joins in the FROM clause of the query statement.

QUERY_CRITERIA_LOGICAL_AND

Supports compound criteria using AND as operator in the WHERE clause.

QUERY_CRITERIA_PREDICATE_SET

Supports the IN (<group of values>) predicate criteria in the WHERE clause. Sub queries as the set criteria are not supported.