{"id":837,"date":"2020-11-02T15:29:12","date_gmt":"2020-11-02T21:29:12","guid":{"rendered":"https:\/\/asberry.org\/blog_tech\/?p=837"},"modified":"2024-05-14T09:13:25","modified_gmt":"2024-05-14T14:13:25","slug":"tcc-what-templates-are-active","status":"publish","type":"post","link":"https:\/\/asberry.org\/blog_tech\/?p=837","title":{"rendered":"TCC – What Templates Are Active"},"content":{"rendered":"\n

So this is specifically for job templates but can be adapted to anything that needs to find out what languages are active for any given situation.<\/p>\n\n\n

\n<?xml version="1.0" encoding="UTF-8"?>\n<quer:query productCode="RC1704" model="http:\/\/www.taleo.com\/ws\/tee800\/2009\/01" projectedClass="JobTemplate" 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\t\t\t<quer:field path="Number"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection>\n\t\t\t<quer:field path="JobCode"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection>\n\t\t\t<quer:field path="State,Description"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_fr">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="fr"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_en">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="en"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_es">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="es"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_de">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="de"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_it">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="it"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_nl">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="nl"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_fr_FR">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="fr-FR"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_en_GB">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="en-GB"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_zh_CN">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="zh-CN"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ja">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ja"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_pt_BR">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="pt-BR"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_sv">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="sv"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_da">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="da"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_pl">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="pl"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ru">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ru"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_fi">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="fi"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_cs">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="cs"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_zh_TW">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="zh-TW"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ko">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ko"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_th">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="th"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ms">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ms"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ca">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ca"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_tr">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="tr"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_sk">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="sk"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_et">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="et"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_no">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="no"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_bg">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="bg"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_hr">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="hr"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_hu">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="hu"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ro">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ro"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_el">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="el"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_sr">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="sr"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_lt">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="lt"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_pt">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="pt"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_sl">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="sl"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_in">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="in"\/>\n\t\t<\/quer:projection>\n\t\t<quer:projection alias="Lang_ar">\n\t\t\t<quer:field path="JobInformation,DescriptionActive" localeFiltering="customLocales" locales="ar"\/>\n\t\t<\/quer:projection>\n\t<\/quer:projections>\n\t<quer:projectionFilterings\/>\n\t<quer:filterings>\n\t\t<quer:filtering>\n\t\t\t<quer:equal>\n\t\t\t\t<quer:field path="State,Description"\/>\n\t\t\t\t<quer:string>Active<\/quer:string>\n\t\t\t<\/quer:equal>\n\t\t<\/quer:filtering>\n\t<\/quer:filterings>\n\t<quer:sortings>\n\t\t<quer:sorting ascending="true">\n\t\t\t<quer:field path="JobCode"\/>\n\t\t<\/quer:sorting>\n\t<\/quer:sortings>\n\t<quer:sortingFilterings\/>\n\t<quer:groupings\/>\n\t<quer:joinings\/>\n<\/quer:query>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
So this is specifically for job templates but can be adapted to anything that needs to find out what languages are active for any given situation.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","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-837","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-dv","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/837","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=837"}],"version-history":[{"count":1,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/837\/revisions"}],"predecessor-version":[{"id":838,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/837\/revisions\/838"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}