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

Inserting images in BIP templates for HTML output

 

Just documenting a BIP trick to insert images when the output will be in HTML. Time to time, report designers have to embed static images like logos or emblems on reports which have to be rendered along with the final output. Simply inserting the image into the RTF template will work fine if the output is in RTF or PDF format, but the images will be blank if the output is in HTML. This is , of course, because HTML does not embed the image, it just adds the the url reference to the image. Here is how to place an image in the RTF template so that it renders properly no matter what the output format.

cleartext.blogspot.com

First of all, you will have to place the image to be rendered in a public server somewhere, this can be anywhere on the internet which can be accessed via a url. Do not place this image on any server behind corporate firewalls,or it won't be rendered.

cleartext.blogspot.com

 

1: First, enable 'Developer Mode' in your Word. For this, go to File->Options->Cutomize Ribbon, and check the box next to 'Developer' in 'Main Tabs':

2: Now under the new 'Developer' tab, click on 'Design Mode'

3: Now, from under "Legacy forms", choose the image holder: cleartext.blogspot.com

4: This will put a nice grey square in your template. Right click that,  choose 'Format Control' , and go to 'Alt Text'

5: Under the alternative text, insert the url to the final image to be rendered.  cleartext.blogspot.com

6: Thats it ! Now when you generate the output of this template, the image will be rendered properly in any output format, including HTML.

7: Bonus ! You can even add a unique URL to the image, so that when it it clicked, the user it re-directed to another website. For this, right click the image (or grey square) and choose hyperlink. Insert the url in the hyperlink box. The re-direction also works regardless of output type.

cleartext.blogspot.com

 

Cheers !