{"id":3711,"date":"2017-08-21T15:20:56","date_gmt":"2017-08-21T15:20:56","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-correctly-use-quotation-marks-in-netsuite-saved-search-formula-text-columns-2\/"},"modified":"2026-07-28T18:26:03","modified_gmt":"2026-07-28T18:26:03","slug":"comment-utiliser-correctement-les-guillemets-dans-les-colonnes-de-type-texte-des-formules-de-recherche-enregistrees-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-utiliser-correctement-les-guillemets-dans-les-colonnes-de-type-texte-des-formules-de-recherche-enregistrees-dans-netsuite\/","title":{"rendered":"Comment utiliser correctement les guillemets dans les colonnes de type \u00ab Texte \u00bb des formules de recherche enregistr\u00e9es 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":"D\u00e9couvrez comment structurer correctement les instructions CASE avec des valeurs de cha\u00eene de caract\u00e8res dans les champs de formule des recherches enregistr\u00e9es de NetSuite afin d\u2019\u00e9viter les erreurs de syntaxe.","ga_short_answer":"Pour utiliser correctement les guillemets avec les litt\u00e9raux de cha\u00eene dans une colonne \u00ab formulatext \u00bb d\u2019une recherche enregistr\u00e9e NetSuite, placez l\u2019int\u00e9gralit\u00e9 de l\u2019instruction CASE entre une seule paire de guillemets doubles. Par exemple, utilisez \u00ab CASE WHEN {item} IS NULL THEN 'expense' ELSE 'item' END \u00bb pour d\u00e9finir des sorties de texte conditionnelles.","ga_scenario":"Les utilisateurs rencontrent souvent des probl\u00e8mes lorsqu\u2019ils tentent de d\u00e9finir des sorties de texte conditionnelles dans une recherche enregistr\u00e9e NetSuite \u00e0 l\u2019aide d\u2019une colonne \u00ab formulatext \u00bb. Plus pr\u00e9cis\u00e9ment, des difficult\u00e9s surviennent lors de l\u2019int\u00e9gration de cha\u00eenes litt\u00e9rales, telles que \u00ab expense \u00bb ou \u00ab item \u00bb, au sein d\u2019une instruction CASE, ce qui entra\u00eene des erreurs de syntaxe ou des r\u00e9sultats inattendus.","ga_solution":"Pour mettre en \u0153uvre correctement la logique de texte conditionnelle dans une colonne \u00ab Formulatext \u00bb d\u2019une recherche enregistr\u00e9e NetSuite, l\u2019instruction CASE dans son int\u00e9gralit\u00e9, y compris toutes les cha\u00eenes litt\u00e9rales, doit \u00eatre plac\u00e9e entre une seule paire de guillemets doubles. Cela garantit que la formule est analys\u00e9e correctement par NetSuite. Par exemple, pour classer les enregistrements en fonction de la pr\u00e9sence ou non d\u2019un \u00e9l\u00e9ment, la syntaxe suivante doit \u00eatre utilis\u00e9e : \u00ab CASE WHEN {item} IS NULL THEN 'expense' ELSE 'item' END \u00bb","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:20:56+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"quotation marks in saved search formulatext column","ga_ans_id":"ANS-0052","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":[10],"ga_difficulty":[92],"class_list":["post-3711","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-developer-suitescript","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":10,"label":"Developer\/SuiteScript"}],"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\/3711","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\/3711\/revisions"}],"predecessor-version":[{"id":5632,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3711\/revisions\/5632"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3711"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3711"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3711"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}