Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#641837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#641837)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#641838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#641838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#641839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#641839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#641840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#641840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#641841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#641841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#641842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#641842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#641843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#641843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#641844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#641844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#641845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#641845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#641846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#641846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#641847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#641847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#641848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#641848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#641849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#641849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#641850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#641850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#641851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#641851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#641852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#641852)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#641853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#641853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#641854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#641854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#641855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#641855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#641856)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#641856)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#641857)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#641857)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#641858)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#641858)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#641859)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#641859)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#641860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#641860)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#641861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#641861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#641862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#641862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#641863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#641863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#641864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#641864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#641865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#641865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#641866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#641866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#641867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#641867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#641868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#641868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#641869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#641869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#641870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#641870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#641871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#641871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#641872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#641872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#641873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#641873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#641874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#641874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#641875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#641875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#641876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#641876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#641877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#641877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#641878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#641878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#641879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#641879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#641880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_available#641880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#641881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#641881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#641882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#641882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#641883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#641883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#641884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#641884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#641885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#641885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#641886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#641886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#641887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#641887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#641888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#641888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#641889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#641889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#641890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#641890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#641891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#641891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#641892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#641892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#641893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_later#641893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#641894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_position#641894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#641895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#641895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#641896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#641896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#641897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#641897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#641898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#641898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#641899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#641899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#641900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#641900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#641901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#641901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#641902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#641902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#641903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#641903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#641904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#641904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#641905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#641905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#641906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#641906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#641907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#641907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#641908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#641908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#641909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#641909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#641910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#641910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#641911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#641911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#641912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#641912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#641913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#641913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#641914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#641914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#641915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#641915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#641916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#641916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#641917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#641917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#641918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#641918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#641919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#641919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#641920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#641920)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#641921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#641921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#641922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#641922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#641923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#641923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#641924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#641924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#641925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#641925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#641926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#641926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#641927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#641927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)
Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#643801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#643801)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#643802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#643802)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#643803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#643803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#643804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#643804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#643805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#643805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#643806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#643806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#643807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#643807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#643808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#643808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#643809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#643809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#643810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#643810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#643811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#643811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#643812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#643812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#643813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#643813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#643814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#643814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#643815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#643815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#643816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#643816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#643817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#643817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#643818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#643818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#643819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#643819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#643820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#643820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#643821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#643821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#643822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#643822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#643823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#643823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#643824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#643824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#643825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#643825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#643826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#643826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#643827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#643827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#643828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#643828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#643829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#643829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#643830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#643830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#643831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#643831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#643832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#643832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#643833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#643833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#643834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#643834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#643835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#643835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#643836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#643836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#643837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#643837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#643838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#643838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#643839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#643839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#643840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#643840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#643841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#643841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#643842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#643842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#643843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#643843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#643844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_available#643844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#643845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#643845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#643846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#643846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#643847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#643847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#643848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#643848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#643849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#643849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#643850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#643850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#643851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#643851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#643852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#643852)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#643853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#643853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#643854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#643854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#643855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#643855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#643856)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#643856)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#643857)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_later#643857)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#643858)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_position#643858)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#643859)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#643859)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#643860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#643860)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#643861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#643861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#643862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#643862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#643863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#643863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#643864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#643864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#643865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#643865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#643866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#643866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#643867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#643867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#643868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#643868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#643869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#643869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#643870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#643870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#643871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#643871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#643872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#643872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#643873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#643873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#643874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#643874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#643875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#643875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#643876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#643876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#643877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#643877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#643878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#643878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#643879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#643879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#643880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#643880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#643881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#643881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#643882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#643882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#643883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#643883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#643884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#643884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#643885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#643885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#643886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#643886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#643887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#643887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#643888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#643888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#643889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#643889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#643890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#643890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#643891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#643891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)
== Physical Plan ==
AdaptiveSparkPlan (16)
+- == Final Plan ==
* HashAggregate (11)
+- ShuffleQueryStage (10), Statistics(sizeInBytes=32.0 B, rowCount=2)
+- Exchange (9)
+- * HashAggregate (8)
+- Union (7)
:- * Project (3)
: +- * Filter (2)
: +- * Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1] (1)
+- * Project (6)
+- * Filter (5)
+- * Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1] (4)
+- == Initial Plan ==
HashAggregate (15)
+- Exchange (14)
+- HashAggregate (13)
+- Union (12)
:- Project (3)
: +- Filter (2)
: +- Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1] (1)
+- Project (6)
+- Filter (5)
+- Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1] (4)
(1) Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore"."h_detexa") as x) [numPartitions=1] [codegen id : 1]
Output [91]: [et_numexa#641837, et_numdos#641838, et_numdem#641839, et_typexa#641840, et_codexa#641841, et_exaacc#641842, et_libexa#641843, et_codapp#641844, et_numsal#641845, et_codper#641846, et_codrad#641847, et_codpro#641848, et_m_am_i#641849, et_ag_on#641850, et_datexa#641851, et_heuexa#641852, et_heusal#641853, et_heufin#641854, et_durtot#641855, et_durava#641856, et_durpen#641857, et_durapr#641858, et_datarr#641859, et_heuarr#641860, et_heud_e#641861, et_heuf_e#641862, et_codsit#641863, et_datmaj#641864, et_coduti#641865, et_numsat#641866, et_affect#641867, et_stu_id#641868, et_sta_pps#641869, et_sop_uid#641870, et_numgrp#641871, et_carrdv#641872, et_sanscr#641873, et_codats#641874, et_stabcd#641875, et_typesclq#641876, et_typbcd#641877, et_codprx#641878, et_flplan#641879, et_available#641880, et_aetitle#641881, et_secondaire#641882, et_mednuc#641883, et_fltbdi#641884, et_codfvu#641885, et_datfvu#641886, et_heufvu#641887, et_suspens#641888, et_acados#641889, et_acapub#641890, et_acamed#641891, et_acalib#641892, et_later#641893, et_position#641894, et_incidence#641895, et_numpdt#641896, et_numord#641897, et_trstat#641898, et_organe#641899, et_heuapp#641900, et_orirdv#641901, et_codvac#641902, et_codvaca#641903, et_numxus#641904, et_numexa_ori#641905, et_exacot#641906, et_flnocot#641907, et_alarmes#641908, et_modal_aet#641909, et_numprore#641910, et_comprore#641911, et_numrvx#641912, et_noseq#641913, et_datfin#641914, et_numresa#641915, et_fhirid#641916, et_regana#641917, et_nb_ser#641918, et_nb_fic#641919, et_nb_img_key#641920, et_stu_id_ori#641921, et_codper_prore#641922, et_numseance#641923, et_numordseance#641924, et_numtrt#641925, et_comment#641926, et_codloinc#641927]
ReadSchema: struct<et_numexa:string,et_numdos:string,et_numdem:string,et_typexa:string,et_codexa:string,et_exaacc:string,et_libexa:string,et_codapp:string,et_numsal:string,et_codper:string,et_codrad:string,et_codpro:string,et_m_am_i:string,et_ag_on:string,et_datexa:string,et_heuexa:string,et_heusal:string,et_heufin:string,et_durtot:string,et_durava:string,et_durpen:string,et_durapr:string,et_datarr:string,et_heuarr:string,et_heud_e:string,et_heuf_e:string,et_codsit:string,et_datmaj:string,et_coduti:string,et_numsat:string,et_affect:string,et_stu_id:string,et_sta_pps:string,et_sop_uid:string,et_numgrp:string,et_carrdv:string,et_sanscr:string,et_codats:string,et_stabcd:string,et_typesclq:string,et_typbcd:string,et_codprx:string,et_flplan:string,et_available:string,et_aetitle:string,et_secondaire:string,et_mednuc:string,et_fltbdi:string,et_codfvu:string,et_datfvu:string,et_heufvu:string,et_suspens:string,et_acados:string,et_acapub:string,et_acamed:string,et_acalib:string,et_later:string,et_position:string,et_incidence:string,et_numpdt:string,et_numord:string,et_trstat:string,et_organe:string,et_heuapp:string,et_orirdv:string,et_codvac:string,et_codvaca:string,et_numxus:string,et_numexa_ori:string,et_exacot:string,et_flnocot:string,et_alarmes:string,et_modal_aet:string,et_numprore:string,et_comprore:string,et_numrvx:string,et_noseq:string,et_datfin:string,et_numresa:string,et_fhirid:string,et_regana:string,et_nb_ser:string,et_nb_fic:string,et_nb_img_key:string,et_stu_id_ori:string,et_codper_prore:string,et_numseance:string,et_numordseance:string,et_numtrt:string,et_comment:string,et_codloinc:string>
(2) Filter [codegen id : 1]
Input [91]: [et_numexa#641837, et_numdos#641838, et_numdem#641839, et_typexa#641840, et_codexa#641841, et_exaacc#641842, et_libexa#641843, et_codapp#641844, et_numsal#641845, et_codper#641846, et_codrad#641847, et_codpro#641848, et_m_am_i#641849, et_ag_on#641850, et_datexa#641851, et_heuexa#641852, et_heusal#641853, et_heufin#641854, et_durtot#641855, et_durava#641856, et_durpen#641857, et_durapr#641858, et_datarr#641859, et_heuarr#641860, et_heud_e#641861, et_heuf_e#641862, et_codsit#641863, et_datmaj#641864, et_coduti#641865, et_numsat#641866, et_affect#641867, et_stu_id#641868, et_sta_pps#641869, et_sop_uid#641870, et_numgrp#641871, et_carrdv#641872, et_sanscr#641873, et_codats#641874, et_stabcd#641875, et_typesclq#641876, et_typbcd#641877, et_codprx#641878, et_flplan#641879, et_available#641880, et_aetitle#641881, et_secondaire#641882, et_mednuc#641883, et_fltbdi#641884, et_codfvu#641885, et_datfvu#641886, et_heufvu#641887, et_suspens#641888, et_acados#641889, et_acapub#641890, et_acamed#641891, et_acalib#641892, et_later#641893, et_position#641894, et_incidence#641895, et_numpdt#641896, et_numord#641897, et_trstat#641898, et_organe#641899, et_heuapp#641900, et_orirdv#641901, et_codvac#641902, et_codvaca#641903, et_numxus#641904, et_numexa_ori#641905, et_exacot#641906, et_flnocot#641907, et_alarmes#641908, et_modal_aet#641909, et_numprore#641910, et_comprore#641911, et_numrvx#641912, et_noseq#641913, et_datfin#641914, et_numresa#641915, et_fhirid#641916, et_regana#641917, et_nb_ser#641918, et_nb_fic#641919, et_nb_img_key#641920, et_stu_id_ori#641921, et_codper_prore#641922, et_numseance#641923, et_numordseance#641924, et_numtrt#641925, et_comment#641926, et_codloinc#641927]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#641837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#641837)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#641838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#641838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#641839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#641839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#641840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#641840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#641841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#641841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#641842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#641842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#641843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#641843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#641844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#641844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#641845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#641845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#641846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#641846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#641847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#641847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#641848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#641848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#641849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#641849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#641850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#641850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#641851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#641851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#641852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#641852)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#641853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#641853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#641854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#641854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#641855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#641855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#641856)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#641856)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#641857)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#641857)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#641858)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#641858)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#641859)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#641859)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#641860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#641860)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#641861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#641861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#641862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#641862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#641863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#641863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#641864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#641864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#641865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#641865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#641866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#641866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#641867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#641867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#641868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#641868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#641869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#641869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#641870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#641870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#641871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#641871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#641872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#641872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#641873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#641873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#641874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#641874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#641875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#641875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#641876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#641876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#641877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#641877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#641878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#641878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#641879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#641879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#641880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_available#641880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#641881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#641881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#641882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#641882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#641883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#641883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#641884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#641884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#641885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#641885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#641886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#641886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#641887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#641887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#641888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#641888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#641889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#641889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#641890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#641890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#641891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#641891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#641892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#641892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#641893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_later#641893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#641894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_position#641894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#641895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#641895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#641896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#641896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#641897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#641897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#641898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#641898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#641899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#641899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#641900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#641900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#641901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#641901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#641902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#641902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#641903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#641903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#641904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#641904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#641905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#641905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#641906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#641906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#641907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#641907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#641908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#641908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#641909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#641909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#641910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#641910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#641911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#641911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#641912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#641912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#641913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#641913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#641914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#641914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#641915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#641915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#641916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#641916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#641917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#641917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#641918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#641918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#641919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#641919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#641920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#641920)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#641921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#641921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#641922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#641922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#641923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#641923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#641924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#641924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#641925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#641925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#641926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#641926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#641927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#641927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)
(3) Project [codegen id : 1]
Output: []
Input [91]: [et_numexa#641837, et_numdos#641838, et_numdem#641839, et_typexa#641840, et_codexa#641841, et_exaacc#641842, et_libexa#641843, et_codapp#641844, et_numsal#641845, et_codper#641846, et_codrad#641847, et_codpro#641848, et_m_am_i#641849, et_ag_on#641850, et_datexa#641851, et_heuexa#641852, et_heusal#641853, et_heufin#641854, et_durtot#641855, et_durava#641856, et_durpen#641857, et_durapr#641858, et_datarr#641859, et_heuarr#641860, et_heud_e#641861, et_heuf_e#641862, et_codsit#641863, et_datmaj#641864, et_coduti#641865, et_numsat#641866, et_affect#641867, et_stu_id#641868, et_sta_pps#641869, et_sop_uid#641870, et_numgrp#641871, et_carrdv#641872, et_sanscr#641873, et_codats#641874, et_stabcd#641875, et_typesclq#641876, et_typbcd#641877, et_codprx#641878, et_flplan#641879, et_available#641880, et_aetitle#641881, et_secondaire#641882, et_mednuc#641883, et_fltbdi#641884, et_codfvu#641885, et_datfvu#641886, et_heufvu#641887, et_suspens#641888, et_acados#641889, et_acapub#641890, et_acamed#641891, et_acalib#641892, et_later#641893, et_position#641894, et_incidence#641895, et_numpdt#641896, et_numord#641897, et_trstat#641898, et_organe#641899, et_heuapp#641900, et_orirdv#641901, et_codvac#641902, et_codvaca#641903, et_numxus#641904, et_numexa_ori#641905, et_exacot#641906, et_flnocot#641907, et_alarmes#641908, et_modal_aet#641909, et_numprore#641910, et_comprore#641911, et_numrvx#641912, et_noseq#641913, et_datfin#641914, et_numresa#641915, et_fhirid#641916, et_regana#641917, et_nb_ser#641918, et_nb_fic#641919, et_nb_img_key#641920, et_stu_id_ori#641921, et_codper_prore#641922, et_numseance#641923, et_numordseance#641924, et_numtrt#641925, et_comment#641926, et_codloinc#641927]
(4) Scan JDBCRelation((SELECT "et_numexa", "et_numdos", "et_numdem", "et_typexa", "et_codexa", "et_exaacc", "et_libexa", "et_codapp", "et_numsal", "et_codper", "et_codrad", "et_codpro", "et_m_am_i", "et_ag_on", "et_datexa", "et_heuexa", "et_heusal", "et_heufin", "et_durtot", "et_durava", "et_durpen", "et_durapr", "et_datarr", "et_heuarr", "et_heud_e", "et_heuf_e", "et_codsit", "et_datmaj", "et_coduti", "et_numsat", "et_affect", "et_stu_id", "et_sta_pps", "et_sop_uid", "et_numgrp", "et_carrdv", "et_sanscr", "et_codats", "et_stabcd", "et_typesclq", "et_typbcd", "et_codprx", "et_flplan", "et_available", "et_aetitle", "et_secondaire", "et_mednuc", "et_fltbdi", "et_codfvu", "et_datfvu", "et_heufvu", "et_suspens", "et_acados", "et_acapub", "et_acamed", "et_acalib", "et_later", "et_position", "et_incidence", "et_numpdt", "et_numord", "et_trstat", "et_organe", "et_heuapp", "et_orirdv", "et_codvac", "et_codvaca", "et_numxus", "et_numexa_ori", "et_exacot", "et_flnocot", "et_alarmes", "et_modal_aet", "et_numprore", "et_comprore", "et_numrvx", "et_noseq", "et_datfin", "et_numresa", "et_fhirid", "et_regana", "et_nb_ser", "et_nb_fic", "et_nb_img_key", "et_stu_id_ori", "et_codper_prore", "et_numseance", "et_numordseance", "et_numtrt", "et_comment", "et_codloinc" FROM "xplore2"."h_detexa") as x) [numPartitions=1] [codegen id : 2]
Output [91]: [et_numexa#643801, et_numdos#643802, et_numdem#643803, et_typexa#643804, et_codexa#643805, et_exaacc#643806, et_libexa#643807, et_codapp#643808, et_numsal#643809, et_codper#643810, et_codrad#643811, et_codpro#643812, et_m_am_i#643813, et_ag_on#643814, et_datexa#643815, et_heuexa#643816, et_heusal#643817, et_heufin#643818, et_durtot#643819, et_durava#643820, et_durpen#643821, et_durapr#643822, et_datarr#643823, et_heuarr#643824, et_heud_e#643825, et_heuf_e#643826, et_codsit#643827, et_datmaj#643828, et_coduti#643829, et_numsat#643830, et_affect#643831, et_stu_id#643832, et_sta_pps#643833, et_sop_uid#643834, et_numgrp#643835, et_carrdv#643836, et_sanscr#643837, et_codats#643838, et_stabcd#643839, et_typesclq#643840, et_typbcd#643841, et_codprx#643842, et_flplan#643843, et_available#643844, et_aetitle#643845, et_secondaire#643846, et_mednuc#643847, et_fltbdi#643848, et_codfvu#643849, et_datfvu#643850, et_heufvu#643851, et_suspens#643852, et_acados#643853, et_acapub#643854, et_acamed#643855, et_acalib#643856, et_later#643857, et_position#643858, et_incidence#643859, et_numpdt#643860, et_numord#643861, et_trstat#643862, et_organe#643863, et_heuapp#643864, et_orirdv#643865, et_codvac#643866, et_codvaca#643867, et_numxus#643868, et_numexa_ori#643869, et_exacot#643870, et_flnocot#643871, et_alarmes#643872, et_modal_aet#643873, et_numprore#643874, et_comprore#643875, et_numrvx#643876, et_noseq#643877, et_datfin#643878, et_numresa#643879, et_fhirid#643880, et_regana#643881, et_nb_ser#643882, et_nb_fic#643883, et_nb_img_key#643884, et_stu_id_ori#643885, et_codper_prore#643886, et_numseance#643887, et_numordseance#643888, et_numtrt#643889, et_comment#643890, et_codloinc#643891]
ReadSchema: struct<et_numexa:string,et_numdos:string,et_numdem:string,et_typexa:string,et_codexa:string,et_exaacc:string,et_libexa:string,et_codapp:string,et_numsal:string,et_codper:string,et_codrad:string,et_codpro:string,et_m_am_i:string,et_ag_on:string,et_datexa:string,et_heuexa:string,et_heusal:string,et_heufin:string,et_durtot:string,et_durava:string,et_durpen:string,et_durapr:string,et_datarr:string,et_heuarr:string,et_heud_e:string,et_heuf_e:string,et_codsit:string,et_datmaj:string,et_coduti:string,et_numsat:string,et_affect:string,et_stu_id:string,et_sta_pps:string,et_sop_uid:string,et_numgrp:string,et_carrdv:string,et_sanscr:string,et_codats:string,et_stabcd:string,et_typesclq:string,et_typbcd:string,et_codprx:string,et_flplan:string,et_available:string,et_aetitle:string,et_secondaire:string,et_mednuc:string,et_fltbdi:string,et_codfvu:string,et_datfvu:string,et_heufvu:string,et_suspens:string,et_acados:string,et_acapub:string,et_acamed:string,et_acalib:string,et_later:string,et_position:string,et_incidence:string,et_numpdt:string,et_numord:string,et_trstat:string,et_organe:string,et_heuapp:string,et_orirdv:string,et_codvac:string,et_codvaca:string,et_numxus:string,et_numexa_ori:string,et_exacot:string,et_flnocot:string,et_alarmes:string,et_modal_aet:string,et_numprore:string,et_comprore:string,et_numrvx:string,et_noseq:string,et_datfin:string,et_numresa:string,et_fhirid:string,et_regana:string,et_nb_ser:string,et_nb_fic:string,et_nb_img_key:string,et_stu_id_ori:string,et_codper_prore:string,et_numseance:string,et_numordseance:string,et_numtrt:string,et_comment:string,et_codloinc:string>
(5) Filter [codegen id : 2]
Input [91]: [et_numexa#643801, et_numdos#643802, et_numdem#643803, et_typexa#643804, et_codexa#643805, et_exaacc#643806, et_libexa#643807, et_codapp#643808, et_numsal#643809, et_codper#643810, et_codrad#643811, et_codpro#643812, et_m_am_i#643813, et_ag_on#643814, et_datexa#643815, et_heuexa#643816, et_heusal#643817, et_heufin#643818, et_durtot#643819, et_durava#643820, et_durpen#643821, et_durapr#643822, et_datarr#643823, et_heuarr#643824, et_heud_e#643825, et_heuf_e#643826, et_codsit#643827, et_datmaj#643828, et_coduti#643829, et_numsat#643830, et_affect#643831, et_stu_id#643832, et_sta_pps#643833, et_sop_uid#643834, et_numgrp#643835, et_carrdv#643836, et_sanscr#643837, et_codats#643838, et_stabcd#643839, et_typesclq#643840, et_typbcd#643841, et_codprx#643842, et_flplan#643843, et_available#643844, et_aetitle#643845, et_secondaire#643846, et_mednuc#643847, et_fltbdi#643848, et_codfvu#643849, et_datfvu#643850, et_heufvu#643851, et_suspens#643852, et_acados#643853, et_acapub#643854, et_acamed#643855, et_acalib#643856, et_later#643857, et_position#643858, et_incidence#643859, et_numpdt#643860, et_numord#643861, et_trstat#643862, et_organe#643863, et_heuapp#643864, et_orirdv#643865, et_codvac#643866, et_codvaca#643867, et_numxus#643868, et_numexa_ori#643869, et_exacot#643870, et_flnocot#643871, et_alarmes#643872, et_modal_aet#643873, et_numprore#643874, et_comprore#643875, et_numrvx#643876, et_noseq#643877, et_datfin#643878, et_numresa#643879, et_fhirid#643880, et_regana#643881, et_nb_ser#643882, et_nb_fic#643883, et_nb_img_key#643884, et_stu_id_ori#643885, et_codper_prore#643886, et_numseance#643887, et_numordseance#643888, et_numtrt#643889, et_comment#643890, et_codloinc#643891]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa#643801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa#643801)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdos#643802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdos#643802)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numdem#643803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numdem#643803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typexa#643804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typexa#643804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codexa#643805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codexa#643805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exaacc#643806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exaacc#643806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_libexa#643807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_libexa#643807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codapp#643808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codapp#643808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsal#643809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsal#643809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper#643810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper#643810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codrad#643811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codrad#643811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codpro#643812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codpro#643812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_m_am_i#643813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_m_am_i#643813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_ag_on#643814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_ag_on#643814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datexa#643815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datexa#643815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuexa#643816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuexa#643816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heusal#643817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heusal#643817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufin#643818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufin#643818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durtot#643819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durtot#643819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durava#643820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durava#643820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durpen#643821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durpen#643821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_durapr#643822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_durapr#643822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datarr#643823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datarr#643823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuarr#643824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuarr#643824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heud_e#643825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heud_e#643825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuf_e#643826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuf_e#643826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codsit#643827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codsit#643827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datmaj#643828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datmaj#643828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_coduti#643829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_coduti#643829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numsat#643830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numsat#643830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_affect#643831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_affect#643831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id#643832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id#643832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sta_pps#643833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sta_pps#643833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sop_uid#643834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sop_uid#643834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numgrp#643835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numgrp#643835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_carrdv#643836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_carrdv#643836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_sanscr#643837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_sanscr#643837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codats#643838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codats#643838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stabcd#643839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stabcd#643839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typesclq#643840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typesclq#643840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_typbcd#643841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_typbcd#643841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codprx#643842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codprx#643842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flplan#643843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flplan#643843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_available#643844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_available#643844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_aetitle#643845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_aetitle#643845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_secondaire#643846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_secondaire#643846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_mednuc#643847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_mednuc#643847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fltbdi#643848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fltbdi#643848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codfvu#643849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codfvu#643849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfvu#643850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfvu#643850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heufvu#643851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heufvu#643851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_suspens#643852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_suspens#643852)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acados#643853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acados#643853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acapub#643854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acapub#643854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acamed#643855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acamed#643855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_acalib#643856)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_acalib#643856)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_later#643857)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_later#643857)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_position#643858)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_position#643858)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_incidence#643859)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_incidence#643859)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numpdt#643860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numpdt#643860)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numord#643861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numord#643861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_trstat#643862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_trstat#643862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_organe#643863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_organe#643863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_heuapp#643864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_heuapp#643864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_orirdv#643865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_orirdv#643865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvac#643866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvac#643866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codvaca#643867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codvaca#643867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numxus#643868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numxus#643868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numexa_ori#643869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numexa_ori#643869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_exacot#643870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_exacot#643870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_flnocot#643871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_flnocot#643871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_alarmes#643872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_alarmes#643872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_modal_aet#643873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_modal_aet#643873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numprore#643874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numprore#643874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comprore#643875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comprore#643875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numrvx#643876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numrvx#643876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_noseq#643877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_noseq#643877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_datfin#643878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_datfin#643878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numresa#643879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numresa#643879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_fhirid#643880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_fhirid#643880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_regana#643881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_regana#643881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_ser#643882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_ser#643882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_fic#643883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_fic#643883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_nb_img_key#643884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_nb_img_key#643884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_stu_id_ori#643885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_stu_id_ori#643885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codper_prore#643886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codper_prore#643886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numseance#643887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numseance#643887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numordseance#643888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numordseance#643888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_numtrt#643889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_numtrt#643889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_comment#643890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_comment#643890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(et_codloinc#643891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(et_codloinc#643891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)
(6) Project [codegen id : 2]
Output: []
Input [91]: [et_numexa#643801, et_numdos#643802, et_numdem#643803, et_typexa#643804, et_codexa#643805, et_exaacc#643806, et_libexa#643807, et_codapp#643808, et_numsal#643809, et_codper#643810, et_codrad#643811, et_codpro#643812, et_m_am_i#643813, et_ag_on#643814, et_datexa#643815, et_heuexa#643816, et_heusal#643817, et_heufin#643818, et_durtot#643819, et_durava#643820, et_durpen#643821, et_durapr#643822, et_datarr#643823, et_heuarr#643824, et_heud_e#643825, et_heuf_e#643826, et_codsit#643827, et_datmaj#643828, et_coduti#643829, et_numsat#643830, et_affect#643831, et_stu_id#643832, et_sta_pps#643833, et_sop_uid#643834, et_numgrp#643835, et_carrdv#643836, et_sanscr#643837, et_codats#643838, et_stabcd#643839, et_typesclq#643840, et_typbcd#643841, et_codprx#643842, et_flplan#643843, et_available#643844, et_aetitle#643845, et_secondaire#643846, et_mednuc#643847, et_fltbdi#643848, et_codfvu#643849, et_datfvu#643850, et_heufvu#643851, et_suspens#643852, et_acados#643853, et_acapub#643854, et_acamed#643855, et_acalib#643856, et_later#643857, et_position#643858, et_incidence#643859, et_numpdt#643860, et_numord#643861, et_trstat#643862, et_organe#643863, et_heuapp#643864, et_orirdv#643865, et_codvac#643866, et_codvaca#643867, et_numxus#643868, et_numexa_ori#643869, et_exacot#643870, et_flnocot#643871, et_alarmes#643872, et_modal_aet#643873, et_numprore#643874, et_comprore#643875, et_numrvx#643876, et_noseq#643877, et_datfin#643878, et_numresa#643879, et_fhirid#643880, et_regana#643881, et_nb_ser#643882, et_nb_fic#643883, et_nb_img_key#643884, et_stu_id_ori#643885, et_codper_prore#643886, et_numseance#643887, et_numordseance#643888, et_numtrt#643889, et_comment#643890, et_codloinc#643891]
(7) Union
(8) HashAggregate [codegen id : 3]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#648667L]
Results [1]: [count#648668L]
(9) Exchange
Input [1]: [count#648668L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=35160]
(10) ShuffleQueryStage
Output [1]: [count#648668L]
Arguments: 0
(11) HashAggregate [codegen id : 4]
Input [1]: [count#648668L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#646166L]
Results [1]: [count(1)#646166L AS COL_a012d5d6-49e9-4707-b4c5-8cb50f138468#646168L]
(12) Union
(13) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#648667L]
Results [1]: [count#648668L]
(14) Exchange
Input [1]: [count#648668L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=35140]
(15) HashAggregate
Input [1]: [count#648668L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#646166L]
Results [1]: [count(1)#646166L AS COL_a012d5d6-49e9-4707-b4c5-8cb50f138468#646168L]
(16) AdaptiveSparkPlan
Output [1]: [COL_a012d5d6-49e9-4707-b4c5-8cb50f138468#646168L]
Arguments: isFinalPlan=true