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.<\/p>\n
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:<\/p>\n
<\/p>\n
add
\naddDays
\naddMonths
\naddWeeks
\naddYears
\nallCustomFields
\namount
\nintersect
\nminus
\nquery
\npredefinedQuery
\nunion
\nunionAllowDuplicates
\naverage
\nboolean
\ncastAsDate
\ncastAsNumber
\ncastAsTimestamp
\nclassType
\ncolumn
\nconcatenate
\ncount
\ncurrency
\ncustomFunction
\ncustomValue
\ndate
\ndecode
\ndivide
\ndouble
\nfield
\nfirstValue
\nfloat
\ngreatest
\ninteger
\nkey
\nlastValue
\nleast
\nlist
\nlobCompare
\nlobIndexOf
\nlobLength
\nlobSubstring
\nlocale
\nlong
\nmaximum
\nminimum
\nmultilingualColumn
\nmultiply
\nnextValue
\noverRows
\noverValues
\nparameter
\npower
\npredefinedValue
\npreviousValue
\nprojection
\nreplace
\nreplaceNull
\nreplaceNullOrNot
\nround
\nstring
\nsubstring
\nsubtract
\nsubtractDate
\nsum
\nswitchByCriterion
\nswitchByValue
\ntoChar
\ntextAbout
\ntextAnd
\ntextCustom
\ntextInPath
\ntextNot
\ntextOr
\ntextWeight
\ntextWithin
\ntoEndOfTheDay
\ntoLowerCase
\ntoStartOfTheDay
\ntoUpperCase
\ntrim
\ntruncate
\nundefined<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[],"class_list":["post-642","post","type-post","status-publish","format-standard","hentry","category-tcc","author-aron"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4bBkH-am","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=642"}],"version-history":[{"count":1,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions"}],"predecessor-version":[{"id":643,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions\/643"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}