{"id":313,"date":"2015-01-25T12:12:43","date_gmt":"2015-01-25T18:12:43","guid":{"rendered":"https:\/\/linux.asberry.org\/blog_tech\/?p=313"},"modified":"2024-05-14T09:14:53","modified_gmt":"2024-05-14T14:14:53","slug":"projections-export-transitions","status":"publish","type":"post","link":"https:\/\/asberry.org\/blog_tech\/?p=313","title":{"rendered":"Projections Export Transitions"},"content":{"rendered":"<p>Transitions is easy to export out of because of the fact you build every filed that you need. \u00a0Unfortunately you sometimes have to dig it out of the candidate data if it&#8217;s a question they answered. Here is the code to do just that.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: xml; light: false; title: ; toolbar: true; notranslate\" title=\"\">\r\n&lt;quer:projection id=&quot;idReturnField&quot; alias=&quot;Header_Alias&quot; xmlns:quer=&quot;http:\/\/www.taleo.com\/ws\/integration\/query&quot;&gt;\r\n  &lt;quer:query projectedClass=&quot;TransitionProcess&quot; alias=&quot;Transition_Item_Id&quot;&gt;\r\n    &lt;quer:projections&gt;\r\n      &lt;quer:projection alias=&quot;Transition_Item_Id&quot;&gt;\r\n        &lt;quer:decode&gt;\r\n          &lt;quer:field path=&quot;ProfileInformation,Candidate,QuestionAnswers,Answer,Number&quot;\/&gt;\r\n          &lt;quer:string&gt;&#x5B;AnsNo]&lt;\/quer:string&gt;\r\n          &lt;quer:string&gt;YES&lt;\/quer:string&gt;\r\n          &lt;quer:string&gt;&#x5B;AnsNo]&lt;\/quer:string&gt;\r\n          &lt;quer:string&gt;NO&lt;\/quer:string&gt;\r\n          &lt;quer:string&gt;NA&lt;\/quer:string&gt;\r\n        &lt;\/quer:decode&gt;\r\n      &lt;\/quer:projection&gt;\r\n    &lt;\/quer:projections&gt;\r\n    &lt;quer:filterings&gt;\r\n      &lt;quer:filtering&gt;\r\n        &lt;quer:equal&gt;\r\n          &lt;quer:field path=&quot;ProfileInformation,Candidate,QuestionAnswers,Question,Code&quot;\/&gt;\r\n          &lt;quer:string&gt;&#x5B;QuesCode]&lt;\/quer:string&gt;\r\n        &lt;\/quer:equal&gt;\r\n      &lt;\/quer:filtering&gt;\r\n      &lt;quer:filtering&gt;\r\n        &lt;quer:equal&gt;\r\n          &lt;quer:field path=&quot;Number&quot;\/&gt;\r\n          &lt;quer:field ownerQuery=&quot;MainQuery&quot; path=&quot;Number&quot;\/&gt;\r\n        &lt;\/quer:equal&gt;\r\n      &lt;\/quer:filtering&gt;\r\n    &lt;\/quer:filterings&gt;\r\n  &lt;\/quer:query&gt;\r\n&lt;\/quer:projection&gt;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Transitions is easy to export out of because of the fact you build every filed that you need. \u00a0Unfortunately you sometimes have to dig it out of the candidate data if it&#8217;s a question they answered. Here is the code to do just that. &nbsp; &lt;quer:projection id=&quot;idReturnField&quot; alias=&quot;Header_Alias&quot; xmlns:quer=&quot;http:\/\/www.taleo.com\/ws\/integration\/query&quot;&gt; &lt;quer:query projectedClass=&quot;TransitionProcess&quot; alias=&quot;Transition_Item_Id&quot;&gt; &lt;quer:projections&gt; &lt;quer:projection alias=&quot;Transition_Item_Id&quot;&gt; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_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":"Projections Export Transitions","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-313","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-53","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/313","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=313"}],"version-history":[{"count":3,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/313\/revisions"}],"predecessor-version":[{"id":316,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/313\/revisions\/316"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}