Class QueryBuilder

Simple salesforce SOQL builder

Hierarchy

QueryBuilderData
- QueryBuilder

Index

Constructors

Properties

Accessors

fields sobjectType where

Methods

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

Constructors

constructor

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

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:24

sobjectType

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

where

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

Methods

clone

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

execute

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

executeTooling

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

filter

filter(
filter: QueryFilterCondition,
options?: { ignoreUndefined: boolean },
): this
Parameters
- filter: QueryFilterCondition
- Optionaloptions: { ignoreUndefined: boolean }
Returns this
- Defined in packages/salesforce/src/queryBuilder.ts:113

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

isSelected

isSelected(field: string): boolean
Parameters
- field: string
Returns boolean
- Defined in packages/salesforce/src/queryBuilder.ts:123

limit

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

offset

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

select

select(...fields: FieldReference[]): QueryBuilder
Parameters
- ...fields: FieldReference[]
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:118

selectRelated

selectRelated(relationName: string, fields: FieldReference[]): QueryBuilder
Parameters
- relationName: string
- fields: FieldReference[]
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:127

sortBy

sortBy(
sortFields: FieldReference | FieldReference[],
direction?: "asc" | "desc",
): QueryBuilder
Parameters
- sortFields: FieldReference | FieldReference[]
- Optionaldirection: "asc" | "desc"
Returns QueryBuilder
- Defined in packages/salesforce/src/queryBuilder.ts:131

sortDirection

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

toString

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

validateFields

validateFields(schema: SalesforceSchemaService): 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:82

`Static`clone

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

`Static`parse

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