CBLQueryBuilder Class Reference


                    
                    
                    +select:from:

Create a query from the select and from component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from;

Parameters

`select`	The select component reresenting the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:

Create a distinct query from the select and from component.

Declaration

Objective-C

+ (nonnull CBLQuery *)selectDistinct:
                          (nonnull NSArray<CBLQuerySelectResult *> *)select
                                from:(nonnull CBLQueryDataSource *)from;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:where:

Create a query from the select, from, and where component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                       where:(nullable CBLQueryExpression *)where;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:where:

Create a distinct query from the select, from, and where component.

Declaration

Objective-C

+ (nonnull CBLQuery *)selectDistinct:
                          (nonnull NSArray<CBLQuerySelectResult *> *)select
                                from:(nonnull CBLQueryDataSource *)from
                               where:(nullable CBLQueryExpression *)where;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:where:orderBy:

Create a query from the select, from, where, and order by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                       where:(nullable CBLQueryExpression *)where
                     orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:where:orderBy:

Create a distinct query from the select, from, where, and order by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
         where:(nullable CBLQueryExpression *)where
       orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:where:groupBy:

Create a query from the select, from, where, and group by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                       where:(nullable CBLQueryExpression *)where
                     groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:where:groupBy:

Create a distinct query from the select, from, where and group by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
         where:(nullable CBLQueryExpression *)where
       groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:where:groupBy:having:

Create a query from the select, from, where, groupby and having component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                       where:(nullable CBLQueryExpression *)where
                     groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
                      having:(nullable CBLQueryExpression *)having;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:where:groupBy:having:

Create a distinct query from the select, from, where, groupby and having component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
         where:(nullable CBLQueryExpression *)where
       groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
        having:(nullable CBLQueryExpression *)having;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:where:groupBy:having:orderBy:limit:

Create a query from the select, from, where, groupby, having, order by, and limit component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                       where:(nullable CBLQueryExpression *)where
                     groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
                      having:(nullable CBLQueryExpression *)having
                     orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings
                       limit:(nullable CBLQueryLimit *)limit;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.
`limit`	The limit component representing the LIMIT clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:where:groupBy:having:orderBy:limit:

Create a distinct query from the select, from, where, groupby, having, order by, and limit component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
         where:(nullable CBLQueryExpression *)where
       groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
        having:(nullable CBLQueryExpression *)having
       orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings
         limit:(nullable CBLQueryLimit *)limit;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.
`limit`	The limit component representing the LIMIT clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:join:

Create a query from the select, from, and join component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                        join:(nullable NSArray<CBLQueryJoin *> *)join;

Parameters

`select`	The select component reresenting the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:join:

Create a distinct query from the select from, and join component.

Declaration

Objective-C

+ (nonnull CBLQuery *)selectDistinct:
                          (nonnull NSArray<CBLQuerySelectResult *> *)select
                                from:(nonnull CBLQueryDataSource *)from
                                join:(nullable NSArray<CBLQueryJoin *> *)join;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:join:where:

Create a query from the select, from, join and where component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                        join:(nullable NSArray<CBLQueryJoin *> *)join
                       where:(nullable CBLQueryExpression *)where;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:join:where:

Create a distinct query from the select, from, join and where component.

Declaration

Objective-C

+ (nonnull CBLQuery *)selectDistinct:
                          (nonnull NSArray<CBLQuerySelectResult *> *)select
                                from:(nonnull CBLQueryDataSource *)from
                                join:(nullable NSArray<CBLQueryJoin *> *)join
                               where:(nullable CBLQueryExpression *)where;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:join:where:groupBy:

Create a query from the select, from, join, where, and group by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                        join:(nullable NSArray<CBLQueryJoin *> *)join
                       where:(nullable CBLQueryExpression *)where
                     groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:join:where:groupBy:

Create a distinct query from the select, from, join, where, and groupby component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
          join:(nullable NSArray<CBLQueryJoin *> *)join
         where:(nullable CBLQueryExpression *)where
       groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:join:where:groupBy:having:

Create a query from the select, from, join, where, grop by, and having component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                        join:(nullable NSArray<CBLQueryJoin *> *)join
                       where:(nullable CBLQueryExpression *)where
                     groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
                      having:(nullable CBLQueryExpression *)having;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:join:where:groupBy:having:

Create a distinct query from the select, from, join, where, gropu by and having component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
          join:(nullable NSArray<CBLQueryJoin *> *)join
         where:(nullable CBLQueryExpression *)where
       groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
        having:(nullable CBLQueryExpression *)having;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:join:where:orderBy:

Create a query from the select, from, join, where and order by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                        join:(nullable NSArray<CBLQueryJoin *> *)join
                       where:(nullable CBLQueryExpression *)where
                     orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:join:where:orderBy:

Create a distinct query from the select, from, join, where, and order by component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
          join:(nullable NSArray<CBLQueryJoin *> *)join
         where:(nullable CBLQueryExpression *)where
       orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +select:from:join:where:groupBy:having:orderBy:limit:

Create a query from the select, from, join, where, group by, having, order by, and limit component.

Declaration

Objective-C

+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select
                        from:(nonnull CBLQueryDataSource *)from
                        join:(nullable NSArray<CBLQueryJoin *> *)join
                       where:(nullable CBLQueryExpression *)where
                     groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
                      having:(nullable CBLQueryExpression *)having
                     orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings
                       limit:(nullable CBLQueryLimit *)limit;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.
`orderings`	The orderings components representing the ORDER BY clause of the query.
`limit`	The limit component representing the LIMIT clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    +selectDistinct:from:join:where:groupBy:having:orderBy:limit:

Create a distinct query from the select, from, join, where, group by, having, order by and limit component.

Declaration

Objective-C

+ (nonnull CBLQuery *)
selectDistinct:(nonnull NSArray<CBLQuerySelectResult *> *)select
          from:(nonnull CBLQueryDataSource *)from
          join:(nullable NSArray<CBLQueryJoin *> *)join
         where:(nullable CBLQueryExpression *)where
       groupBy:(nullable NSArray<CBLQueryExpression *> *)groupBy
        having:(nullable CBLQueryExpression *)having
       orderBy:(nullable NSArray<CBLQueryOrdering *> *)orderings
         limit:(nullable CBLQueryLimit *)limit;

Parameters

`select`	The select component representing the SELECT clause of the query.
`from`	The from component representing the FROM clause of the query.
`join`	The join components representing the JOIN clause of the query.
`where`	The where component representing the WHERE clause of the query.
`groupBy`	The group by expressions representing the GROUP BY clause of the query.
`having`	The having component representing the HAVING clause of the query.
`orderings`	The ordering components representing the ORDER BY clause of the query.
`limit`	The limit component representing the LIMIT clause of the query.

Return Value

The CBLQuery instance.


                    
                    
                    -init

Not available

Declaration

Objective-C

- (nonnull instancetype)init;