Qore SalesforceRestDataProvider Module Reference 1.0.1
Loading...
Searching...
No Matches
SOQL Column Operators

Variables

const SalesforceRestDataProvider::DefaultSoqlCopMap
 a hash of default column operator descriptions
 
const SalesforceRestDataProvider::SOQL_COP_AVG = "avg"
 to return the average value More...
 
const SalesforceRestDataProvider::SOQL_COP_CALENDAR_MONTH = "calendar_month"
 to return the calendar month of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_CALENDAR_QUARTER = "calendar_quarter"
 to return the calendar quarter of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_CALENDAR_YEAR = "calendar_year"
 to return the calendar year of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_CONVERT_CURRENCY = "convert_currency"
 to return the given column value in the default currency for the calling user More...
 
const SalesforceRestDataProvider::SOQL_COP_COUNT = "count"
 to return the row count More...
 
const SalesforceRestDataProvider::SOQL_COP_COUNT_DISTINCT = "count_distinct"
 to return a count of distinct values More...
 
const SalesforceRestDataProvider::SOQL_COP_DAY_IN_MONTH = "day_in_month"
 to return the day in a month of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_DAY_IN_WEEK = "day_in_week"
 to return the day in the week of a date or date/time value (1 = Sunday, 7 = Saturday) More...
 
const SalesforceRestDataProvider::SOQL_COP_DAY_IN_YEAR = "day_in_year"
 to return the day in the year of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_DAY_ONLY = "day_only"
 to return the date from a date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_FISCAL_MONTH = "fiscal_month"
 to return the fiscal month of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_FISCAL_QUARTER = "fiscal_quarter"
 to return the fiscal quarter of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_FISCAL_YEAR = "fiscal_year"
 to return the fiscal year of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_FORMAT = "format"
 to return the given column value in the default locale for number, date, time, and currency fields More...
 
const SalesforceRestDataProvider::SOQL_COP_HOUR_IN_DAY = "hour_in_day"
 to return the hextern in the day of a date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_MAX = "max"
 to return the maximum value More...
 
const SalesforceRestDataProvider::SOQL_COP_MIN = "min"
 
const SalesforceRestDataProvider::SOQL_COP_SUM = "sum"
 to return the sum value More...
 
const SalesforceRestDataProvider::SOQL_COP_WEEK_IN_MONTH = "week_in_month"
 to return the week in the month of a date or date/time value More...
 
const SalesforceRestDataProvider::SOQL_COP_WEEK_IN_YEAR = "week_in_year"
 to return the week in the year of a date or date/time value More...
 

Detailed Description

These are the operators that can be used in the "columns" argument for select statements

Variable Documentation

◆ SOQL_COP_AVG

const SalesforceRestDataProvider::SOQL_COP_AVG = "avg"

to return the average value

See also
soql_cop_avg

◆ SOQL_COP_CALENDAR_MONTH

const SalesforceRestDataProvider::SOQL_COP_CALENDAR_MONTH = "calendar_month"

to return the calendar month of a date or date/time value

See also
soql_cop_calendar_month

◆ SOQL_COP_CALENDAR_QUARTER

const SalesforceRestDataProvider::SOQL_COP_CALENDAR_QUARTER = "calendar_quarter"

to return the calendar quarter of a date or date/time value

See also
soql_cop_calendar_quarter

◆ SOQL_COP_CALENDAR_YEAR

const SalesforceRestDataProvider::SOQL_COP_CALENDAR_YEAR = "calendar_year"

to return the calendar year of a date or date/time value

See also
soql_cop_calendar_year

◆ SOQL_COP_CONVERT_CURRENCY

const SalesforceRestDataProvider::SOQL_COP_CONVERT_CURRENCY = "convert_currency"

to return the given column value in the default currency for the calling user

See also
soql_cop_convert_currency

◆ SOQL_COP_COUNT

const SalesforceRestDataProvider::SOQL_COP_COUNT = "count"

to return the row count

See also
soql_cop_count

◆ SOQL_COP_COUNT_DISTINCT

const SalesforceRestDataProvider::SOQL_COP_COUNT_DISTINCT = "count_distinct"

to return a count of distinct values

See also
soql_cop_count_distinct

◆ SOQL_COP_DAY_IN_MONTH

const SalesforceRestDataProvider::SOQL_COP_DAY_IN_MONTH = "day_in_month"

to return the day in a month of a date or date/time value

See also
soql_cop_day_in_month

◆ SOQL_COP_DAY_IN_WEEK

const SalesforceRestDataProvider::SOQL_COP_DAY_IN_WEEK = "day_in_week"

to return the day in the week of a date or date/time value (1 = Sunday, 7 = Saturday)

See also
soql_cop_day_in_week

◆ SOQL_COP_DAY_IN_YEAR

const SalesforceRestDataProvider::SOQL_COP_DAY_IN_YEAR = "day_in_year"

to return the day in the year of a date or date/time value

See also
soql_cop_day_in_year

◆ SOQL_COP_DAY_ONLY

const SalesforceRestDataProvider::SOQL_COP_DAY_ONLY = "day_only"

to return the date from a date/time value

See also
soql_cop_day_only

◆ SOQL_COP_FISCAL_MONTH

const SalesforceRestDataProvider::SOQL_COP_FISCAL_MONTH = "fiscal_month"

to return the fiscal month of a date or date/time value

See also
soql_cop_fiscal_month

◆ SOQL_COP_FISCAL_QUARTER

const SalesforceRestDataProvider::SOQL_COP_FISCAL_QUARTER = "fiscal_quarter"

to return the fiscal quarter of a date or date/time value

See also
soql_cop_fiscal_quarter

◆ SOQL_COP_FISCAL_YEAR

const SalesforceRestDataProvider::SOQL_COP_FISCAL_YEAR = "fiscal_year"

to return the fiscal year of a date or date/time value

See also
soql_cop_fiscal_year

◆ SOQL_COP_FORMAT

const SalesforceRestDataProvider::SOQL_COP_FORMAT = "format"

to return the given column value in the default locale for number, date, time, and currency fields

See also
soql_cop_format

◆ SOQL_COP_HOUR_IN_DAY

const SalesforceRestDataProvider::SOQL_COP_HOUR_IN_DAY = "hour_in_day"

to return the hextern in the day of a date/time value

See also
soql_cop_hour_in_day

◆ SOQL_COP_MAX

const SalesforceRestDataProvider::SOQL_COP_MAX = "max"

to return the maximum value

See also
soql_cop_max

◆ SOQL_COP_MIN

const SalesforceRestDataProvider::SOQL_COP_MIN = "min"

to return the minimum value

See also
soql_cop_min

◆ SOQL_COP_SUM

const SalesforceRestDataProvider::SOQL_COP_SUM = "sum"

to return the sum value

See also
soql_cop_sum

◆ SOQL_COP_WEEK_IN_MONTH

const SalesforceRestDataProvider::SOQL_COP_WEEK_IN_MONTH = "week_in_month"

to return the week in the month of a date or date/time value

See also
soql_cop_week_in_month

◆ SOQL_COP_WEEK_IN_YEAR

const SalesforceRestDataProvider::SOQL_COP_WEEK_IN_YEAR = "week_in_year"

to return the week in the year of a date or date/time value

See also
soql_cop_week_in_year