Project [at_numdos#623320 AS COL_AT_NUMDOS_438023#626596, at_stapat#623321 AS COL_AT_STAPAT_438024#626597, at_prefix#623322 AS COL_AT_PREFIX_438025#626598, at_nompat#623323 AS COL_AT_NOMPAT_438026#626599, at_pnopat#623324 AS COL_AT_PNOPAT_438027#626600, at_njfpat#623325 AS COL_AT_NJFPAT_438028#626601, at_datnai#623326 AS COL_AT_DATNAI_438029#626602, at_datnaiss#623327 AS COL_AT_DATNAISS_438030#626603, at_sexe#623328 AS COL_AT_SEXE_438031#626604, at_numper#623329 AS COL_AT_NUMPER_438032#626605, at_sigma#623330 AS COL_AT_SIGMA_438033#626606, at_verrou#623331 AS COL_AT_VERROU_438034#626607, at_poids#623332 AS COL_AT_POIDS_438035#626608, at_indcen#623333 AS COL_AT_INDCEN_438036#626609, at_numss#623334 AS COL_AT_NUMSS_438037#626610, at_antece#623335 AS COL_AT_ANTECE_438038#626611, at_adr_1#623336 AS COL_AT_ADR_1_438039#626612, at_adr_2#623337 AS COL_AT_ADR_2_438040#626613, at_codpos#623338 AS COL_AT_CODPOS_438041#626614, at_ville#623339 AS COL_AT_VILLE_438042#626615, at_pays#623340 AS COL_AT_PAYS_438043#626616, at_numcai#623341 AS COL_AT_NUMCAI_438044#626617, at_nummut#623342 AS COL_AT_NUMMUT_438045#626618, at_numcha#623343 AS COL_AT_NUMCHA_438046#626619, ... 113 more fields]
Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#623320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#623320)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#623321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#623321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#623322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#623322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#623323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#623323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#623324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#623324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#623325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#623325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#623326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#623326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#623327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#623327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#623328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#623328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#623329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#623329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#623330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#623330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#623331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#623331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#623332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#623332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#623333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#623333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#623334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#623334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#623335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#623335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#623336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#623336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#623337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#623337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#623338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#623338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#623339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#623339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#623340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#623340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#623341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#623341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#623342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#623342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#623343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#623343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#623344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#623344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#623345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#623345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#623346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#623346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#623347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#623347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#623348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#623348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#623349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#623349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#623350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#623350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#623351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#623351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#623352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#623352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#623353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#623353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#623354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#623354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#623355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#623355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#623356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#623356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#623357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#623357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#623358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#623358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#623359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#623359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#623360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#623360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#623361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#623361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#623362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#623362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#623363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#623363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#623364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#623364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#623365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#623365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#623366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#623366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#623367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#623367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#623368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#623368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#623369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#623369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#623370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#623370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#623371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#623371)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#623372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#623372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#623373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#623373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#623374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#623374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#623375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#623375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#623376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#623376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#623377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#623377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#623378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#623378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#623379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#623379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#623380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#623380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#623381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#623381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#623382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#623382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#623383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#623383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#623384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#623384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#623385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#623385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#623386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#623386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#623387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#623387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#623388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#623388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#623389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#623389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#623390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#623390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#623391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#623391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#623392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#623392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#623393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#623393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#623394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#623394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#623395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#623395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#623396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#623396)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#623397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#623397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#623398)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#623398)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#623399)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#623399)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#623400)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#623400)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#623401)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#623401)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#623402)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#623402)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#623403)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#623403)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#623404)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#623404)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#623405)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#623405)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#623406)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#623406)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#623407)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#623407)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#623408)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#623408)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#623409)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#623409)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#623410)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#623410)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#623411)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#623411)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#623412)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#623412)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#623413)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#623413)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#623414)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#623414)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#623415)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#623415)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#623416)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#623416)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#623417)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#623417)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#623418)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#623418)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#623419)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#623419)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#623420)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#623420)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#623421)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#623421)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#623422)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#623422)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#623423)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#623423)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#623424)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#623424)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#623425)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#623425)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#623426)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#623426)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#623427)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#623427)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#623428)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#623428)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#623429)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#623429)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#623430)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#623430)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#623431)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#623431)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#623432)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#623432)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#623433)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#623433)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#623434)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#623434)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#623435)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#623435)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#623436)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#623436)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#623437)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#623437)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#623438)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#623438)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#623439)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#623439)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#623440)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#623440)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#623441)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#623441)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#623442)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#623442)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#623443)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#623443)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#623444)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#623444)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#623445)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#623445)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#623446)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#623446)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#623447)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#623447)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#623448)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#623448)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#623449)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#623449)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#623450)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#623450)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#623451)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#623451)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#623452)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#623452)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#623453)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#623453)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#623454)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#623454)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#623455)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#623455)), 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)
Project [at_numdos#624547 AS COL_AT_NUMDOS_438023#627418, at_stapat#624548 AS COL_AT_STAPAT_438024#627419, at_prefix#624549 AS COL_AT_PREFIX_438025#627420, at_nompat#624550 AS COL_AT_NOMPAT_438026#627421, at_pnopat#624551 AS COL_AT_PNOPAT_438027#627422, at_njfpat#624552 AS COL_AT_NJFPAT_438028#627423, at_datnai#624553 AS COL_AT_DATNAI_438029#627424, at_datnaiss#624554 AS COL_AT_DATNAISS_438030#627425, at_sexe#624555 AS COL_AT_SEXE_438031#627426, at_numper#624556 AS COL_AT_NUMPER_438032#627427, at_sigma#624557 AS COL_AT_SIGMA_438033#627428, at_verrou#624558 AS COL_AT_VERROU_438034#627429, at_poids#624559 AS COL_AT_POIDS_438035#627430, at_indcen#624560 AS COL_AT_INDCEN_438036#627431, at_numss#624561 AS COL_AT_NUMSS_438037#627432, at_antece#624562 AS COL_AT_ANTECE_438038#627433, at_adr_1#624563 AS COL_AT_ADR_1_438039#627434, at_adr_2#624564 AS COL_AT_ADR_2_438040#627435, at_codpos#624565 AS COL_AT_CODPOS_438041#627436, at_ville#624566 AS COL_AT_VILLE_438042#627437, at_pays#624567 AS COL_AT_PAYS_438043#627438, at_numcai#624568 AS COL_AT_NUMCAI_438044#627439, at_nummut#624569 AS COL_AT_NUMMUT_438045#627440, at_numcha#624570 AS COL_AT_NUMCHA_438046#627441, ... 113 more fields]
Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#624547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#624547)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#624548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#624548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#624549)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#624549)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#624550)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#624550)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#624551)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#624551)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#624552)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#624552)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#624553)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#624553)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#624554)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#624554)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#624555)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#624555)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#624556)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#624556)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#624557)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#624557)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#624558)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#624558)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#624559)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#624559)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#624560)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#624560)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#624561)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#624561)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#624562)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#624562)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#624563)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#624563)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#624564)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#624564)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#624565)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#624565)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#624566)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#624566)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#624567)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#624567)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#624568)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#624568)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#624569)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#624569)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#624570)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#624570)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#624571)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#624571)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#624572)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#624572)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#624573)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#624573)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#624574)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#624574)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#624575)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#624575)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#624576)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#624576)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#624577)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#624577)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#624578)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#624578)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#624579)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#624579)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#624580)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#624580)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#624581)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#624581)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#624582)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#624582)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#624583)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#624583)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#624584)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#624584)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#624585)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#624585)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#624586)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#624586)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#624587)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#624587)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#624588)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#624588)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#624589)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#624589)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#624590)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#624590)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#624591)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#624591)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#624592)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#624592)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#624593)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#624593)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#624594)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#624594)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#624595)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#624595)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#624596)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#624596)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#624597)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#624597)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#624598)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#624598)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#624599)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#624599)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#624600)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#624600)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#624601)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#624601)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#624602)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#624602)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#624603)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#624603)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#624604)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#624604)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#624605)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#624605)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#624606)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#624606)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#624607)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#624607)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#624608)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#624608)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#624609)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#624609)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#624610)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#624610)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#624611)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#624611)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#624612)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#624612)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#624613)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#624613)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#624614)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#624614)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#624615)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#624615)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#624616)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#624616)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#624617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#624617)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#624618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#624618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#624619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#624619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#624620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#624620)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#624621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#624621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#624622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#624622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#624623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#624623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#624624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#624624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#624625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#624625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#624626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#624626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#624627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#624627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#624628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#624628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#624629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#624629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#624630)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#624630)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#624631)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#624631)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#624632)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#624632)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#624633)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#624633)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#624634)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#624634)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#624635)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#624635)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#624636)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#624636)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#624637)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#624637)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#624638)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#624638)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#624639)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#624639)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#624640)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#624640)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#624641)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#624641)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#624642)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#624642)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#624643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#624643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#624644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#624644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#624645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#624645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#624646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#624646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#624647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#624647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#624648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#624648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#624649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#624649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#624650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#624650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#624651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#624651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#624652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#624652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#624653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#624653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#624654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#624654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#624655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#624655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#624656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#624656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#624657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#624657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#624658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#624658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#624659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#624659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#624660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#624660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#624661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#624661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#624662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#624662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#624663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#624663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#624664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#624664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#624665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#624665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#624666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#624666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#624667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#624667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#624668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#624668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#624669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#624669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#624670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#624670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#624671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#624671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#624672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#624672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#624673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#624673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#624674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#624674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#624675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#624675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#624676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#624676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#624677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#624677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#624678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#624678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#624679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#624679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#624680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#624680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#624681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#624681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#624682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#624682)), 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 ==
CollectLimit (10)
+- Union (9)
:- LocalLimit (4)
: +- Project (3)
: +- Filter (2)
: +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] (1)
+- LocalLimit (8)
+- Project (7)
+- Filter (6)
+- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] (5)
(1) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]
Output [136]: [at_numdos#623320, at_stapat#623321, at_prefix#623322, at_nompat#623323, at_pnopat#623324, at_njfpat#623325, at_datnai#623326, at_datnaiss#623327, at_sexe#623328, at_numper#623329, at_sigma#623330, at_verrou#623331, at_poids#623332, at_indcen#623333, at_numss#623334, at_antece#623335, at_adr_1#623336, at_adr_2#623337, at_codpos#623338, at_ville#623339, at_pays#623340, at_numcai#623341, at_nummut#623342, at_numcha#623343, at_telpri#623344, at_telbur#623345, at_telpor#623346, at_fax#623347, at_prefi2#623348, at_nomass#623349, at_pnoass#623350, at_njfass#623351, at_datass#623352, at_adr_1a#623353, at_adr_2a#623354, at_codpoa#623355, at_villea#623356, at_codmed#623357, at_datcss#623358, at_datf_d#623359, at_dat100#623360, at_numsir#623361, at_numssa#623362, at_codser#623363, at_rngnai#623364, at_natass#623365, at_numacc#623366, at_datacc#623367, at_typexo#623368, at_datmaj#623369, at_coduti#623370, at_flcmu#623371, at_qualss#623372, at_codref#623373, at_codregat#623374, at_codcaiat#623375, at_indvital#623376, at_conmut#623377, at_adhmut#623378, at_garmut#623379, at_numper_ori#623380, at_codrout#623381, at_domaine#623382, at_indtrai#623383, at_idhote#623384, at_codsts#623385, at_nirind#623386, at_fldcd#623387, at_flphoto#623388, at_codmtr#623389, at_adr_3#623390, at_pays_iso#623391, at_adr_3a#623392, at_poids_maj#623393, at_codgestion#623394, at_art115#623395, at_taille#623396, at_taille_maj#623397, at_codetab_prod#623398, at_codsit_prod#623399, at_numdos_prod#623400, at_numper_prod#623401, at_numper_ori_prod#623402, at_ins#623403, at_ins_type#623404, at_ins_date#623405, at_ins_source#623406, at_stadmp#623407, at_datdmp#623408, at_alarmes#623409, at_email#623410, at_consent_sms#623411, at_dat_consent_sms#623412, at_datdcd#623413, at_flhlim#623414, at_dathlim#623415, at_codpershlim#623416, at_fldiff#623417, at_lisdest#623418, at_langue#623419, at_numcai_ft#623420, at_codtarifamc#623421, at_flgrve#623422, at_fladri#623423, at_datadri#623424, at_datf_mut#623425, at_comfac#623426, at_numdos_cloud#623427, at_nation#623428, at_titre#623429, at_titre_ass#623430, at_tiq_histoxml#623431, at_tiq_pnoliste#623432, at_codposnai#623433, at_insi#623434, at_insi_oid#623435, at_typconv#623436, at_crisec#623437, at_opereg#623438, at_flannuamc#623439, at_staipp#623440, at_pnonai#623441, at_codinseenai#623442, at_villenai#623443, at_piece_ident_pres#623444, at_dat_staipp#623445, at_datapcv#623446, at_num_apcv#623447, at_heuapcv#623448, at_numper_sec#623449, at_ins_heure#623450, at_persaprev#623451, at_tarif#623452, at_nomhl7#623453, at_numper_ori_oid#623454, at_comment#623455]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_numper:string,at_sigma:string,at_verrou:string,at_poids:string,at_indcen:string,at_numss:string,at_antece:string,at_adr_1:string,at_adr_2:string,at_codpos:string,at_ville:string,at_pays:string,at_numcai:string,at_nummut:string,at_numcha:string,at_telpri:string,at_telbur:string,at_telpor:string,at_fax:string,at_prefi2:string,at_nomass:string,at_pnoass:string,at_njfass:string,at_datass:string,at_adr_1a:string,at_adr_2a:string,at_codpoa:string,at_villea:string,at_codmed:string,at_datcss:string,at_datf_d:string,at_dat100:string,at_numsir:string,at_numssa:string,at_codser:string,at_rngnai:string,at_natass:string,at_numacc:string,at_datacc:string,at_typexo:string,at_datmaj:string,at_coduti:string,at_flcmu:string,at_qualss:string,at_codref:string,at_codregat:string,at_codcaiat:string,at_indvital:string,at_conmut:string,at_adhmut:string,at_garmut:string,at_numper_ori:string,at_codrout:string,at_domaine:string,at_indtrai:string,at_idhote:string,at_codsts:string,at_nirind:string,at_fldcd:string,at_flphoto:string,at_codmtr:string,at_adr_3:string,at_pays_iso:string,at_adr_3a:string,at_poids_maj:string,at_codgestion:string,at_art115:string,at_taille:string,at_taille_maj:string,at_codetab_prod:string,at_codsit_prod:string,at_numdos_prod:string,at_numper_prod:string,at_numper_ori_prod:string,at_ins:string,at_ins_type:string,at_ins_date:string,at_ins_source:string,at_stadmp:string,at_datdmp:string,at_alarmes:string,at_email:string,at_consent_sms:string,at_dat_consent_sms:string,at_datdcd:string,at_flhlim:string,at_dathlim:string,at_codpershlim:string,at_fldiff:string,at_lisdest:string,at_langue:string,at_numcai_ft:string,at_codtarifamc:string,at_flgrve:string,at_fladri:string,at_datadri:string,at_datf_mut:string,at_comfac:string,at_numdos_cloud:string,at_nation:string,at_titre:string,at_titre_ass:string,at_tiq_histoxml:string,at_tiq_pnoliste:string,at_codposnai:string,at_insi:string,at_insi_oid:string,at_typconv:string,at_crisec:string,at_opereg:string,at_flannuamc:string,at_staipp:string,at_pnonai:string,at_codinseenai:string,at_villenai:string,at_piece_ident_pres:string,at_dat_staipp:string,at_datapcv:string,at_num_apcv:string,at_heuapcv:string,at_numper_sec:string,at_ins_heure:string,at_persaprev:string,at_tarif:string,at_nomhl7:string,at_numper_ori_oid:string,at_comment:string>
(2) Filter
Input [136]: [at_numdos#623320, at_stapat#623321, at_prefix#623322, at_nompat#623323, at_pnopat#623324, at_njfpat#623325, at_datnai#623326, at_datnaiss#623327, at_sexe#623328, at_numper#623329, at_sigma#623330, at_verrou#623331, at_poids#623332, at_indcen#623333, at_numss#623334, at_antece#623335, at_adr_1#623336, at_adr_2#623337, at_codpos#623338, at_ville#623339, at_pays#623340, at_numcai#623341, at_nummut#623342, at_numcha#623343, at_telpri#623344, at_telbur#623345, at_telpor#623346, at_fax#623347, at_prefi2#623348, at_nomass#623349, at_pnoass#623350, at_njfass#623351, at_datass#623352, at_adr_1a#623353, at_adr_2a#623354, at_codpoa#623355, at_villea#623356, at_codmed#623357, at_datcss#623358, at_datf_d#623359, at_dat100#623360, at_numsir#623361, at_numssa#623362, at_codser#623363, at_rngnai#623364, at_natass#623365, at_numacc#623366, at_datacc#623367, at_typexo#623368, at_datmaj#623369, at_coduti#623370, at_flcmu#623371, at_qualss#623372, at_codref#623373, at_codregat#623374, at_codcaiat#623375, at_indvital#623376, at_conmut#623377, at_adhmut#623378, at_garmut#623379, at_numper_ori#623380, at_codrout#623381, at_domaine#623382, at_indtrai#623383, at_idhote#623384, at_codsts#623385, at_nirind#623386, at_fldcd#623387, at_flphoto#623388, at_codmtr#623389, at_adr_3#623390, at_pays_iso#623391, at_adr_3a#623392, at_poids_maj#623393, at_codgestion#623394, at_art115#623395, at_taille#623396, at_taille_maj#623397, at_codetab_prod#623398, at_codsit_prod#623399, at_numdos_prod#623400, at_numper_prod#623401, at_numper_ori_prod#623402, at_ins#623403, at_ins_type#623404, at_ins_date#623405, at_ins_source#623406, at_stadmp#623407, at_datdmp#623408, at_alarmes#623409, at_email#623410, at_consent_sms#623411, at_dat_consent_sms#623412, at_datdcd#623413, at_flhlim#623414, at_dathlim#623415, at_codpershlim#623416, at_fldiff#623417, at_lisdest#623418, at_langue#623419, at_numcai_ft#623420, at_codtarifamc#623421, at_flgrve#623422, at_fladri#623423, at_datadri#623424, at_datf_mut#623425, at_comfac#623426, at_numdos_cloud#623427, at_nation#623428, at_titre#623429, at_titre_ass#623430, at_tiq_histoxml#623431, at_tiq_pnoliste#623432, at_codposnai#623433, at_insi#623434, at_insi_oid#623435, at_typconv#623436, at_crisec#623437, at_opereg#623438, at_flannuamc#623439, at_staipp#623440, at_pnonai#623441, at_codinseenai#623442, at_villenai#623443, at_piece_ident_pres#623444, at_dat_staipp#623445, at_datapcv#623446, at_num_apcv#623447, at_heuapcv#623448, at_numper_sec#623449, at_ins_heure#623450, at_persaprev#623451, at_tarif#623452, at_nomhl7#623453, at_numper_ori_oid#623454, at_comment#623455]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#623320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#623320)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#623321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#623321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#623322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#623322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#623323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#623323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#623324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#623324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#623325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#623325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#623326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#623326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#623327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#623327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#623328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#623328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#623329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#623329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#623330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#623330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#623331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#623331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#623332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#623332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#623333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#623333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#623334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#623334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#623335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#623335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#623336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#623336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#623337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#623337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#623338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#623338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#623339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#623339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#623340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#623340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#623341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#623341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#623342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#623342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#623343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#623343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#623344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#623344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#623345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#623345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#623346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#623346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#623347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#623347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#623348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#623348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#623349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#623349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#623350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#623350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#623351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#623351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#623352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#623352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#623353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#623353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#623354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#623354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#623355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#623355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#623356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#623356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#623357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#623357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#623358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#623358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#623359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#623359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#623360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#623360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#623361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#623361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#623362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#623362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#623363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#623363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#623364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#623364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#623365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#623365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#623366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#623366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#623367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#623367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#623368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#623368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#623369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#623369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#623370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#623370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#623371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#623371)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#623372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#623372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#623373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#623373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#623374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#623374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#623375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#623375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#623376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#623376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#623377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#623377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#623378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#623378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#623379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#623379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#623380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#623380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#623381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#623381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#623382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#623382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#623383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#623383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#623384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#623384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#623385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#623385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#623386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#623386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#623387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#623387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#623388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#623388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#623389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#623389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#623390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#623390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#623391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#623391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#623392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#623392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#623393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#623393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#623394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#623394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#623395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#623395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#623396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#623396)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#623397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#623397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#623398)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#623398)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#623399)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#623399)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#623400)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#623400)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#623401)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#623401)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#623402)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#623402)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#623403)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#623403)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#623404)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#623404)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#623405)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#623405)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#623406)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#623406)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#623407)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#623407)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#623408)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#623408)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#623409)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#623409)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#623410)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#623410)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#623411)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#623411)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#623412)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#623412)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#623413)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#623413)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#623414)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#623414)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#623415)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#623415)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#623416)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#623416)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#623417)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#623417)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#623418)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#623418)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#623419)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#623419)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#623420)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#623420)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#623421)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#623421)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#623422)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#623422)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#623423)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#623423)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#623424)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#623424)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#623425)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#623425)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#623426)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#623426)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#623427)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#623427)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#623428)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#623428)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#623429)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#623429)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#623430)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#623430)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#623431)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#623431)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#623432)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#623432)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#623433)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#623433)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#623434)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#623434)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#623435)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#623435)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#623436)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#623436)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#623437)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#623437)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#623438)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#623438)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#623439)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#623439)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#623440)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#623440)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#623441)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#623441)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#623442)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#623442)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#623443)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#623443)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#623444)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#623444)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#623445)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#623445)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#623446)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#623446)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#623447)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#623447)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#623448)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#623448)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#623449)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#623449)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#623450)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#623450)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#623451)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#623451)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#623452)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#623452)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#623453)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#623453)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#623454)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#623454)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#623455)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#623455)), 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
Output [137]: [at_numdos#623320 AS COL_AT_NUMDOS_438023#626596, at_stapat#623321 AS COL_AT_STAPAT_438024#626597, at_prefix#623322 AS COL_AT_PREFIX_438025#626598, at_nompat#623323 AS COL_AT_NOMPAT_438026#626599, at_pnopat#623324 AS COL_AT_PNOPAT_438027#626600, at_njfpat#623325 AS COL_AT_NJFPAT_438028#626601, at_datnai#623326 AS COL_AT_DATNAI_438029#626602, at_datnaiss#623327 AS COL_AT_DATNAISS_438030#626603, at_sexe#623328 AS COL_AT_SEXE_438031#626604, at_numper#623329 AS COL_AT_NUMPER_438032#626605, at_sigma#623330 AS COL_AT_SIGMA_438033#626606, at_verrou#623331 AS COL_AT_VERROU_438034#626607, at_poids#623332 AS COL_AT_POIDS_438035#626608, at_indcen#623333 AS COL_AT_INDCEN_438036#626609, at_numss#623334 AS COL_AT_NUMSS_438037#626610, at_antece#623335 AS COL_AT_ANTECE_438038#626611, at_adr_1#623336 AS COL_AT_ADR_1_438039#626612, at_adr_2#623337 AS COL_AT_ADR_2_438040#626613, at_codpos#623338 AS COL_AT_CODPOS_438041#626614, at_ville#623339 AS COL_AT_VILLE_438042#626615, at_pays#623340 AS COL_AT_PAYS_438043#626616, at_numcai#623341 AS COL_AT_NUMCAI_438044#626617, at_nummut#623342 AS COL_AT_NUMMUT_438045#626618, at_numcha#623343 AS COL_AT_NUMCHA_438046#626619, at_telpri#623344 AS COL_AT_TELPRI_438047#626620, at_telbur#623345 AS COL_AT_TELBUR_438048#626621, at_telpor#623346 AS COL_AT_TELPOR_438049#626622, at_fax#623347 AS COL_AT_FAX_438050#626623, at_prefi2#623348 AS COL_AT_PREFI2_438051#626624, at_nomass#623349 AS COL_AT_NOMASS_438052#626625, at_pnoass#623350 AS COL_AT_PNOASS_438053#626626, at_njfass#623351 AS COL_AT_NJFASS_438054#626627, at_datass#623352 AS COL_AT_DATASS_438055#626628, at_adr_1a#623353 AS COL_AT_ADR_1A_438056#626629, at_adr_2a#623354 AS COL_AT_ADR_2A_438057#626630, at_codpoa#623355 AS COL_AT_CODPOA_438058#626631, at_villea#623356 AS COL_AT_VILLEA_438059#626632, at_codmed#623357 AS COL_AT_CODMED_438060#626633, at_datcss#623358 AS COL_AT_DATCSS_438061#626634, at_datf_d#623359 AS COL_AT_DATF_D_438062#626635, at_dat100#623360 AS COL_AT_DAT100_438063#626636, at_numsir#623361 AS COL_AT_NUMSIR_438064#626637, at_numssa#623362 AS COL_AT_NUMSSA_438065#626638, at_codser#623363 AS COL_AT_CODSER_438066#626639, at_rngnai#623364 AS COL_AT_RNGNAI_438067#626640, at_natass#623365 AS COL_AT_NATASS_438068#626641, at_numacc#623366 AS COL_AT_NUMACC_438069#626642, at_datacc#623367 AS COL_AT_DATACC_438070#626643, at_typexo#623368 AS COL_AT_TYPEXO_438071#626644, at_datmaj#623369 AS COL_AT_DATMAJ_438072#626645, at_coduti#623370 AS COL_AT_CODUTI_438073#626646, at_flcmu#623371 AS COL_AT_FLCMU_438074#626647, at_qualss#623372 AS COL_AT_QUALSS_438075#626648, at_codref#623373 AS COL_AT_CODREF_438076#626649, at_codregat#623374 AS COL_AT_CODREGAT_438077#626650, at_codcaiat#623375 AS COL_AT_CODCAIAT_438078#626651, at_indvital#623376 AS COL_AT_INDVITAL_438079#626652, at_conmut#623377 AS COL_AT_CONMUT_438080#626653, at_adhmut#623378 AS COL_AT_ADHMUT_438081#626654, at_garmut#623379 AS COL_AT_GARMUT_438082#626655, at_numper_ori#623380 AS COL_AT_NUMPER_ORI_438083#626656, at_codrout#623381 AS COL_AT_CODROUT_438084#626657, at_domaine#623382 AS COL_AT_DOMAINE_438085#626658, at_indtrai#623383 AS COL_AT_INDTRAI_438086#626659, at_idhote#623384 AS COL_AT_IDHOTE_438087#626660, at_codsts#623385 AS COL_AT_CODSTS_438088#626661, at_nirind#623386 AS COL_AT_NIRIND_438089#626662, at_fldcd#623387 AS COL_AT_FLDCD_438090#626663, at_flphoto#623388 AS COL_AT_FLPHOTO_438091#626664, at_codmtr#623389 AS COL_AT_CODMTR_438092#626665, at_adr_3#623390 AS COL_AT_ADR_3_438093#626666, at_pays_iso#623391 AS COL_AT_PAYS_ISO_438094#626667, at_adr_3a#623392 AS COL_AT_ADR_3A_438095#626668, at_poids_maj#623393 AS COL_AT_POIDS_MAJ_438096#626669, at_codgestion#623394 AS COL_AT_CODGESTION_438097#626670, at_art115#623395 AS COL_AT_ART115_438098#626671, at_taille#623396 AS COL_AT_TAILLE_438099#626672, at_taille_maj#623397 AS COL_AT_TAILLE_MAJ_438100#626673, at_codetab_prod#623398 AS COL_AT_CODETAB_PROD_438101#626674, at_codsit_prod#623399 AS COL_AT_CODSIT_PROD_438102#626675, at_numdos_prod#623400 AS COL_AT_NUMDOS_PROD_438103#626676, at_numper_prod#623401 AS COL_AT_NUMPER_PROD_438104#626677, at_numper_ori_prod#623402 AS COL_AT_NUMPER_ORI_P_438105#626678, at_ins#623403 AS COL_AT_INS_438106#626679, at_ins_type#623404 AS COL_AT_INS_TYPE_438107#626680, at_ins_date#623405 AS COL_AT_INS_DATE_438108#626681, at_ins_source#623406 AS COL_AT_INS_SOURCE_438109#626682, at_stadmp#623407 AS COL_AT_STADMP_438110#626683, at_datdmp#623408 AS COL_AT_DATDMP_438111#626684, at_alarmes#623409 AS COL_AT_ALARMES_438112#626685, at_email#623410 AS COL_AT_EMAIL_438113#626686, at_consent_sms#623411 AS COL_AT_CONSENT_SMS_438114#626687, at_dat_consent_sms#623412 AS COL_AT_DAT_CONSENT__438115#626688, at_datdcd#623413 AS COL_AT_DATDCD_438116#626689, at_flhlim#623414 AS COL_AT_FLHLIM_438117#626690, at_dathlim#623415 AS COL_AT_DATHLIM_438118#626691, at_codpershlim#623416 AS COL_AT_CODPERSHLIM_438119#626692, at_fldiff#623417 AS COL_AT_FLDIFF_438120#626693, at_lisdest#623418 AS COL_AT_LISDEST_438121#626694, at_langue#623419 AS COL_AT_LANGUE_438122#626695, at_numcai_ft#623420 AS COL_AT_NUMCAI_FT_438123#626696, at_codtarifamc#623421 AS COL_AT_CODTARIFAMC_438124#626697, at_flgrve#623422 AS COL_AT_FLGRVE_438125#626698, at_fladri#623423 AS COL_AT_FLADRI_438126#626699, at_datadri#623424 AS COL_AT_DATADRI_438127#626700, at_datf_mut#623425 AS COL_AT_DATF_MUT_438128#626701, at_comfac#623426 AS COL_AT_COMFAC_438129#626702, at_numdos_cloud#623427 AS COL_AT_NUMDOS_CLOUD_438130#626703, at_nation#623428 AS COL_AT_NATION_438131#626704, at_titre#623429 AS COL_AT_TITRE_438132#626705, at_titre_ass#623430 AS COL_AT_TITRE_ASS_438133#626706, at_tiq_histoxml#623431 AS COL_AT_TIQ_HISTOXML_438134#626707, at_tiq_pnoliste#623432 AS COL_AT_TIQ_PNOLISTE_438135#626708, at_codposnai#623433 AS COL_AT_CODPOSNAI_438136#626709, at_insi#623434 AS COL_AT_INSI_438137#626710, at_insi_oid#623435 AS COL_AT_INSI_OID_438138#626711, at_typconv#623436 AS COL_AT_TYPCONV_438139#626712, at_crisec#623437 AS COL_AT_CRISEC_438140#626713, at_opereg#623438 AS COL_AT_OPEREG_438141#626714, at_flannuamc#623439 AS COL_AT_FLANNUAMC_438142#626715, at_staipp#623440 AS COL_AT_STAIPP_438143#626716, at_pnonai#623441 AS COL_AT_PNONAI_438144#626717, at_codinseenai#623442 AS COL_AT_CODINSEENAI_438145#626718, at_villenai#623443 AS COL_AT_VILLENAI_438146#626719, at_piece_ident_pres#623444 AS COL_AT_PIECE_IDENT__438147#626720, at_dat_staipp#623445 AS COL_AT_DAT_STAIPP_438148#626721, at_datapcv#623446 AS COL_AT_DATAPCV_438149#626722, at_num_apcv#623447 AS COL_AT_NUM_APCV_438150#626723, at_heuapcv#623448 AS COL_AT_HEUAPCV_438151#626724, at_numper_sec#623449 AS COL_AT_NUMPER_SEC_438152#626725, at_ins_heure#623450 AS COL_AT_INS_HEURE_438153#626726, at_persaprev#623451 AS COL_AT_PERSAPREV_438154#626727, at_tarif#623452 AS COL_AT_TARIF_438155#626728, at_nomhl7#623453 AS COL_AT_NOMHL7_438156#626729, at_numper_ori_oid#623454 AS COL_AT_NUMPER_ORI_O_438157#626730, at_comment#623455 AS COL_AT_COMMENT_438158#626731, str_create(Cab_A) AS COL_ORIGINE_440149#626732]
Input [136]: [at_numdos#623320, at_stapat#623321, at_prefix#623322, at_nompat#623323, at_pnopat#623324, at_njfpat#623325, at_datnai#623326, at_datnaiss#623327, at_sexe#623328, at_numper#623329, at_sigma#623330, at_verrou#623331, at_poids#623332, at_indcen#623333, at_numss#623334, at_antece#623335, at_adr_1#623336, at_adr_2#623337, at_codpos#623338, at_ville#623339, at_pays#623340, at_numcai#623341, at_nummut#623342, at_numcha#623343, at_telpri#623344, at_telbur#623345, at_telpor#623346, at_fax#623347, at_prefi2#623348, at_nomass#623349, at_pnoass#623350, at_njfass#623351, at_datass#623352, at_adr_1a#623353, at_adr_2a#623354, at_codpoa#623355, at_villea#623356, at_codmed#623357, at_datcss#623358, at_datf_d#623359, at_dat100#623360, at_numsir#623361, at_numssa#623362, at_codser#623363, at_rngnai#623364, at_natass#623365, at_numacc#623366, at_datacc#623367, at_typexo#623368, at_datmaj#623369, at_coduti#623370, at_flcmu#623371, at_qualss#623372, at_codref#623373, at_codregat#623374, at_codcaiat#623375, at_indvital#623376, at_conmut#623377, at_adhmut#623378, at_garmut#623379, at_numper_ori#623380, at_codrout#623381, at_domaine#623382, at_indtrai#623383, at_idhote#623384, at_codsts#623385, at_nirind#623386, at_fldcd#623387, at_flphoto#623388, at_codmtr#623389, at_adr_3#623390, at_pays_iso#623391, at_adr_3a#623392, at_poids_maj#623393, at_codgestion#623394, at_art115#623395, at_taille#623396, at_taille_maj#623397, at_codetab_prod#623398, at_codsit_prod#623399, at_numdos_prod#623400, at_numper_prod#623401, at_numper_ori_prod#623402, at_ins#623403, at_ins_type#623404, at_ins_date#623405, at_ins_source#623406, at_stadmp#623407, at_datdmp#623408, at_alarmes#623409, at_email#623410, at_consent_sms#623411, at_dat_consent_sms#623412, at_datdcd#623413, at_flhlim#623414, at_dathlim#623415, at_codpershlim#623416, at_fldiff#623417, at_lisdest#623418, at_langue#623419, at_numcai_ft#623420, at_codtarifamc#623421, at_flgrve#623422, at_fladri#623423, at_datadri#623424, at_datf_mut#623425, at_comfac#623426, at_numdos_cloud#623427, at_nation#623428, at_titre#623429, at_titre_ass#623430, at_tiq_histoxml#623431, at_tiq_pnoliste#623432, at_codposnai#623433, at_insi#623434, at_insi_oid#623435, at_typconv#623436, at_crisec#623437, at_opereg#623438, at_flannuamc#623439, at_staipp#623440, at_pnonai#623441, at_codinseenai#623442, at_villenai#623443, at_piece_ident_pres#623444, at_dat_staipp#623445, at_datapcv#623446, at_num_apcv#623447, at_heuapcv#623448, at_numper_sec#623449, at_ins_heure#623450, at_persaprev#623451, at_tarif#623452, at_nomhl7#623453, at_numper_ori_oid#623454, at_comment#623455]
(4) LocalLimit
Input [137]: [COL_AT_NUMDOS_438023#626596, COL_AT_STAPAT_438024#626597, COL_AT_PREFIX_438025#626598, COL_AT_NOMPAT_438026#626599, COL_AT_PNOPAT_438027#626600, COL_AT_NJFPAT_438028#626601, COL_AT_DATNAI_438029#626602, COL_AT_DATNAISS_438030#626603, COL_AT_SEXE_438031#626604, COL_AT_NUMPER_438032#626605, COL_AT_SIGMA_438033#626606, COL_AT_VERROU_438034#626607, COL_AT_POIDS_438035#626608, COL_AT_INDCEN_438036#626609, COL_AT_NUMSS_438037#626610, COL_AT_ANTECE_438038#626611, COL_AT_ADR_1_438039#626612, COL_AT_ADR_2_438040#626613, COL_AT_CODPOS_438041#626614, COL_AT_VILLE_438042#626615, COL_AT_PAYS_438043#626616, COL_AT_NUMCAI_438044#626617, COL_AT_NUMMUT_438045#626618, COL_AT_NUMCHA_438046#626619, COL_AT_TELPRI_438047#626620, COL_AT_TELBUR_438048#626621, COL_AT_TELPOR_438049#626622, COL_AT_FAX_438050#626623, COL_AT_PREFI2_438051#626624, COL_AT_NOMASS_438052#626625, COL_AT_PNOASS_438053#626626, COL_AT_NJFASS_438054#626627, COL_AT_DATASS_438055#626628, COL_AT_ADR_1A_438056#626629, COL_AT_ADR_2A_438057#626630, COL_AT_CODPOA_438058#626631, COL_AT_VILLEA_438059#626632, COL_AT_CODMED_438060#626633, COL_AT_DATCSS_438061#626634, COL_AT_DATF_D_438062#626635, COL_AT_DAT100_438063#626636, COL_AT_NUMSIR_438064#626637, COL_AT_NUMSSA_438065#626638, COL_AT_CODSER_438066#626639, COL_AT_RNGNAI_438067#626640, COL_AT_NATASS_438068#626641, COL_AT_NUMACC_438069#626642, COL_AT_DATACC_438070#626643, COL_AT_TYPEXO_438071#626644, COL_AT_DATMAJ_438072#626645, COL_AT_CODUTI_438073#626646, COL_AT_FLCMU_438074#626647, COL_AT_QUALSS_438075#626648, COL_AT_CODREF_438076#626649, COL_AT_CODREGAT_438077#626650, COL_AT_CODCAIAT_438078#626651, COL_AT_INDVITAL_438079#626652, COL_AT_CONMUT_438080#626653, COL_AT_ADHMUT_438081#626654, COL_AT_GARMUT_438082#626655, COL_AT_NUMPER_ORI_438083#626656, COL_AT_CODROUT_438084#626657, COL_AT_DOMAINE_438085#626658, COL_AT_INDTRAI_438086#626659, COL_AT_IDHOTE_438087#626660, COL_AT_CODSTS_438088#626661, COL_AT_NIRIND_438089#626662, COL_AT_FLDCD_438090#626663, COL_AT_FLPHOTO_438091#626664, COL_AT_CODMTR_438092#626665, COL_AT_ADR_3_438093#626666, COL_AT_PAYS_ISO_438094#626667, COL_AT_ADR_3A_438095#626668, COL_AT_POIDS_MAJ_438096#626669, COL_AT_CODGESTION_438097#626670, COL_AT_ART115_438098#626671, COL_AT_TAILLE_438099#626672, COL_AT_TAILLE_MAJ_438100#626673, COL_AT_CODETAB_PROD_438101#626674, COL_AT_CODSIT_PROD_438102#626675, COL_AT_NUMDOS_PROD_438103#626676, COL_AT_NUMPER_PROD_438104#626677, COL_AT_NUMPER_ORI_P_438105#626678, COL_AT_INS_438106#626679, COL_AT_INS_TYPE_438107#626680, COL_AT_INS_DATE_438108#626681, COL_AT_INS_SOURCE_438109#626682, COL_AT_STADMP_438110#626683, COL_AT_DATDMP_438111#626684, COL_AT_ALARMES_438112#626685, COL_AT_EMAIL_438113#626686, COL_AT_CONSENT_SMS_438114#626687, COL_AT_DAT_CONSENT__438115#626688, COL_AT_DATDCD_438116#626689, COL_AT_FLHLIM_438117#626690, COL_AT_DATHLIM_438118#626691, COL_AT_CODPERSHLIM_438119#626692, COL_AT_FLDIFF_438120#626693, COL_AT_LISDEST_438121#626694, COL_AT_LANGUE_438122#626695, COL_AT_NUMCAI_FT_438123#626696, COL_AT_CODTARIFAMC_438124#626697, COL_AT_FLGRVE_438125#626698, COL_AT_FLADRI_438126#626699, COL_AT_DATADRI_438127#626700, COL_AT_DATF_MUT_438128#626701, COL_AT_COMFAC_438129#626702, COL_AT_NUMDOS_CLOUD_438130#626703, COL_AT_NATION_438131#626704, COL_AT_TITRE_438132#626705, COL_AT_TITRE_ASS_438133#626706, COL_AT_TIQ_HISTOXML_438134#626707, COL_AT_TIQ_PNOLISTE_438135#626708, COL_AT_CODPOSNAI_438136#626709, COL_AT_INSI_438137#626710, COL_AT_INSI_OID_438138#626711, COL_AT_TYPCONV_438139#626712, COL_AT_CRISEC_438140#626713, COL_AT_OPEREG_438141#626714, COL_AT_FLANNUAMC_438142#626715, COL_AT_STAIPP_438143#626716, COL_AT_PNONAI_438144#626717, COL_AT_CODINSEENAI_438145#626718, COL_AT_VILLENAI_438146#626719, COL_AT_PIECE_IDENT__438147#626720, COL_AT_DAT_STAIPP_438148#626721, COL_AT_DATAPCV_438149#626722, COL_AT_NUM_APCV_438150#626723, COL_AT_HEUAPCV_438151#626724, COL_AT_NUMPER_SEC_438152#626725, COL_AT_INS_HEURE_438153#626726, COL_AT_PERSAPREV_438154#626727, COL_AT_TARIF_438155#626728, COL_AT_NOMHL7_438156#626729, COL_AT_NUMPER_ORI_O_438157#626730, COL_AT_COMMENT_438158#626731, COL_ORIGINE_440149#626732]
Arguments: 1500
(5) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]
Output [136]: [at_numdos#624547, at_stapat#624548, at_prefix#624549, at_nompat#624550, at_pnopat#624551, at_njfpat#624552, at_datnai#624553, at_datnaiss#624554, at_sexe#624555, at_numper#624556, at_sigma#624557, at_verrou#624558, at_poids#624559, at_indcen#624560, at_numss#624561, at_antece#624562, at_adr_1#624563, at_adr_2#624564, at_codpos#624565, at_ville#624566, at_pays#624567, at_numcai#624568, at_nummut#624569, at_numcha#624570, at_telpri#624571, at_telbur#624572, at_telpor#624573, at_fax#624574, at_prefi2#624575, at_nomass#624576, at_pnoass#624577, at_njfass#624578, at_datass#624579, at_adr_1a#624580, at_adr_2a#624581, at_codpoa#624582, at_villea#624583, at_codmed#624584, at_datcss#624585, at_datf_d#624586, at_dat100#624587, at_numsir#624588, at_numssa#624589, at_codser#624590, at_rngnai#624591, at_natass#624592, at_numacc#624593, at_datacc#624594, at_typexo#624595, at_datmaj#624596, at_coduti#624597, at_flcmu#624598, at_qualss#624599, at_codref#624600, at_codregat#624601, at_codcaiat#624602, at_indvital#624603, at_conmut#624604, at_adhmut#624605, at_garmut#624606, at_numper_ori#624607, at_codrout#624608, at_domaine#624609, at_indtrai#624610, at_idhote#624611, at_codsts#624612, at_nirind#624613, at_fldcd#624614, at_flphoto#624615, at_codmtr#624616, at_adr_3#624617, at_pays_iso#624618, at_adr_3a#624619, at_poids_maj#624620, at_codgestion#624621, at_art115#624622, at_taille#624623, at_taille_maj#624624, at_codetab_prod#624625, at_codsit_prod#624626, at_numdos_prod#624627, at_numper_prod#624628, at_numper_ori_prod#624629, at_ins#624630, at_ins_type#624631, at_ins_date#624632, at_ins_source#624633, at_stadmp#624634, at_datdmp#624635, at_alarmes#624636, at_email#624637, at_consent_sms#624638, at_dat_consent_sms#624639, at_datdcd#624640, at_flhlim#624641, at_dathlim#624642, at_codpershlim#624643, at_fldiff#624644, at_lisdest#624645, at_langue#624646, at_numcai_ft#624647, at_codtarifamc#624648, at_flgrve#624649, at_fladri#624650, at_datadri#624651, at_datf_mut#624652, at_comfac#624653, at_numdos_cloud#624654, at_nation#624655, at_titre#624656, at_titre_ass#624657, at_tiq_histoxml#624658, at_tiq_pnoliste#624659, at_codposnai#624660, at_insi#624661, at_insi_oid#624662, at_typconv#624663, at_crisec#624664, at_opereg#624665, at_flannuamc#624666, at_staipp#624667, at_pnonai#624668, at_codinseenai#624669, at_villenai#624670, at_piece_ident_pres#624671, at_dat_staipp#624672, at_datapcv#624673, at_num_apcv#624674, at_heuapcv#624675, at_numper_sec#624676, at_ins_heure#624677, at_persaprev#624678, at_tarif#624679, at_nomhl7#624680, at_numper_ori_oid#624681, at_comment#624682]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_numper:string,at_sigma:string,at_verrou:string,at_poids:string,at_indcen:string,at_numss:string,at_antece:string,at_adr_1:string,at_adr_2:string,at_codpos:string,at_ville:string,at_pays:string,at_numcai:string,at_nummut:string,at_numcha:string,at_telpri:string,at_telbur:string,at_telpor:string,at_fax:string,at_prefi2:string,at_nomass:string,at_pnoass:string,at_njfass:string,at_datass:string,at_adr_1a:string,at_adr_2a:string,at_codpoa:string,at_villea:string,at_codmed:string,at_datcss:string,at_datf_d:string,at_dat100:string,at_numsir:string,at_numssa:string,at_codser:string,at_rngnai:string,at_natass:string,at_numacc:string,at_datacc:string,at_typexo:string,at_datmaj:string,at_coduti:string,at_flcmu:string,at_qualss:string,at_codref:string,at_codregat:string,at_codcaiat:string,at_indvital:string,at_conmut:string,at_adhmut:string,at_garmut:string,at_numper_ori:string,at_codrout:string,at_domaine:string,at_indtrai:string,at_idhote:string,at_codsts:string,at_nirind:string,at_fldcd:string,at_flphoto:string,at_codmtr:string,at_adr_3:string,at_pays_iso:string,at_adr_3a:string,at_poids_maj:string,at_codgestion:string,at_art115:string,at_taille:string,at_taille_maj:string,at_codetab_prod:string,at_codsit_prod:string,at_numdos_prod:string,at_numper_prod:string,at_numper_ori_prod:string,at_ins:string,at_ins_type:string,at_ins_date:string,at_ins_source:string,at_stadmp:string,at_datdmp:string,at_alarmes:string,at_email:string,at_consent_sms:string,at_dat_consent_sms:string,at_datdcd:string,at_flhlim:string,at_dathlim:string,at_codpershlim:string,at_fldiff:string,at_lisdest:string,at_langue:string,at_numcai_ft:string,at_codtarifamc:string,at_flgrve:string,at_fladri:string,at_datadri:string,at_datf_mut:string,at_comfac:string,at_numdos_cloud:string,at_nation:string,at_titre:string,at_titre_ass:string,at_tiq_histoxml:string,at_tiq_pnoliste:string,at_codposnai:string,at_insi:string,at_insi_oid:string,at_typconv:string,at_crisec:string,at_opereg:string,at_flannuamc:string,at_staipp:string,at_pnonai:string,at_codinseenai:string,at_villenai:string,at_piece_ident_pres:string,at_dat_staipp:string,at_datapcv:string,at_num_apcv:string,at_heuapcv:string,at_numper_sec:string,at_ins_heure:string,at_persaprev:string,at_tarif:string,at_nomhl7:string,at_numper_ori_oid:string,at_comment:string>
(6) Filter
Input [136]: [at_numdos#624547, at_stapat#624548, at_prefix#624549, at_nompat#624550, at_pnopat#624551, at_njfpat#624552, at_datnai#624553, at_datnaiss#624554, at_sexe#624555, at_numper#624556, at_sigma#624557, at_verrou#624558, at_poids#624559, at_indcen#624560, at_numss#624561, at_antece#624562, at_adr_1#624563, at_adr_2#624564, at_codpos#624565, at_ville#624566, at_pays#624567, at_numcai#624568, at_nummut#624569, at_numcha#624570, at_telpri#624571, at_telbur#624572, at_telpor#624573, at_fax#624574, at_prefi2#624575, at_nomass#624576, at_pnoass#624577, at_njfass#624578, at_datass#624579, at_adr_1a#624580, at_adr_2a#624581, at_codpoa#624582, at_villea#624583, at_codmed#624584, at_datcss#624585, at_datf_d#624586, at_dat100#624587, at_numsir#624588, at_numssa#624589, at_codser#624590, at_rngnai#624591, at_natass#624592, at_numacc#624593, at_datacc#624594, at_typexo#624595, at_datmaj#624596, at_coduti#624597, at_flcmu#624598, at_qualss#624599, at_codref#624600, at_codregat#624601, at_codcaiat#624602, at_indvital#624603, at_conmut#624604, at_adhmut#624605, at_garmut#624606, at_numper_ori#624607, at_codrout#624608, at_domaine#624609, at_indtrai#624610, at_idhote#624611, at_codsts#624612, at_nirind#624613, at_fldcd#624614, at_flphoto#624615, at_codmtr#624616, at_adr_3#624617, at_pays_iso#624618, at_adr_3a#624619, at_poids_maj#624620, at_codgestion#624621, at_art115#624622, at_taille#624623, at_taille_maj#624624, at_codetab_prod#624625, at_codsit_prod#624626, at_numdos_prod#624627, at_numper_prod#624628, at_numper_ori_prod#624629, at_ins#624630, at_ins_type#624631, at_ins_date#624632, at_ins_source#624633, at_stadmp#624634, at_datdmp#624635, at_alarmes#624636, at_email#624637, at_consent_sms#624638, at_dat_consent_sms#624639, at_datdcd#624640, at_flhlim#624641, at_dathlim#624642, at_codpershlim#624643, at_fldiff#624644, at_lisdest#624645, at_langue#624646, at_numcai_ft#624647, at_codtarifamc#624648, at_flgrve#624649, at_fladri#624650, at_datadri#624651, at_datf_mut#624652, at_comfac#624653, at_numdos_cloud#624654, at_nation#624655, at_titre#624656, at_titre_ass#624657, at_tiq_histoxml#624658, at_tiq_pnoliste#624659, at_codposnai#624660, at_insi#624661, at_insi_oid#624662, at_typconv#624663, at_crisec#624664, at_opereg#624665, at_flannuamc#624666, at_staipp#624667, at_pnonai#624668, at_codinseenai#624669, at_villenai#624670, at_piece_ident_pres#624671, at_dat_staipp#624672, at_datapcv#624673, at_num_apcv#624674, at_heuapcv#624675, at_numper_sec#624676, at_ins_heure#624677, at_persaprev#624678, at_tarif#624679, at_nomhl7#624680, at_numper_ori_oid#624681, at_comment#624682]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#624547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#624547)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#624548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#624548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#624549)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#624549)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#624550)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#624550)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#624551)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#624551)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#624552)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#624552)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#624553)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#624553)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#624554)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#624554)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#624555)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#624555)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#624556)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#624556)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#624557)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#624557)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#624558)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#624558)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#624559)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#624559)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#624560)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#624560)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#624561)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#624561)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#624562)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#624562)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#624563)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#624563)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#624564)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#624564)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#624565)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#624565)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#624566)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#624566)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#624567)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#624567)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#624568)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#624568)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#624569)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#624569)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#624570)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#624570)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#624571)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#624571)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#624572)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#624572)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#624573)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#624573)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#624574)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#624574)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#624575)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#624575)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#624576)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#624576)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#624577)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#624577)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#624578)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#624578)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#624579)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#624579)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#624580)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#624580)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#624581)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#624581)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#624582)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#624582)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#624583)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#624583)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#624584)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#624584)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#624585)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#624585)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#624586)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#624586)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#624587)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#624587)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#624588)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#624588)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#624589)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#624589)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#624590)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#624590)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#624591)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#624591)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#624592)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#624592)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#624593)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#624593)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#624594)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#624594)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#624595)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#624595)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#624596)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#624596)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#624597)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#624597)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#624598)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#624598)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#624599)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#624599)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#624600)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#624600)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#624601)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#624601)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#624602)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#624602)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#624603)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#624603)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#624604)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#624604)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#624605)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#624605)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#624606)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#624606)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#624607)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#624607)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#624608)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#624608)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#624609)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#624609)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#624610)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#624610)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#624611)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#624611)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#624612)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#624612)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#624613)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#624613)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#624614)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#624614)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#624615)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#624615)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#624616)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#624616)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#624617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#624617)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#624618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#624618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#624619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#624619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#624620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#624620)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#624621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#624621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#624622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#624622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#624623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#624623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#624624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#624624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#624625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#624625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#624626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#624626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#624627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#624627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#624628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#624628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#624629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#624629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#624630)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#624630)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#624631)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#624631)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#624632)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#624632)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#624633)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#624633)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#624634)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#624634)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#624635)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#624635)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#624636)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#624636)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#624637)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#624637)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#624638)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#624638)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#624639)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#624639)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#624640)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#624640)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#624641)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#624641)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#624642)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#624642)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#624643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#624643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#624644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#624644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#624645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#624645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#624646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#624646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#624647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#624647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#624648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#624648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#624649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#624649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#624650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#624650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#624651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#624651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#624652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#624652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#624653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#624653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#624654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#624654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#624655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#624655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#624656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#624656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#624657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#624657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#624658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#624658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#624659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#624659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#624660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#624660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#624661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#624661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#624662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#624662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#624663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#624663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#624664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#624664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#624665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#624665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#624666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#624666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#624667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#624667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#624668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#624668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#624669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#624669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#624670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#624670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#624671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#624671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#624672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#624672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#624673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#624673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#624674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#624674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#624675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#624675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#624676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#624676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#624677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#624677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#624678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#624678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#624679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#624679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#624680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#624680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#624681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#624681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#624682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#624682)), 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)
(7) Project
Output [137]: [at_numdos#624547 AS COL_AT_NUMDOS_438023#627418, at_stapat#624548 AS COL_AT_STAPAT_438024#627419, at_prefix#624549 AS COL_AT_PREFIX_438025#627420, at_nompat#624550 AS COL_AT_NOMPAT_438026#627421, at_pnopat#624551 AS COL_AT_PNOPAT_438027#627422, at_njfpat#624552 AS COL_AT_NJFPAT_438028#627423, at_datnai#624553 AS COL_AT_DATNAI_438029#627424, at_datnaiss#624554 AS COL_AT_DATNAISS_438030#627425, at_sexe#624555 AS COL_AT_SEXE_438031#627426, at_numper#624556 AS COL_AT_NUMPER_438032#627427, at_sigma#624557 AS COL_AT_SIGMA_438033#627428, at_verrou#624558 AS COL_AT_VERROU_438034#627429, at_poids#624559 AS COL_AT_POIDS_438035#627430, at_indcen#624560 AS COL_AT_INDCEN_438036#627431, at_numss#624561 AS COL_AT_NUMSS_438037#627432, at_antece#624562 AS COL_AT_ANTECE_438038#627433, at_adr_1#624563 AS COL_AT_ADR_1_438039#627434, at_adr_2#624564 AS COL_AT_ADR_2_438040#627435, at_codpos#624565 AS COL_AT_CODPOS_438041#627436, at_ville#624566 AS COL_AT_VILLE_438042#627437, at_pays#624567 AS COL_AT_PAYS_438043#627438, at_numcai#624568 AS COL_AT_NUMCAI_438044#627439, at_nummut#624569 AS COL_AT_NUMMUT_438045#627440, at_numcha#624570 AS COL_AT_NUMCHA_438046#627441, at_telpri#624571 AS COL_AT_TELPRI_438047#627442, at_telbur#624572 AS COL_AT_TELBUR_438048#627443, at_telpor#624573 AS COL_AT_TELPOR_438049#627444, at_fax#624574 AS COL_AT_FAX_438050#627445, at_prefi2#624575 AS COL_AT_PREFI2_438051#627446, at_nomass#624576 AS COL_AT_NOMASS_438052#627447, at_pnoass#624577 AS COL_AT_PNOASS_438053#627448, at_njfass#624578 AS COL_AT_NJFASS_438054#627449, at_datass#624579 AS COL_AT_DATASS_438055#627450, at_adr_1a#624580 AS COL_AT_ADR_1A_438056#627451, at_adr_2a#624581 AS COL_AT_ADR_2A_438057#627452, at_codpoa#624582 AS COL_AT_CODPOA_438058#627453, at_villea#624583 AS COL_AT_VILLEA_438059#627454, at_codmed#624584 AS COL_AT_CODMED_438060#627455, at_datcss#624585 AS COL_AT_DATCSS_438061#627456, at_datf_d#624586 AS COL_AT_DATF_D_438062#627457, at_dat100#624587 AS COL_AT_DAT100_438063#627458, at_numsir#624588 AS COL_AT_NUMSIR_438064#627459, at_numssa#624589 AS COL_AT_NUMSSA_438065#627460, at_codser#624590 AS COL_AT_CODSER_438066#627461, at_rngnai#624591 AS COL_AT_RNGNAI_438067#627462, at_natass#624592 AS COL_AT_NATASS_438068#627463, at_numacc#624593 AS COL_AT_NUMACC_438069#627464, at_datacc#624594 AS COL_AT_DATACC_438070#627465, at_typexo#624595 AS COL_AT_TYPEXO_438071#627466, at_datmaj#624596 AS COL_AT_DATMAJ_438072#627467, at_coduti#624597 AS COL_AT_CODUTI_438073#627468, at_flcmu#624598 AS COL_AT_FLCMU_438074#627469, at_qualss#624599 AS COL_AT_QUALSS_438075#627470, at_codref#624600 AS COL_AT_CODREF_438076#627471, at_codregat#624601 AS COL_AT_CODREGAT_438077#627472, at_codcaiat#624602 AS COL_AT_CODCAIAT_438078#627473, at_indvital#624603 AS COL_AT_INDVITAL_438079#627474, at_conmut#624604 AS COL_AT_CONMUT_438080#627475, at_adhmut#624605 AS COL_AT_ADHMUT_438081#627476, at_garmut#624606 AS COL_AT_GARMUT_438082#627477, at_numper_ori#624607 AS COL_AT_NUMPER_ORI_438083#627478, at_codrout#624608 AS COL_AT_CODROUT_438084#627479, at_domaine#624609 AS COL_AT_DOMAINE_438085#627480, at_indtrai#624610 AS COL_AT_INDTRAI_438086#627481, at_idhote#624611 AS COL_AT_IDHOTE_438087#627482, at_codsts#624612 AS COL_AT_CODSTS_438088#627483, at_nirind#624613 AS COL_AT_NIRIND_438089#627484, at_fldcd#624614 AS COL_AT_FLDCD_438090#627485, at_flphoto#624615 AS COL_AT_FLPHOTO_438091#627486, at_codmtr#624616 AS COL_AT_CODMTR_438092#627487, at_adr_3#624617 AS COL_AT_ADR_3_438093#627488, at_pays_iso#624618 AS COL_AT_PAYS_ISO_438094#627489, at_adr_3a#624619 AS COL_AT_ADR_3A_438095#627490, at_poids_maj#624620 AS COL_AT_POIDS_MAJ_438096#627491, at_codgestion#624621 AS COL_AT_CODGESTION_438097#627492, at_art115#624622 AS COL_AT_ART115_438098#627493, at_taille#624623 AS COL_AT_TAILLE_438099#627494, at_taille_maj#624624 AS COL_AT_TAILLE_MAJ_438100#627495, at_codetab_prod#624625 AS COL_AT_CODETAB_PROD_438101#627496, at_codsit_prod#624626 AS COL_AT_CODSIT_PROD_438102#627497, at_numdos_prod#624627 AS COL_AT_NUMDOS_PROD_438103#627498, at_numper_prod#624628 AS COL_AT_NUMPER_PROD_438104#627499, at_numper_ori_prod#624629 AS COL_AT_NUMPER_ORI_P_438105#627500, at_ins#624630 AS COL_AT_INS_438106#627501, at_ins_type#624631 AS COL_AT_INS_TYPE_438107#627502, at_ins_date#624632 AS COL_AT_INS_DATE_438108#627503, at_ins_source#624633 AS COL_AT_INS_SOURCE_438109#627504, at_stadmp#624634 AS COL_AT_STADMP_438110#627505, at_datdmp#624635 AS COL_AT_DATDMP_438111#627506, at_alarmes#624636 AS COL_AT_ALARMES_438112#627507, at_email#624637 AS COL_AT_EMAIL_438113#627508, at_consent_sms#624638 AS COL_AT_CONSENT_SMS_438114#627509, at_dat_consent_sms#624639 AS COL_AT_DAT_CONSENT__438115#627510, at_datdcd#624640 AS COL_AT_DATDCD_438116#627511, at_flhlim#624641 AS COL_AT_FLHLIM_438117#627512, at_dathlim#624642 AS COL_AT_DATHLIM_438118#627513, at_codpershlim#624643 AS COL_AT_CODPERSHLIM_438119#627514, at_fldiff#624644 AS COL_AT_FLDIFF_438120#627515, at_lisdest#624645 AS COL_AT_LISDEST_438121#627516, at_langue#624646 AS COL_AT_LANGUE_438122#627517, at_numcai_ft#624647 AS COL_AT_NUMCAI_FT_438123#627518, at_codtarifamc#624648 AS COL_AT_CODTARIFAMC_438124#627519, at_flgrve#624649 AS COL_AT_FLGRVE_438125#627520, at_fladri#624650 AS COL_AT_FLADRI_438126#627521, at_datadri#624651 AS COL_AT_DATADRI_438127#627522, at_datf_mut#624652 AS COL_AT_DATF_MUT_438128#627523, at_comfac#624653 AS COL_AT_COMFAC_438129#627524, at_numdos_cloud#624654 AS COL_AT_NUMDOS_CLOUD_438130#627525, at_nation#624655 AS COL_AT_NATION_438131#627526, at_titre#624656 AS COL_AT_TITRE_438132#627527, at_titre_ass#624657 AS COL_AT_TITRE_ASS_438133#627528, at_tiq_histoxml#624658 AS COL_AT_TIQ_HISTOXML_438134#627529, at_tiq_pnoliste#624659 AS COL_AT_TIQ_PNOLISTE_438135#627530, at_codposnai#624660 AS COL_AT_CODPOSNAI_438136#627531, at_insi#624661 AS COL_AT_INSI_438137#627532, at_insi_oid#624662 AS COL_AT_INSI_OID_438138#627533, at_typconv#624663 AS COL_AT_TYPCONV_438139#627534, at_crisec#624664 AS COL_AT_CRISEC_438140#627535, at_opereg#624665 AS COL_AT_OPEREG_438141#627536, at_flannuamc#624666 AS COL_AT_FLANNUAMC_438142#627537, at_staipp#624667 AS COL_AT_STAIPP_438143#627538, at_pnonai#624668 AS COL_AT_PNONAI_438144#627539, at_codinseenai#624669 AS COL_AT_CODINSEENAI_438145#627540, at_villenai#624670 AS COL_AT_VILLENAI_438146#627541, at_piece_ident_pres#624671 AS COL_AT_PIECE_IDENT__438147#627542, at_dat_staipp#624672 AS COL_AT_DAT_STAIPP_438148#627543, at_datapcv#624673 AS COL_AT_DATAPCV_438149#627544, at_num_apcv#624674 AS COL_AT_NUM_APCV_438150#627545, at_heuapcv#624675 AS COL_AT_HEUAPCV_438151#627546, at_numper_sec#624676 AS COL_AT_NUMPER_SEC_438152#627547, at_ins_heure#624677 AS COL_AT_INS_HEURE_438153#627548, at_persaprev#624678 AS COL_AT_PERSAPREV_438154#627549, at_tarif#624679 AS COL_AT_TARIF_438155#627550, at_nomhl7#624680 AS COL_AT_NOMHL7_438156#627551, at_numper_ori_oid#624681 AS COL_AT_NUMPER_ORI_O_438157#627552, at_comment#624682 AS COL_AT_COMMENT_438158#627553, str_create(Cab_B) AS COL_ORIGINE_440149#627554]
Input [136]: [at_numdos#624547, at_stapat#624548, at_prefix#624549, at_nompat#624550, at_pnopat#624551, at_njfpat#624552, at_datnai#624553, at_datnaiss#624554, at_sexe#624555, at_numper#624556, at_sigma#624557, at_verrou#624558, at_poids#624559, at_indcen#624560, at_numss#624561, at_antece#624562, at_adr_1#624563, at_adr_2#624564, at_codpos#624565, at_ville#624566, at_pays#624567, at_numcai#624568, at_nummut#624569, at_numcha#624570, at_telpri#624571, at_telbur#624572, at_telpor#624573, at_fax#624574, at_prefi2#624575, at_nomass#624576, at_pnoass#624577, at_njfass#624578, at_datass#624579, at_adr_1a#624580, at_adr_2a#624581, at_codpoa#624582, at_villea#624583, at_codmed#624584, at_datcss#624585, at_datf_d#624586, at_dat100#624587, at_numsir#624588, at_numssa#624589, at_codser#624590, at_rngnai#624591, at_natass#624592, at_numacc#624593, at_datacc#624594, at_typexo#624595, at_datmaj#624596, at_coduti#624597, at_flcmu#624598, at_qualss#624599, at_codref#624600, at_codregat#624601, at_codcaiat#624602, at_indvital#624603, at_conmut#624604, at_adhmut#624605, at_garmut#624606, at_numper_ori#624607, at_codrout#624608, at_domaine#624609, at_indtrai#624610, at_idhote#624611, at_codsts#624612, at_nirind#624613, at_fldcd#624614, at_flphoto#624615, at_codmtr#624616, at_adr_3#624617, at_pays_iso#624618, at_adr_3a#624619, at_poids_maj#624620, at_codgestion#624621, at_art115#624622, at_taille#624623, at_taille_maj#624624, at_codetab_prod#624625, at_codsit_prod#624626, at_numdos_prod#624627, at_numper_prod#624628, at_numper_ori_prod#624629, at_ins#624630, at_ins_type#624631, at_ins_date#624632, at_ins_source#624633, at_stadmp#624634, at_datdmp#624635, at_alarmes#624636, at_email#624637, at_consent_sms#624638, at_dat_consent_sms#624639, at_datdcd#624640, at_flhlim#624641, at_dathlim#624642, at_codpershlim#624643, at_fldiff#624644, at_lisdest#624645, at_langue#624646, at_numcai_ft#624647, at_codtarifamc#624648, at_flgrve#624649, at_fladri#624650, at_datadri#624651, at_datf_mut#624652, at_comfac#624653, at_numdos_cloud#624654, at_nation#624655, at_titre#624656, at_titre_ass#624657, at_tiq_histoxml#624658, at_tiq_pnoliste#624659, at_codposnai#624660, at_insi#624661, at_insi_oid#624662, at_typconv#624663, at_crisec#624664, at_opereg#624665, at_flannuamc#624666, at_staipp#624667, at_pnonai#624668, at_codinseenai#624669, at_villenai#624670, at_piece_ident_pres#624671, at_dat_staipp#624672, at_datapcv#624673, at_num_apcv#624674, at_heuapcv#624675, at_numper_sec#624676, at_ins_heure#624677, at_persaprev#624678, at_tarif#624679, at_nomhl7#624680, at_numper_ori_oid#624681, at_comment#624682]
(8) LocalLimit
Input [137]: [COL_AT_NUMDOS_438023#627418, COL_AT_STAPAT_438024#627419, COL_AT_PREFIX_438025#627420, COL_AT_NOMPAT_438026#627421, COL_AT_PNOPAT_438027#627422, COL_AT_NJFPAT_438028#627423, COL_AT_DATNAI_438029#627424, COL_AT_DATNAISS_438030#627425, COL_AT_SEXE_438031#627426, COL_AT_NUMPER_438032#627427, COL_AT_SIGMA_438033#627428, COL_AT_VERROU_438034#627429, COL_AT_POIDS_438035#627430, COL_AT_INDCEN_438036#627431, COL_AT_NUMSS_438037#627432, COL_AT_ANTECE_438038#627433, COL_AT_ADR_1_438039#627434, COL_AT_ADR_2_438040#627435, COL_AT_CODPOS_438041#627436, COL_AT_VILLE_438042#627437, COL_AT_PAYS_438043#627438, COL_AT_NUMCAI_438044#627439, COL_AT_NUMMUT_438045#627440, COL_AT_NUMCHA_438046#627441, COL_AT_TELPRI_438047#627442, COL_AT_TELBUR_438048#627443, COL_AT_TELPOR_438049#627444, COL_AT_FAX_438050#627445, COL_AT_PREFI2_438051#627446, COL_AT_NOMASS_438052#627447, COL_AT_PNOASS_438053#627448, COL_AT_NJFASS_438054#627449, COL_AT_DATASS_438055#627450, COL_AT_ADR_1A_438056#627451, COL_AT_ADR_2A_438057#627452, COL_AT_CODPOA_438058#627453, COL_AT_VILLEA_438059#627454, COL_AT_CODMED_438060#627455, COL_AT_DATCSS_438061#627456, COL_AT_DATF_D_438062#627457, COL_AT_DAT100_438063#627458, COL_AT_NUMSIR_438064#627459, COL_AT_NUMSSA_438065#627460, COL_AT_CODSER_438066#627461, COL_AT_RNGNAI_438067#627462, COL_AT_NATASS_438068#627463, COL_AT_NUMACC_438069#627464, COL_AT_DATACC_438070#627465, COL_AT_TYPEXO_438071#627466, COL_AT_DATMAJ_438072#627467, COL_AT_CODUTI_438073#627468, COL_AT_FLCMU_438074#627469, COL_AT_QUALSS_438075#627470, COL_AT_CODREF_438076#627471, COL_AT_CODREGAT_438077#627472, COL_AT_CODCAIAT_438078#627473, COL_AT_INDVITAL_438079#627474, COL_AT_CONMUT_438080#627475, COL_AT_ADHMUT_438081#627476, COL_AT_GARMUT_438082#627477, COL_AT_NUMPER_ORI_438083#627478, COL_AT_CODROUT_438084#627479, COL_AT_DOMAINE_438085#627480, COL_AT_INDTRAI_438086#627481, COL_AT_IDHOTE_438087#627482, COL_AT_CODSTS_438088#627483, COL_AT_NIRIND_438089#627484, COL_AT_FLDCD_438090#627485, COL_AT_FLPHOTO_438091#627486, COL_AT_CODMTR_438092#627487, COL_AT_ADR_3_438093#627488, COL_AT_PAYS_ISO_438094#627489, COL_AT_ADR_3A_438095#627490, COL_AT_POIDS_MAJ_438096#627491, COL_AT_CODGESTION_438097#627492, COL_AT_ART115_438098#627493, COL_AT_TAILLE_438099#627494, COL_AT_TAILLE_MAJ_438100#627495, COL_AT_CODETAB_PROD_438101#627496, COL_AT_CODSIT_PROD_438102#627497, COL_AT_NUMDOS_PROD_438103#627498, COL_AT_NUMPER_PROD_438104#627499, COL_AT_NUMPER_ORI_P_438105#627500, COL_AT_INS_438106#627501, COL_AT_INS_TYPE_438107#627502, COL_AT_INS_DATE_438108#627503, COL_AT_INS_SOURCE_438109#627504, COL_AT_STADMP_438110#627505, COL_AT_DATDMP_438111#627506, COL_AT_ALARMES_438112#627507, COL_AT_EMAIL_438113#627508, COL_AT_CONSENT_SMS_438114#627509, COL_AT_DAT_CONSENT__438115#627510, COL_AT_DATDCD_438116#627511, COL_AT_FLHLIM_438117#627512, COL_AT_DATHLIM_438118#627513, COL_AT_CODPERSHLIM_438119#627514, COL_AT_FLDIFF_438120#627515, COL_AT_LISDEST_438121#627516, COL_AT_LANGUE_438122#627517, COL_AT_NUMCAI_FT_438123#627518, COL_AT_CODTARIFAMC_438124#627519, COL_AT_FLGRVE_438125#627520, COL_AT_FLADRI_438126#627521, COL_AT_DATADRI_438127#627522, COL_AT_DATF_MUT_438128#627523, COL_AT_COMFAC_438129#627524, COL_AT_NUMDOS_CLOUD_438130#627525, COL_AT_NATION_438131#627526, COL_AT_TITRE_438132#627527, COL_AT_TITRE_ASS_438133#627528, COL_AT_TIQ_HISTOXML_438134#627529, COL_AT_TIQ_PNOLISTE_438135#627530, COL_AT_CODPOSNAI_438136#627531, COL_AT_INSI_438137#627532, COL_AT_INSI_OID_438138#627533, COL_AT_TYPCONV_438139#627534, COL_AT_CRISEC_438140#627535, COL_AT_OPEREG_438141#627536, COL_AT_FLANNUAMC_438142#627537, COL_AT_STAIPP_438143#627538, COL_AT_PNONAI_438144#627539, COL_AT_CODINSEENAI_438145#627540, COL_AT_VILLENAI_438146#627541, COL_AT_PIECE_IDENT__438147#627542, COL_AT_DAT_STAIPP_438148#627543, COL_AT_DATAPCV_438149#627544, COL_AT_NUM_APCV_438150#627545, COL_AT_HEUAPCV_438151#627546, COL_AT_NUMPER_SEC_438152#627547, COL_AT_INS_HEURE_438153#627548, COL_AT_PERSAPREV_438154#627549, COL_AT_TARIF_438155#627550, COL_AT_NOMHL7_438156#627551, COL_AT_NUMPER_ORI_O_438157#627552, COL_AT_COMMENT_438158#627553, COL_ORIGINE_440149#627554]
Arguments: 1500
(9) Union
(10) CollectLimit
Input [137]: [COL_AT_NUMDOS_438023#626596, COL_AT_STAPAT_438024#626597, COL_AT_PREFIX_438025#626598, COL_AT_NOMPAT_438026#626599, COL_AT_PNOPAT_438027#626600, COL_AT_NJFPAT_438028#626601, COL_AT_DATNAI_438029#626602, COL_AT_DATNAISS_438030#626603, COL_AT_SEXE_438031#626604, COL_AT_NUMPER_438032#626605, COL_AT_SIGMA_438033#626606, COL_AT_VERROU_438034#626607, COL_AT_POIDS_438035#626608, COL_AT_INDCEN_438036#626609, COL_AT_NUMSS_438037#626610, COL_AT_ANTECE_438038#626611, COL_AT_ADR_1_438039#626612, COL_AT_ADR_2_438040#626613, COL_AT_CODPOS_438041#626614, COL_AT_VILLE_438042#626615, COL_AT_PAYS_438043#626616, COL_AT_NUMCAI_438044#626617, COL_AT_NUMMUT_438045#626618, COL_AT_NUMCHA_438046#626619, COL_AT_TELPRI_438047#626620, COL_AT_TELBUR_438048#626621, COL_AT_TELPOR_438049#626622, COL_AT_FAX_438050#626623, COL_AT_PREFI2_438051#626624, COL_AT_NOMASS_438052#626625, COL_AT_PNOASS_438053#626626, COL_AT_NJFASS_438054#626627, COL_AT_DATASS_438055#626628, COL_AT_ADR_1A_438056#626629, COL_AT_ADR_2A_438057#626630, COL_AT_CODPOA_438058#626631, COL_AT_VILLEA_438059#626632, COL_AT_CODMED_438060#626633, COL_AT_DATCSS_438061#626634, COL_AT_DATF_D_438062#626635, COL_AT_DAT100_438063#626636, COL_AT_NUMSIR_438064#626637, COL_AT_NUMSSA_438065#626638, COL_AT_CODSER_438066#626639, COL_AT_RNGNAI_438067#626640, COL_AT_NATASS_438068#626641, COL_AT_NUMACC_438069#626642, COL_AT_DATACC_438070#626643, COL_AT_TYPEXO_438071#626644, COL_AT_DATMAJ_438072#626645, COL_AT_CODUTI_438073#626646, COL_AT_FLCMU_438074#626647, COL_AT_QUALSS_438075#626648, COL_AT_CODREF_438076#626649, COL_AT_CODREGAT_438077#626650, COL_AT_CODCAIAT_438078#626651, COL_AT_INDVITAL_438079#626652, COL_AT_CONMUT_438080#626653, COL_AT_ADHMUT_438081#626654, COL_AT_GARMUT_438082#626655, COL_AT_NUMPER_ORI_438083#626656, COL_AT_CODROUT_438084#626657, COL_AT_DOMAINE_438085#626658, COL_AT_INDTRAI_438086#626659, COL_AT_IDHOTE_438087#626660, COL_AT_CODSTS_438088#626661, COL_AT_NIRIND_438089#626662, COL_AT_FLDCD_438090#626663, COL_AT_FLPHOTO_438091#626664, COL_AT_CODMTR_438092#626665, COL_AT_ADR_3_438093#626666, COL_AT_PAYS_ISO_438094#626667, COL_AT_ADR_3A_438095#626668, COL_AT_POIDS_MAJ_438096#626669, COL_AT_CODGESTION_438097#626670, COL_AT_ART115_438098#626671, COL_AT_TAILLE_438099#626672, COL_AT_TAILLE_MAJ_438100#626673, COL_AT_CODETAB_PROD_438101#626674, COL_AT_CODSIT_PROD_438102#626675, COL_AT_NUMDOS_PROD_438103#626676, COL_AT_NUMPER_PROD_438104#626677, COL_AT_NUMPER_ORI_P_438105#626678, COL_AT_INS_438106#626679, COL_AT_INS_TYPE_438107#626680, COL_AT_INS_DATE_438108#626681, COL_AT_INS_SOURCE_438109#626682, COL_AT_STADMP_438110#626683, COL_AT_DATDMP_438111#626684, COL_AT_ALARMES_438112#626685, COL_AT_EMAIL_438113#626686, COL_AT_CONSENT_SMS_438114#626687, COL_AT_DAT_CONSENT__438115#626688, COL_AT_DATDCD_438116#626689, COL_AT_FLHLIM_438117#626690, COL_AT_DATHLIM_438118#626691, COL_AT_CODPERSHLIM_438119#626692, COL_AT_FLDIFF_438120#626693, COL_AT_LISDEST_438121#626694, COL_AT_LANGUE_438122#626695, COL_AT_NUMCAI_FT_438123#626696, COL_AT_CODTARIFAMC_438124#626697, COL_AT_FLGRVE_438125#626698, COL_AT_FLADRI_438126#626699, COL_AT_DATADRI_438127#626700, COL_AT_DATF_MUT_438128#626701, COL_AT_COMFAC_438129#626702, COL_AT_NUMDOS_CLOUD_438130#626703, COL_AT_NATION_438131#626704, COL_AT_TITRE_438132#626705, COL_AT_TITRE_ASS_438133#626706, COL_AT_TIQ_HISTOXML_438134#626707, COL_AT_TIQ_PNOLISTE_438135#626708, COL_AT_CODPOSNAI_438136#626709, COL_AT_INSI_438137#626710, COL_AT_INSI_OID_438138#626711, COL_AT_TYPCONV_438139#626712, COL_AT_CRISEC_438140#626713, COL_AT_OPEREG_438141#626714, COL_AT_FLANNUAMC_438142#626715, COL_AT_STAIPP_438143#626716, COL_AT_PNONAI_438144#626717, COL_AT_CODINSEENAI_438145#626718, COL_AT_VILLENAI_438146#626719, COL_AT_PIECE_IDENT__438147#626720, COL_AT_DAT_STAIPP_438148#626721, COL_AT_DATAPCV_438149#626722, COL_AT_NUM_APCV_438150#626723, COL_AT_HEUAPCV_438151#626724, COL_AT_NUMPER_SEC_438152#626725, COL_AT_INS_HEURE_438153#626726, COL_AT_PERSAPREV_438154#626727, COL_AT_TARIF_438155#626728, COL_AT_NOMHL7_438156#626729, COL_AT_NUMPER_ORI_O_438157#626730, COL_AT_COMMENT_438158#626731, COL_ORIGINE_440149#626732]
Arguments: 1500