***NOTE: wm_concat failed to function after the application of a patch in the 12c Oracle database. You can more or less use LISTAGG to replace this deprecated function for string aggregation.<\/p>\n
We’ve all had those times when we want to export the user types or groups and return the selections on the same line as opposed to each type and group on a different line. Yes you could use csv-entity export but that’s never a sure thing.\u00a0 You can use WM_CONCAT to pull the elements and stick them in the same column as comma separated value. This is a bit limited because you have include a grouping for every value not using WM_CONCAT.<\/p>\n
Here is a functional demonstration:<\/p>\n
Create an empty file named: UserExport-WM_CONCAT_sq.xml<\/p>\n
Add this code to the file:<\/p>\n
\u00a0<\/pre>\n\n\n<?xml version="1.0" encoding="UTF-8"?>\n<quer:query productCode="SO1704" model="http:\/\/www.taleo.com\/ws\/so800\/2009\/01" projectedClass="User" locale="en" mode="CSV" csvheader="true" largegraph="true" preventDuplicates="false" xmlns:quer="http:\/\/www.taleo.com\/ws\/integration\/query">\n\t<quer:subQueries\/>\n\t<quer:projections>\n\t\t<quer:projection>\n <quer:field path="UserAccount,Loginname"\/>\n <\/quer:projection>\n\t\t<quer:projection>\n <quer:field path="FirstName"\/>\n <\/quer:projection>\n\t\t<quer:projection>\n <quer:field path="LastName"\/>\n <\/quer:projection>\n\t\t<quer:projection>\n <quer:field path="CorrespondenceEmail"\/>\n <\/quer:projection>\n\t\t<quer:projection alias="UserTypeCode" projectedValueType="[C">\n <quer:customFunction name="wm_concat">\n <quer:field path="UserTypes,Code"\/>\n <\/quer:customFunction>\n<\/quer:projection>\n\t<\/quer:projections>\n\t<quer:projectionFilterings\/>\n\t<quer:filterings\/>\n\t<quer:sortings>\n\t\t<quer:sorting ascending="true">\n\t\t\t<quer:field path="LastName"\/>\n\t\t<\/quer:sorting>\n\t\t<quer:sorting ascending="true">\n\t\t\t<quer:field path="FirstName"\/>\n\t\t<\/quer:sorting>\n\t<\/quer:sortings>\n\t<quer:sortingFilterings\/>\n\t<quer:groupings>\n\t\t<quer:grouping>\n <quer:field path="UserAccount,Loginname"\/>\n <\/quer:grouping>\n\t\t<quer:grouping>\n <quer:field path="FirstName"\/>\n <\/quer:grouping>\n\t\t<quer:grouping>\n <quer:field path="LastName"\/>\n <\/quer:grouping>\n\t\t<quer:grouping>\n <quer:field path="CorrespondenceEmail"\/>\n <\/quer:grouping>\n\t<\/quer:groupings>\n\t<quer:joinings\/>\n<\/quer:query>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"***NOTE: wm_concat failed to function after the application of a patch in the 12c Oracle database. You can more or less use LISTAGG to replace this deprecated function for string aggregation. We’ve all had those times when we want to export the user types or groups and return the selections on the same line as […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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},"jetpack_post_was_ever_published":false},"categories":[13],"tags":[],"class_list":["post-529","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-8x","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/529","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=529"}],"version-history":[{"count":8,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/529\/revisions"}],"predecessor-version":[{"id":1152,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/529\/revisions\/1152"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}