You cannot select the CBR rank property and apply the DISTINCT keyword in a SQL statement when the object store property CBRQueryRankOverride is set to Required because the request for rank order is suppressed.

Namespace:  FileNet.Api.Exception
Assembly:  FileNet.Api (in FileNet.Api.dll)

ToggleSyntax

Visual Basic (Declaration)
Public Shared ReadOnly RETRIEVE_CANT_SELECT_DISTINCT_RANK_WITH_OVERRIDE_REQUIRED As ExceptionCode
C#
public static readonly ExceptionCode RETRIEVE_CANT_SELECT_DISTINCT_RANK_WITH_OVERRIDE_REQUIRED
Visual C++
public:
static initonly ExceptionCode^ RETRIEVE_CANT_SELECT_DISTINCT_RANK_WITH_OVERRIDE_REQUIRED
JavaScript
FileNet.Api.Exception.ExceptionCode.retrievE_CANT_SELECT_DISTINCT_RANK_WITH_OVERRIDE_REQUIRED

ToggleSee Also