{"id":3729,"date":"2017-08-21T15:07:51","date_gmt":"2017-08-21T15:07:51","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/can-wildcard-characters-be-used-to-filter-free-form-text-custom-fields-in-netsuite-2\/"},"modified":"2026-07-28T18:26:04","modified_gmt":"2026-07-28T18:26:04","slug":"peut-on-utiliser-des-caracteres-generiques-pour-filtrer-les-champs-personnalises-de-type-texte-libre-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/peut-on-utiliser-des-caracteres-generiques-pour-filtrer-les-champs-personnalises-de-type-texte-libre-dans-netsuite\/","title":{"rendered":"Peut-on utiliser des caract\u00e8res g\u00e9n\u00e9riques pour filtrer les champs personnalis\u00e9s de type \u00ab texte libre \u00bb dans NetSuite ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Les utilisateurs de NetSuite peuvent tirer parti des caract\u00e8res g\u00e9n\u00e9riques de l'op\u00e9rateur LIKE d'Oracle PL\/SQL pour am\u00e9liorer les capacit\u00e9s de recherche dans les champs de texte libre personnalis\u00e9s.","ga_short_answer":"Oui, les caract\u00e8res g\u00e9n\u00e9riques peuvent \u00eatre utilis\u00e9s pour filtrer les r\u00e9sultats dans NetSuite \u00e0 l'aide d'un champ personnalis\u00e9 de type \u00ab Texte libre \u00bb. L'op\u00e9rateur LIKE d'Oracle PL\/SQL permet la correspondance conditionnelle de termes \u00e0 l'aide du signe pourcentage (\u00ab % \u00bb) et du trait de soulignement (\u00ab _ \u00bb) comme op\u00e9rateurs g\u00e9n\u00e9riques.","ga_scenario":"Lorsqu\u2019ils effectuent des recherches dans NetSuite, les utilisateurs peuvent avoir besoin de <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-netsuite-saved-searches-leverage-formulas-in-available-filters\/\">filtrer les r\u00e9sultats en fonction d\u2019un champ personnalis\u00e9<\/a> de type \u00ab Texte libre \u00bb. La difficult\u00e9 survient lorsqu\u2019ils tentent de faire correspondre des cha\u00eenes partielles ou des motifs au sein du champ de texte plut\u00f4t que des valeurs exactes.","ga_solution":"Pour filtrer les r\u00e9sultats \u00e0 l\u2019aide d\u2019un champ personnalis\u00e9 de type \u00ab Texte libre \u00bb comportant des caract\u00e8res g\u00e9n\u00e9riques, vous pouvez utiliser l\u2019op\u00e9rateur LIKE de Oracle PL\/SQL. Cet op\u00e9rateur permet de faire correspondre ou de tester un terme conditionnel \u00e0 l\u2019aide d\u2019une recherche avec caract\u00e8res g\u00e9n\u00e9riques. Les deux principaux op\u00e9rateurs de caract\u00e8res g\u00e9n\u00e9riques sont le signe pourcentage (`%`) et le trait de soulignement (`_`). Par exemple, si un enregistrement contient la cha\u00eene \u00ab 1234,2334,2212 \u00bb, l\u2019application du filtre `%2334%` renverra cet enregistrement. Vous trouverez de plus amples informations sur l\u2019op\u00e9rateur LIKE \u00e0 l\u2019adresse http:\/\/psoug.org\/definition\/LIKE.htm.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:07:51-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Can wildcard characters be used when filtering results using a custom field of type Free Form Text?","ga_ans_id":"ANS-0070","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[93],"class_list":["post-3729","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3729\/revisions"}],"predecessor-version":[{"id":5650,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3729\/revisions\/5650"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3729"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3729"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3729"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}