CBLQueryBuilder
@interface CBLQueryBuilder : NSObject
// SELECT > FROM
/**
Create a query from the select and from component.
@param select The select component reresenting the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from;
/**
Create a distinct query from the select and from component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from;
// SELECT > FROM > WHERE
/**
Create a query from the select, from, and where component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where;
/**
Create a distinct query from the select, from, and where component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where;
// SELECT > FROM > WHERE > ORDER BY
/**
Create a query from the select, from, where, and order by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
orderBy: (nullable NSArray<CBLQueryOrdering*>*)orderings;
/**
Create a distinct query from the select, from, where, and order by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
orderBy: (nullable NSArray<CBLQueryOrdering*>*)orderings;
// SELECT > FROM > WHERE > GROUP BY
/**
Create a query from the select, from, where, and group by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy;
/**
Create a distinct query from the select, from, where and group by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy;
// SELECT > FROM > WHERE > GROUP BY > HAVING
/**
Create a query from the select, from, where, groupby and having component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy
having: (nullable CBLQueryExpression*)having;
/**
Create a distinct query from the select, from, where, groupby and having component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy
having: (nullable CBLQueryExpression*)having;
// SELECT > FROM > WHERE > GROUP BY > HAVING > ORDER BY > LIMIT
/**
Create a query from the select, from, where, groupby, having, order by, and limit component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@param limit The limit component representing the LIMIT clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy
having: (nullable CBLQueryExpression*)having
orderBy: (nullable NSArray<CBLQueryOrdering*>*)orderings
limit: (nullable CBLQueryLimit*)limit;
/**
Create a distinct query from the select, from, where, groupby, having, order by,
and limit component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@param limit The limit component representing the LIMIT clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy
having: (nullable CBLQueryExpression*)having
orderBy: (nullable NSArray<CBLQueryOrdering*>*)orderings
limit: (nullable CBLQueryLimit*)limit;
// SELECT > FROM > JOIN
/**
Create a query from the select, from, and join component.
@param select The select component reresenting the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join;
/**
Create a distinct query from the select from, and join component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join;
// SELECT > FROM > JOIN > WHERE
/**
Create a query from the select, from, join and where component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where;
/**
Create a distinct query from the select, from, join and where component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where;
// SELECT > FROM > JOIN > WHERE > GROUP BY
/**
Create a query from the select, from, join, where, and group by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy;
/**
Create a distinct query from the select, from, join, where, and groupby component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy;
// SELECT > FROM > JOIN > WHERE > GROUP BY > HAVING
/**
Create a query from the select, from, join, where, grop by, and having component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy
having: (nullable CBLQueryExpression*)having;
/**
Create a distinct query from the select, from, join, where, gropu by and having component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where
groupBy: (nullable NSArray<CBLQueryExpression*>*)groupBy
having: (nullable CBLQueryExpression*)having;
// SELECT > FROM > JOIN > WHERE > ORDER BY
/**
Create a query from the select, from, join, where and order by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where
orderBy: (nullable NSArray<CBLQueryOrdering*>*)orderings;
/**
Create a distinct query from the select, from, join, where, and order by component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (CBLQueryDataSource*)from
join: (nullable NSArray<CBLQueryJoin*>*)join
where: (nullable CBLQueryExpression*)where
orderBy: (nullable NSArray<CBLQueryOrdering*>*)orderings;
// SELECT > FROM > JOIN > WHERE > GROUP BY > HAVING > ORDER BY > LIMIT
/**
Create a query from the select, from, join, where, group by, having, order by, and limit component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@param orderings The orderings components representing the ORDER BY clause of the query.
@param limit The limit component representing the LIMIT clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) select: (NSArray<CBLQuerySelectResult*>*)select
from: (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;
/**
Create a distinct query from the select, from, join, where, group by, having, order by and
limit component.
@param select The select component representing the SELECT clause of the query.
@param from The from component representing the FROM clause of the query.
@param join The join components representing the JOIN clause of the query.
@param where The where component representing the WHERE clause of the query.
@param groupBy The group by expressions representing the GROUP BY clause of the query.
@param having The having component representing the HAVING clause of the query.
@param orderings The ordering components representing the ORDER BY clause of the query.
@param limit The limit component representing the LIMIT clause of the query.
@return The CBLQuery instance.
*/
+ (CBLQuery*) selectDistinct: (NSArray<CBLQuerySelectResult*>*)select
from: (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;
/** Not available */
- (instancetype) init NS_UNAVAILABLE;
@end
Undocumented
-
Create a query from the select and from component.
Declaration
Objective-C
+ (nonnull CBLQuery *)select:(nonnull NSArray<CBLQuerySelectResult *> *)select from:(nonnull CBLQueryDataSource *)from;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource) -> CBLQuery
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.
-
Create a distinct query from the select and from component.
Declaration
Objective-C
+ (nonnull CBLQuery *)selectDistinct: (nonnull NSArray<CBLQuerySelectResult *> *)select from:(nonnull CBLQueryDataSource *)from;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?, limit: CBLQueryLimit?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?, limit: CBLQueryLimit?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?) -> CBLQuery
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.
-
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;
Swift
class func select(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?, limit: CBLQueryLimit?) -> CBLQuery
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.
-
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;
Swift
class func selectDistinct(_ select: [CBLQuerySelectResult], from: CBLQueryDataSource, join: [CBLQueryJoin]?, where: CBLQueryExpression?, groupBy: [CBLQueryExpression]?, having: CBLQueryExpression?, orderBy orderings: [CBLQueryOrdering]?, limit: CBLQueryLimit?) -> CBLQuery
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.
-
Not available
Declaration
Objective-C
- (nonnull instancetype)init;