Interface ContentQueryService


  • public interface ContentQueryService
    A service managing the creation and execution of ContentQuerys.
    • Method Detail

      • builder

        ContentQueryBuilder builder()
        Creates a new ContentQueryBuilder used to build a ContentQuery.
        Returns:
        a new ContentQueryBuilder
      • sqlPredicate

        Predicate sqlPredicate​(String sql,
                               Object... parameters)
        Creates a Predicate for a SQL-expression, optionally including parameters.

        The SQL-statement will be embedded literally into the SQL-statement used for the ContentQuery, and must be on a format suitable for such embedding, for example "AND oi1.document_id=?". Use question marks to indicate parameter placeholder, and add one parameter per placeholder.

        Currently only supported as part of the where clause.

        Parameters:
        sql - the SQL-statement to use
        parameters - parameters for the SQL-statement
        Returns:
        a new Predicate
      • contentExpression

        ContentExpression contentExpression()
        Creates an expression for a text search in all fields indexed by Oracle Text.
        Returns:
        a new Expression
      • dimensionReferenceExpression

        DimensionReferenceExpression dimensionReferenceExpression()
        Creates an expression used to search in any and all dimension references.
        Returns:
        a new Expression.
      • validityExpression

        DatePeriodExpression validityExpression()
        Creates an expression for a validity period search.
        Returns:
        a new Expression.
      • stringExpression

        StringExpression stringExpression​(String externalKey)
        Creates an expression for a given String attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • numberExpression

        NumberExpression numberExpression​(String externalKey)
        Creates an expression for a given number attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • dateExpression

        DateExpression dateExpression​(String externalKey)
        Creates an expression for a date attribute or attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • fileExpression

        FileExpression fileExpression​(String externalKey)
        Creates an expression for a given file attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • xmlExpression

        XmlExpression xmlExpression​(String externalKey)
        Creates an expression for a given XML attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • objectReferenceExpression

        ObjectReferenceExpression objectReferenceExpression​(String externalKey)
        Creates an expression for a given object reference attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • dimensionReferenceExpression

        DimensionReferenceExpression dimensionReferenceExpression​(String externalKey)
        Creates an expression for a given dimension reference attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • documentReferenceExpression

        DocumentReferenceExpression documentReferenceExpression​(String externalKey)
        Creates an expression for a given document reference attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • userReferenceExpression

        UserReferenceExpression userReferenceExpression​(String externalKey)
        Creates an expression for a given user reference attribute, field or function.
        Parameters:
        externalKey - external key of the attribute.
        Returns:
        a new Expression.
      • sqlFunctionBuilder

        SqlFunctionBuilder sqlFunctionBuilder()
        Creates a new builder for creating SqlFunction objects
        Returns:
        a new SqlFunctionBuilder
      • objectFunction

        <T> ObjectExpressionType<T> objectFunction​(String name,
                                                   Function<ContentQueryRow,​T> function)
        Creates a new ObjectExpressionType for a function identified by name.
        Parameters:
        name - name of the function
        Returns:
        a new ObjectExpressionType