Wednesday, August 5, 2015

TCC: Complete list of Filters and Functions

 

The Taleo Connect Client has a lot of filters to form queries, and a bigger bunch of functions which can be used in the export definition. Knowing the complete list of supported filters and functions will help when one has to write complex projections. Some of the functions are documented in the official TCC developers guide.

Here is the complete list of all filter criterion which TCC understands:

cleartext.blogspot.com

and
between
contains
containsIgnoreCase
customFilter
customLogicalOperator
customOperator
equal
equalAllowNull
excludedFrom
greaterThan
greaterThanOrEqual
hierarchicalContains
hierarchicalContainsOrWithin
hierarchicalWithin
includedIn
isFalse
isNotNull
isNull
isTrue
lessThan
lessThanOrEqual
like
likeIgnoreCase
matches
matchesIgnoreCase
not
notEqual
or
predefinedFilter
returnsResults
textuallyMatches
lrd

cleartext.blogspot.com

And here is the complete list of TCC Functions cleartext.blogspot.com

 

add
addDays
addMonths
addWeeks
addYears
allCustomFields
amount
anyQuery
average
boolean
castAsDate
castAsNumber
castAsTimestamp
classType
column
concatenate
count
currency
customFunction
customValue
date
decode
divide
double
field
firstValue
float
greatest
integer
key
lastValue
least
list
lobCompare
lobIndexOf
lobLength
lobSubstring
locale
long
maximum
minimum
multilingualColumn
multiply
nextValue
overRows
overValues
parameter
power
predefinedValue
previousValue
projection
replace
replaceNull
replaceNullOrNot
round
string
substring
subtract
subtractDate
sum
switchByCriterion
switchByValue
toChar
textAbout
textAnd
textCustom
textInPath
textNot
textOr
textWeight
textWithin
toEndOfTheDay
toLowerCase
toStartOfTheDay
toUpperCase
trim
truncate
undefined

 

Enjoy. cleartext.blogspot.com