{"id":379,"date":"2015-09-21T11:28:07","date_gmt":"2015-09-21T16:28:07","guid":{"rendered":"https:\/\/linux.asberry.org\/blog_tech\/?p=379"},"modified":"2024-05-14T09:14:28","modified_gmt":"2024-05-14T14:14:28","slug":"tcc-candidate-eeodiversity-answers","status":"publish","type":"post","link":"https:\/\/asberry.org\/blog_tech\/?p=379","title":{"rendered":"TCC &#8211; Candidate EEO\/Diversity Answers"},"content":{"rendered":"<p>One of the more troublesome aspects of EEO is trying to figure out what a candidate entered as it&#8217;s masked on the front end and it&#8217;s really hard to tell.<\/p>\n<p>Create a file called CandidateDiversityAnswers_sq.xml<\/p>\n<p>Copy and paste the following to get everything that they&#8217;ve entered for EEO (please note this is from the standard EEO questions, not custom):<\/p>\n<pre class=\"brush: xml; light: false; title: ; toolbar: true; notranslate\" title=\"\">\r\n&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;\r\n&lt;quer:query productCode=&quot;RC1401&quot; model=&quot;http:\/\/www.taleo.com\/ws\/tee800\/2009\/01&quot; projectedClass=&quot;Candidate&quot; locale=&quot;en&quot; mode=&quot;CSV&quot; csvheader=&quot;true&quot; csvdelimiter=&quot;|&quot; csvquote=&quot;&amp;quot;&quot; largegraph=&quot;true&quot; preventDuplicates=&quot;false&quot; xmlns:quer=&quot;http:\/\/www.taleo.com\/ws\/integration\/query&quot;&gt;&lt;quer:subQueries\/&gt;&lt;quer:projections&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;Number&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;FirstName&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;LastName&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,Question,DiversityQuestion.RegulationForm,Number&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,Question,DiversityQuestion.RegulationForm,Code&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,Question,DiversityQuestion.RegulationForm,Name&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,Question,Number&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,Question,Code&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,Question,Name&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection alias=&quot;CreationDate&quot; projectedValueType=&quot;string&quot; projectedField=&quot;DiversityAnswers,RuntimeString:CreationDateFormatted&quot;&gt;&lt;quer:customFunction name=&quot;TO_CHAR&quot;&gt;&lt;quer:field path=&quot;DiversityAnswers,CreationDate&quot;\/&gt;&lt;quer:string&gt;yyyy-MM-dd&lt;\/quer:string&gt;&lt;\/quer:customFunction&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,PossibleAnswer,Number&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,PossibleAnswer,Sequence&quot;\/&gt;&lt;\/quer:projection&gt;&lt;quer:projection&gt;&lt;quer:field path=&quot;DiversityAnswers,PossibleAnswer,Description&quot;\/&gt;&lt;\/quer:projection&gt;&lt;\/quer:projections&gt;&lt;quer:projectionFilterings\/&gt;&lt;quer:filterings&gt;&lt;quer:filtering&gt;&lt;quer:equal&gt;&lt;quer:field path=&quot;Number&quot;\/&gt;&lt;quer:long&gt;348272&lt;\/quer:long&gt;&lt;\/quer:equal&gt;&lt;\/quer:filtering&gt;&lt;\/quer:filterings&gt;&lt;quer:sortings\/&gt;&lt;quer:sortingFilterings\/&gt;&lt;quer:groupings\/&gt;&lt;quer:joinings\/&gt;&lt;\/quer:query&gt;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>One of the more troublesome aspects of EEO is trying to figure out what a candidate entered as it&#8217;s masked on the front end and it&#8217;s really hard to tell. Create a file called CandidateDiversityAnswers_sq.xml Copy and paste the following to get everything that they&#8217;ve entered for EEO (please note this is from the standard [&hellip;]<\/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":"TCC - Candidate EEO\/Diversity Answers","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-379","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-67","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/379","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=379"}],"version-history":[{"count":2,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":381,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions\/381"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}