152 "code":
string sub (
string cve,
auto arg) {
153 return sprintf(
"min(%s)", cve);
158 "code":
string sub (
string cve,
auto arg) {
159 return sprintf(
"max(%s)", cve);
164 "code":
string sub (
string cve,
auto arg) {
165 return sprintf(
"avg(%s)", cve);
170 "code":
string sub (
string cve,
auto arg) {
171 return sprintf(
"sum(%s)", cve);
176 "code":
string sub (*
string cve,
auto arg) {
177 return sprintf(
"count(%s)", cve);
181 "code":
string sub (
string cve,
auto arg) {
182 return sprintf(
"count_distinct %s", cve);
187 "code":
string sub (
string cve,
auto arg) {
188 return sprintf(
"format(%s)", cve);
192 "code":
string sub (
string cve,
auto arg) {
193 return sprintf(
"convertCurrency(%s)", cve);
197 "code":
string sub (
string cve,
auto arg) {
198 return sprintf(
"calendar_month(%s)", cve);
202 "code":
string sub (
string cve,
auto arg) {
203 return sprintf(
"calendar_quarter(%s)", cve);
207 "code":
string sub (
string cve,
auto arg) {
208 return sprintf(
"calendar_year(%s)", cve);
212 "code":
string sub (
string cve,
auto arg) {
213 return sprintf(
"day_in_month(%s)", cve);
217 "code":
string sub (
string cve,
auto arg) {
218 return sprintf(
"day_in_week(%s)", cve);
222 "code":
string sub (
string cve,
auto arg) {
223 return sprintf(
"day_in_year(%s)", cve);
227 "code":
string sub (
string cve,
auto arg) {
228 return sprintf(
"day_only(%s)", cve);
232 "code":
string sub (
string cve,
auto arg) {
233 return sprintf(
"fiscal_month(%s)", cve);
237 "code":
string sub (
string cve,
auto arg) {
238 return sprintf(
"fiscal_quarter(%s)", cve);
242 "code":
string sub (
string cve,
auto arg) {
243 return sprintf(
"fiscal_year(%s)", cve);
247 "code":
string sub (
string cve,
auto arg) {
248 return sprintf(
"hour_in_day(%s)", cve);
252 "code":
string sub (
string cve,
auto arg) {
253 return sprintf(
"week_in_month(%s)", cve);
257 "code":
string sub (
string cve,
auto arg) {
258 return sprintf(
"week_in_year(%s)", cve);
357 hash<SoqlColumnOperatorInfo>
soql_make_cop(
string cop,
auto column,
auto arg);
823 hash<string, hash<SoqlOperatorInfo>>
soql_wop_or(hash<auto> h1, hash<auto> h2);
830 "code":
string sub (
object i,
string cn,
auto arg) {
831 return sprintf(
"%s like %s", cn, arg);
835 "code":
string sub (
object i,
string cn,
auto arg) {
836 return sprintf(
"%s < %s", cn, arg);
840 "code":
string sub (
object i,
string cn,
auto arg) {
841 return sprintf(
"%s <= %s", cn, arg);
845 "code":
string sub (
object i,
string cn,
auto arg) {
846 return sprintf(
"%s > %s", cn, arg);
850 "code":
string sub (
object i,
string cn,
auto arg) {
851 return sprintf(
"%s >= %s", cn, arg);
855 "code":
string sub (
object i,
string cn,
auto arg) {
856 return sprintf(
"%s != %s", cn, arg);
860 "code":
string sub (
object i,
string cn,
auto arg) {
861 return sprintf(
"%s = %s", cn, arg);
865 "no_process_arg": True,
866 "code":
string sub (
object i,
string cn,
auto arg) {
867 *
string ins = (foldl $1 +
"," + $2, (map i.getArgValue(cn, $1), arg));
868 return sprintf(
"%s in (%s)", cn, ins);
872 "no_process_arg": True,
873 "code":
string sub (
object i,
string cn,
auto arg) {
874 *
string ins = (foldl $1 +
"," + $2, (map i.getArgValue(cn, $1), arg));
875 return sprintf(
"%s not in (%s)", cn, ins);
880 "code":
string sub (
object i,
string cn,
auto arg) {
881 return sprintf(
"not (%s)", cn);
885 "code":
string sub (
object i,
string cn, list<auto> arg) {
886 return i.getOrClause(arg);
const SOQL_COP_FISCAL_QUARTER
to return the fiscal quarter of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:127
const SOQL_COP_AVG
to return the average value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:57
const SOQL_COP_FISCAL_MONTH
to return the fiscal month of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:122
const SOQL_COP_CALENDAR_YEAR
to return the calendar year of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:97
const SOQL_COP_DAY_IN_WEEK
to return the day in the week of a date or date/time value (1 = Sunday, 7 = Saturday)
Definition: SalesforceRestDataProviderDefs.qc.dox.h:107
const DefaultSoqlCopMap
a hash of default column operator descriptions
Definition: SalesforceRestDataProviderDefs.qc.dox.h:150
const SOQL_COP_CALENDAR_QUARTER
to return the calendar quarter of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:92
const SOQL_COP_FORMAT
to return the given column value in the default locale for number, date, time, and currency fields
Definition: SalesforceRestDataProviderDefs.qc.dox.h:77
const SOQL_COP_MIN
Definition: SalesforceRestDataProviderDefs.qc.dox.h:47
const SOQL_COP_DAY_IN_YEAR
to return the day in the year of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:112
const SOQL_COP_COUNT
to return the row count
Definition: SalesforceRestDataProviderDefs.qc.dox.h:67
const SOQL_COP_CONVERT_CURRENCY
to return the given column value in the default currency for the calling user
Definition: SalesforceRestDataProviderDefs.qc.dox.h:82
const SOQL_COP_FISCAL_YEAR
to return the fiscal year of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:132
const SOQL_COP_CALENDAR_MONTH
to return the calendar month of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:87
const SOQL_COP_MAX
to return the maximum value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:52
const SOQL_COP_COUNT_DISTINCT
to return a count of distinct values
Definition: SalesforceRestDataProviderDefs.qc.dox.h:72
const SOQL_COP_WEEK_IN_MONTH
to return the week in the month of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:142
const SOQL_COP_HOUR_IN_DAY
to return the hextern in the day of a date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:137
const SOQL_COP_WEEK_IN_YEAR
to return the week in the year of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:147
const SOQL_COP_SUM
to return the sum value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:62
const SOQL_COP_DAY_ONLY
to return the date from a date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:117
const SOQL_COP_DAY_IN_MONTH
to return the day in a month of a date or date/time value
Definition: SalesforceRestDataProviderDefs.qc.dox.h:102
hash< SoqlOperatorInfo > soql_op_gt(auto arg)
returns an SoqlOperatorInfo hash for the ">" operator with the given argument for use in salesforce w...
hash< SoqlOperatorInfo > soql_op_not_in()
returns an SoqlOperatorInfo hash for the "not in" operator with all arguments passed to the function;...
hash< string, hash< SoqlOperatorInfo > > soql_wop_or(hash< auto > h1, hash< auto > h2)
returns an SoqlOperatorInfo hash with a fake "_OR_" column name; the list of arguments to the functio...
hash< SoqlOperatorInfo > soql_op_like(string str)
returns an SoqlOperatorInfo hash for the "like" operator with the given argument for use in salesforc...
hash< SoqlOperatorInfo > soql_op_lt(auto arg)
returns an SoqlOperatorInfo hash for the "<" operator with the given argument for use in salesforce w...
hash< SoqlOperatorInfo > soql_op_ne(auto arg)
returns an SoqlOperatorInfo hash for the "!=" or "<>" operator with the given argument for use in sal...
hash< SoqlOperatorInfo > soql_make_op(string op, auto arg)
hash< SoqlOperatorInfo > soql_op_ge(auto arg)
returns an SoqlOperatorInfo hash for the ">=" operator with the given argument for use in salesforce ...
hash< SoqlOperatorInfo > soql_op_not(hash arg)
returns an SoqlOperatorInfo hash for the "not" operator; for use in salesforce where clauses
hash< SoqlOperatorInfo > soql_op_in()
returns an SoqlOperatorInfo hash for the "in" operator with all arguments passed to the function; for...
hash< SoqlOperatorInfo > soql_op_le(auto arg)
returns an SoqlOperatorInfo hash for the "<=" operator with the given argument for use in salesforce ...
hash< SoqlOperatorInfo > soql_op_eq(auto arg)
returns an SoqlOperatorInfo hash for the "=" operator with the given argument for use in salesforce w...
const SOQL_OP_GE
the SOQL greater than or equals operator (>=) for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:299
const SOQL_OP_NOT_IN
the SOQL in operator for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:279
const SOQL_OP_EQ
the SOQL equals operator (=) for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:309
const SOQL_OP_NE
the SOQL not equals operator (!= or <>) for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:304
const SOQL_OP_IN
the SOQL in operator for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:274
const SOQL_OP_NOT
the SOQL "not" operator for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:314
const SOQL_OP_LT
the SOQL less than (<) operator for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:284
const SOQL_OP_LIKE
Definition: SalesforceRestDataProviderDefs.qc.dox.h:269
const SOQL_OP_GT
the SOQL greater than operator (>) for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:294
const SOQL_OP_OR
to combine SOQL expressions with "or" for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:319
const SOQL_OP_LE
the SOQL less than or equals (<=) operator for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:289
hash< SoqlColumnOperatorInfo > soql_cop_fiscal_year(auto column)
returns a SoqlColumnOperatorInfo hash for the "fiscal_year" function; returns the fiscal year for a d...
hash< SoqlColumnOperatorInfo > soql_cop_calendar_year(auto column)
returns a SoqlColumnOperatorInfo hash for the "calendar_year" function; returns the calendar year for...
hash< SoqlColumnOperatorInfo > soql_cop_fiscal_quarter(auto column)
returns a SoqlColumnOperatorInfo hash for the "fiscal_quarter" function; returns the fiscal quarter f...
hash< SoqlColumnOperatorInfo > soql_cop_count(auto column='')
returns a SoqlColumnOperatorInfo hash for the "count" aggregate function; returns row counts
hash< SoqlColumnOperatorInfo > soql_cop_day_only(auto column)
returns a SoqlColumnOperatorInfo hash for the "day_only" function; returns the date from a date/time ...
hash< SoqlColumnOperatorInfo > soql_cop_calendar_quarter(auto column)
returns a SoqlColumnOperatorInfo hash for the "calendar_quarter" function; returns the calendar quart...
hash< SoqlColumnOperatorInfo > soql_cop_convert_currency(auto column)
returns a SoqlColumnOperatorInfo hash for the "convertCurrency" operator; returns the given column va...
hash< SoqlColumnOperatorInfo > soql_cop_hour_in_day(auto column)
returns a SoqlColumnOperatorInfo hash for the "hour_in_day" function; returns the hextern in the day ...
hash< SoqlColumnOperatorInfo > soql_cop_day_in_year(auto column)
returns a SoqlColumnOperatorInfo hash for the "day_in_year" function; returns the day in the year for...
hash< SoqlColumnOperatorInfo > soql_make_cop(string cop, auto column, auto arg)
hash< SoqlColumnOperatorInfo > soql_cop_avg(auto column)
returns a SoqlColumnOperatorInfo hash for the "avg" operator; returns average column values
hash< SoqlColumnOperatorInfo > soql_cop_fiscal_month(auto column)
returns a SoqlColumnOperatorInfo hash for the "fiscal_month" function; returns the fiscal month for a...
hash< SoqlColumnOperatorInfo > soql_cop_count_distinct(auto column='')
returns a SoqlColumnOperatorInfo hash for the "count_distinct" aggregate function; returns row counts
hash< SoqlColumnOperatorInfo > soql_cop_format(auto column)
returns a SoqlColumnOperatorInfo hash for the "format" operator; returns the given column value in th...
hash< SoqlColumnOperatorInfo > soql_cop_week_in_year(auto column)
returns a SoqlColumnOperatorInfo hash for the "week_in_m=year" function; returns the week in the year...
hash< SoqlColumnOperatorInfo > soql_cop_day_in_month(auto column)
returns a SoqlColumnOperatorInfo hash for the "day_in_month" function; returns the day in the month f...
hash< SoqlColumnOperatorInfo > soql_cop_week_in_month(auto column)
returns a SoqlColumnOperatorInfo hash for the "week_in_month" function; returns the week in the month...
hash< SoqlColumnOperatorInfo > soql_cop_calendar_month(auto column)
returns a SoqlColumnOperatorInfo hash for the "calendar_month" function; returns the calendar month f...
hash< SoqlColumnOperatorInfo > soql_cop_min(auto column)
returns a SoqlColumnOperatorInfo hash for the "min" operator; returns minimum column values
hash< SoqlColumnOperatorInfo > soql_cop_sum(auto column)
returns a SoqlColumnOperatorInfo hash for the "sum" operator; returns the total sum of a numeric colu...
hash< SoqlColumnOperatorInfo > soql_cop_day_in_week(auto column)
returns a SoqlColumnOperatorInfo hash for the "day_in_week" function; returns the day in the week for...
hash< SoqlColumnOperatorInfo > soql_cop_max(auto column)
returns a SoqlColumnOperatorInfo hash for the "max" operator; returns maximum column values
Qore SalesforceRestDataProvider module definition.
Definition: SalesforceRestDataProvider.qc.dox.h:26
const DefaultSoqlOpMap
a hash of valid operators for use in where clauses
Definition: SalesforceRestDataProviderDefs.qc.dox.h:828
column operator info hash as returned by all column operator functions
Definition: SalesforceRestDataProviderDefs.qc.dox.h:34
auto arg
optional argument
Definition: SalesforceRestDataProviderDefs.qc.dox.h:37
auto column
column sopecifier, may be a string or a complex hash
Definition: SalesforceRestDataProviderDefs.qc.dox.h:36
string cop
the column operator string code
Definition: SalesforceRestDataProviderDefs.qc.dox.h:35
SOQL operator info hash as returned by all operator functions.
Definition: SalesforceRestDataProviderDefs.qc.dox.h:28
auto arg
optional argument
Definition: SalesforceRestDataProviderDefs.qc.dox.h:30
string op
the operator string code
Definition: SalesforceRestDataProviderDefs.qc.dox.h:29