{"id":2481,"date":"2019-09-19T15:50:08","date_gmt":"2019-09-19T15:50:08","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-utiliser-les-identifiants-de-champ-dans-les-formules-case-when-de-netsuite-contenant-des-apostrophes\/"},"modified":"2026-07-28T18:26:00","modified_gmt":"2026-07-28T18:26:00","slug":"comment-utiliser-les-identifiants-de-champ-dans-les-formules-case-when-de-netsuite-contenant-des-apostrophes","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-utiliser-les-identifiants-de-champ-dans-les-formules-case-when-de-netsuite-contenant-des-apostrophes\/","title":{"rendered":"Comment utiliser les identifiants de champ dans les formules CASE WHEN de NetSuite contenant des apostrophes"},"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":"Lors de la cr\u00e9ation de formules CASE WHEN dans NetSuite, le fait de faire r\u00e9f\u00e9rence aux identifiants internes des champs peut r\u00e9soudre les probl\u00e8mes li\u00e9s aux apostrophes dans les comparaisons de cha\u00eenes de caract\u00e8res.","ga_short_answer":"Pour impl\u00e9menter correctement une formule CASE WHEN dans NetSuite lorsqu\u2019un mot-cl\u00e9 de test logique contient une apostrophe, utilisez l\u2019identifiant interne du champ plut\u00f4t que son nom d\u2019affichage. Par exemple, lorsque vous traitez des types de comptes, faites r\u00e9f\u00e9rence \u00e0 {account.type.id} afin de garantir une \u00e9valuation correcte et d\u2019\u00e9viter les erreurs de syntaxe caus\u00e9es par des caract\u00e8res sp\u00e9ciaux.","ga_scenario":"Les utilisateurs peuvent rencontrer des difficult\u00e9s lors de la cr\u00e9ation d\u2019une <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-calculate-rolling-12-month-sales-in-netsuite-saved-searches\/\">formule CASE WHEN dans NetSuite<\/a> lorsque le test logique contient un mot-cl\u00e9 comportant une apostrophe. Cette situation peut entra\u00eener des erreurs de syntaxe ou une \u00e9valuation incorrecte de la formule, car l\u2019apostrophe peut \u00eatre interpr\u00e9t\u00e9e \u00e0 tort comme un d\u00e9limiteur de cha\u00eene, emp\u00eachant ainsi l\u2019analyse correcte de la formule.","ga_solution":"Pour r\u00e9soudre le probl\u00e8me li\u00e9 \u00e0 l'inclusion d'un mot-cl\u00e9 comportant une apostrophe dans le test logique d'une formule CASE WHEN, il est recommand\u00e9 d'utiliser l'identifiant interne du champ. Par exemple, pour r\u00e9f\u00e9rencer correctement le type de compte dans une telle formule, il convient d'utiliser l'identifiant interne suivant :\n\n```\n{account.type.id}\n```","ga_source_author":"Jean-Mathieu Rose","ga_source_author_email":"","ga_date_original":"2019-09-19T08:50:08-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"How can I do a 'case when' formula when a keyword in my logical test has an apostrophe?","ga_ans_id":"ANS-0005","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,89],"ga_difficulty":[93,93],"class_list":["post-2481","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"},{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"},{"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\/2481","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\/2481\/revisions"}],"predecessor-version":[{"id":2501,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2481\/revisions\/2501"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2481"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2481"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2481"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}