{"id":3750,"date":"2017-08-21T14:42:22","date_gmt":"2017-08-21T14:42:22","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-resolve-netsuite-saved-search-issues-with-dot-in-text-field-criteria-2\/"},"modified":"2026-07-28T18:26:05","modified_gmt":"2026-07-28T18:26:05","slug":"comment-resoudre-les-problemes-lies-aux-recherches-enregistrees-dans-netsuite-lorsque-le-critere-dun-champ-de-texte-contient-un-point","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-resoudre-les-problemes-lies-aux-recherches-enregistrees-dans-netsuite-lorsque-le-critere-dun-champ-de-texte-contient-un-point\/","title":{"rendered":"Comment r\u00e9soudre les probl\u00e8mes li\u00e9s aux recherches enregistr\u00e9es dans NetSuite lorsque le crit\u00e8re d’un champ de texte contient un point"},"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":"Lorsque les crit\u00e8res de champ de texte standard dans les recherches enregistr\u00e9es de NetSuite ne renvoient pas les r\u00e9sultats escompt\u00e9s en raison de caract\u00e8res sp\u00e9ciaux tels qu\u2019un point, un crit\u00e8re \u00ab Formule (Texte) \u00bb offre une solution de contournement fiable.","ga_short_answer":"Une recherche enregistr\u00e9e dans NetSuite peut ne renvoyer aucun r\u00e9sultat si un crit\u00e8re de champ de texte long contient un point (par exemple, dans une URL). Les crit\u00e8res de texte standard peuvent \u00eatre affect\u00e9s par les r\u00e8gles de nettoyage des requ\u00eates de base de donn\u00e9es. Pour r\u00e9soudre ce probl\u00e8me, utilisez plut\u00f4t le crit\u00e8re `Formula(Text)`. Cette m\u00e9thode g\u00e8re correctement les caract\u00e8res sp\u00e9ciaux, garantissant ainsi des r\u00e9sultats de recherche pr\u00e9cis.","ga_scenario":"Une recherche enregistr\u00e9e NetSuite est configur\u00e9e pour effectuer une recherche dans un champ de texte long. Lorsque le crit\u00e8re de recherche comprend un caract\u00e8re sp\u00e9cial, en l\u2019occurrence un point (.), comme dans une URL telle que \u00ab google.com \u00bb, la recherche ne renvoie aucun r\u00e9sultat. En revanche, la recherche du m\u00eame texte sans le point (par exemple, \u00ab google \u00bb) donne des r\u00e9sultats corrects. Cela sugg\u00e8re un probl\u00e8me potentiel de validation des requ\u00eates de base de donn\u00e9es affectant les crit\u00e8res des champs de texte standard.","ga_solution":"Les tentatives visant \u00e0 r\u00e9soudre le probl\u00e8me en ajoutant des guillemets simples aux crit\u00e8res de recherche se sont sold\u00e9es par un \u00e9chec. La solution efficace consiste \u00e0 utiliser le crit\u00e8re `Formula(Text)` dans la recherche enregistr\u00e9e de NetSuite. Cette approche permet de contourner le probl\u00e8me avec succ\u00e8s, ce qui permet \u00e0 la recherche de traiter correctement les crit\u00e8res contenant des points ou d\u2019autres caract\u00e8res sp\u00e9ciaux sans rencontrer de probl\u00e8mes de nettoyage des donn\u00e9es.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:42:22-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Saved Search not returning results - Issue with Text Field criteria","ga_ans_id":"ANS-0091","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":[92],"class_list":["post-3750","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-niveau-intermediaire"],"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":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3750","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\/3750\/revisions"}],"predecessor-version":[{"id":5671,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3750\/revisions\/5671"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3750"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3750"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3750"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}