Class QueryBuilder

Simple salesforce SOQL builder

Hierarchy

QueryBuilderData
- QueryBuilder

Index

Constructors

Properties

Accessors

fields sobjectType where

Methods

clone execute executeTooling filter getQuery getSpec limit offset select selectRelated sortBy sortDirection validateFields clone parse

Constructors

constructor

new QueryBuilder(query): QueryBuilder
Parameters
- query: SalesforceQueryData
Returns QueryBuilder
Overrides QueryBuilderData.constructor
- Defined in packages/salesforce/src/queryBuilder.ts:66
new QueryBuilder(sobjectType, fieldList?): QueryBuilder
Parameters
- sobjectType: string
- Optional fieldList: string[]
Returns QueryBuilder
Overrides QueryBuilderData.constructor
- Defined in packages/salesforce/src/queryBuilder.ts:67

Properties

`Protected` `Readonly` query

query: SalesforceQueryData

Accessors

fields

get fields(): Iterable<string>
Returns Iterable<string>
Inherited from QueryBuilderData.fields
- Defined in packages/salesforce/src/queryBuilder.ts:20

sobjectType

get sobjectType(): string
Returns string
Inherited from QueryBuilderData.sobjectType
- Defined in packages/salesforce/src/queryBuilder.ts:24

where

get where(): QueryConditionBuilder
Returns QueryConditionBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:103

Methods

clone

clone(): QueryBuilder
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:91

execute

execute<T>(executor?): Promise<T[]>
Type Parameters
- T = any
Parameters
- Optional executor: SalesforceConnectionProvider | {
  query(q) => Promise<T[]>;
  }
Returns Promise<T[]>
Inherited from QueryBuilderData.execute
- Defined in packages/salesforce/src/queryBuilder.ts:28

executeTooling

executeTooling<T>(executor?): Promise<T[]>
Type Parameters
- T = any
Parameters
- Optional executor: SalesforceConnectionProvider | {
  queryTooling(q) => Promise<T[]>;
  }
Returns Promise<T[]>
Inherited from QueryBuilderData.executeTooling
- Defined in packages/salesforce/src/queryBuilder.ts:41

filter

filter(filter): QueryBuilder
Parameters
- filter: QueryFilterCondition
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:107

getQuery

getQuery(): string
Returns string
Inherited from QueryBuilderData.getQuery
- Defined in packages/salesforce/src/queryBuilder.ts:16

getSpec

getSpec(): SalesforceQueryData
Returns SalesforceQueryData
Inherited from QueryBuilderData.getSpec
- Defined in packages/salesforce/src/queryBuilder.ts:12

limit

limit(limit, offset?): QueryBuilder
Parameters
- limit: number
- Optional offset: number
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:131

offset

offset(offset): QueryBuilder
Parameters
- offset: number
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:139

select

select(...fields): QueryBuilder
Parameters
- Rest ...fields: (string | {
  name: string;
  })[]
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:112

selectRelated

selectRelated(relationName, fields): QueryBuilder
Parameters
- relationName: string
- fields: (string | {
  name: string;
  })[]
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:117

sortBy

sortBy(...sortFields): QueryBuilder
Parameters
- Rest ...sortFields: (string | {
  name: string;
  })[]
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:121

sortDirection

sortDirection(direction): QueryBuilder
Parameters
- direction: "asc" | "desc"
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:126

validateFields

validateFields(schema): Promise<string[]>
Validate queried fields and remove any unknown field from the query using the schema access provided
Parameters
- schema: SalesforceSchemaService
  
  Schema access
Returns Promise<string[]>
- Defined in packages/salesforce/src/queryBuilder.ts:76

`Static` clone

clone(query): QueryBuilder
Parameters
- query: QueryBuilder
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:95

`Static` parse

parse(query): QueryBuilder
Parameters
- query: string
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:99