So I found myself having to create an export for only UDF’s and had to code it for the type coming out of the custom dictionary so that if it was a string it would output just the field and if it was a date it would apply a TO_CHAR function along with a date specification. As I hang my head in shame I did it in Excel because I didn’t have time to write the Python version of it and inadvertently misspelled field.
To make a long story short the GUI threw an error saying this is the list of expected elements, I’m sure this is somewhere in an XSD but it’s now here for reference:
add
addDays
addMonths
addWeeks
addYears
allCustomFields
amount
intersect
minus
query
predefinedQuery
union
unionAllowDuplicates
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