{"id":3718,"date":"2023-02-14T16:58:06","date_gmt":"2023-02-14T16:58:06","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/what-statements-can-be-used-in-netsuite-case-when-functions-2\/"},"modified":"2026-07-28T18:26:03","modified_gmt":"2026-07-28T18:26:03","slug":"quelles-instructions-peuvent-etre-utilisees-dans-les-fonctions-case-when-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/quelles-instructions-peuvent-etre-utilisees-dans-les-fonctions-case-when-de-netsuite\/","title":{"rendered":"Quelles instructions peuvent \u00eatre utilis\u00e9es dans les fonctions CASE WHEN de 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 fonctions CASE WHEN de NetSuite prennent en charge diverses instructions logiques et de comparaison permettant de cr\u00e9er une logique conditionnelle robuste pour l'analyse des donn\u00e9es et les champs personnalis\u00e9s.","ga_short_answer":"La fonction CASE WHEN de NetSuite prend en charge AND pour les conditions multiples, OR pour les conditions alternatives, IN pour les \u00e9num\u00e9rations, LIKE pour les motifs de cha\u00eenes de caract\u00e8res et BETWEEN pour les plages de valeurs. Il est possible d\u2019utiliser plusieurs clauses WHEN\/THEN ou la fonction DECODE pour obtenir des r\u00e9sultats vari\u00e9s, et la valeur NULL annule les op\u00e9rateurs tels que NOT IN ou NOT LIKE.","ga_scenario":"Les utilisateurs ont souvent besoin de mettre en \u0153uvre une logique conditionnelle complexe au sein des recherches enregistr\u00e9es, des champs personnalis\u00e9s ou des workflows de NetSuite. Cela n\u00e9cessite d\u2019\u00e9valuer plusieurs crit\u00e8res ou des mod\u00e8les de donn\u00e9es sp\u00e9cifiques afin de renvoyer des r\u00e9sultats diff\u00e9rents en fonction de diverses conditions. Il est essentiel de bien comprendre les instructions appropri\u00e9es pour les fonctions CASE WHEN afin de cr\u00e9er des expressions efficaces et dynamiques.","ga_solution":"La fonction CASE WHEN de NetSuite prend en charge plusieurs instructions cl\u00e9s pour la logique conditionnelle :\n\nL\u2019instruction AND est utilis\u00e9e lorsque plusieurs param\u00e8tres d\u2019un test logique doivent tous \u00eatre vrais pour que le r\u00e9sultat sp\u00e9cifi\u00e9 soit renvoy\u00e9. Par exemple :\n```\nCASE WHEN {type}='Inventory Adjustment' AND {quantity} >= 0 THEN \u2026\n```\n\nL\u2019instruction OR est utilis\u00e9e lorsqu\u2019au moins un des param\u00e8tres du test logique doit \u00eatre vrai pour que le r\u00e9sultat sp\u00e9cifi\u00e9 soit renvoy\u00e9. Par exemple :\n```\nCASE WHEN {account} LIKE '%5143%' OR {memo} LIKE '%Transport inventaire%' THEN \u2026\n```\n\nL\u2019instruction IN est utilis\u00e9e pour les \u00e9num\u00e9rations ; elle offre un moyen concis de v\u00e9rifier plusieurs valeurs sans avoir \u00e0 utiliser plusieurs instructions OR. Par exemple :\nLorsqu\u2019il n\u2019y a qu\u2019un seul param\u00e8tre :\n```\nCASE WHEN {accounttype} = 'Income' THEN \u2026\n```\n\nLorsqu\u2019il y a plusieurs param\u00e8tres :\n```\nCASE WHEN {type} IN ('Cash Sale','Invoice') THEN \u2026\n```\n\n\n\nL'instruction \u00ab LIKE \u00bb est utilis\u00e9e pour <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/can-wildcard-characters-be-used-to-filter-free-form-text-custom-fields-in-netsuite\/\">rechercher une cha\u00eene de caract\u00e8res sp\u00e9cifique au sein de la valeur d&#039;un champ<\/a>\n\n. Elle prend en charge divers sc\u00e9narios de correspondance de motifs. Par exemple :\nCorrespondance exacte :\n```\nCASE WHEN ({memo} LIKE 'Insurance') THEN \u2026\n```\n\nCommence par :\n```\nCASE WHEN ({memo} LIKE 'Insurance%') THEN \u2026\n```\n\nSe termine par :\n```\nCASE WHEN ({memo} LIKE '%Insurance') THEN \u2026\n```\n\nContient :\n```\nCASE WHEN ({memo} LIKE '%Insurance%') THEN \u2026\n```\n\nL\u2019instruction BETWEEN est utilis\u00e9e lorsqu\u2019un test logique doit \u00e9valuer des valeurs comprises dans une plage sp\u00e9cifique, ce qui \u00e9vite d\u2019avoir \u00e0 recourir \u00e0 des instructions \u00ab sup\u00e9rieur \u00e0 ET inf\u00e9rieur \u00e0 \u00bb. Par exemple :\n```\nCASE WHEN {trandate} BETWEEN {accountingperiod.startdate} and {accountingperiod.enddate}\n```\n\nPlusieurs combinaisons WHEN\/THEN ou la fonction DECODE peuvent \u00eatre utilis\u00e9es lorsque diff\u00e9rentes valeurs dans le test logique sont cens\u00e9es renvoyer des r\u00e9sultats diff\u00e9rents. Par exemple :\n```\nCASE WHEN {accounttype} = 'Accounts Receivable' THEN {customer.representingsubsidiary} WHEN {accounttype} = 'Accounts Payable' THEN {vendorline.representingsubsidiary} ELSE NULL END\n```\n\n\n```\nDECODE({accounttype},'Accounts Receivable',{customer.representingsubsidiary},'Accounts Payable',{vendorline.representingsubsidiary},null)\n```\n\nL\u2019instruction NULL sert \u00e0 inverser un op\u00e9rateur. Par exemple :\n`NOT NULL`\n\nest l\u2019oppos\u00e9 de GA_KEEP_0013 ;\n\n\n`NOT IN`\n\nest l\u2019oppos\u00e9 de GA_KEEP_0015 ;\n\n\n`NOT LIKE`\n\nest l\u2019oppos\u00e9 de `LIKE`","ga_source_author":"Jean-Mathieu Rose","ga_source_author_email":"","ga_date_original":"2023-02-14T08:58:06-08:00","ga_date_verified":"","ga_source_subject":"What statements can be used in a CASE WHEN function?","ga_ans_id":"ANS-0059","ga_publish_decision":"publish","ga_staleness_risk":"low","ga_review_priority":"trust_default","ga_tier2_verdict":"","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3718","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\/3718","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\/3718\/revisions"}],"predecessor-version":[{"id":5639,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3718\/revisions\/5639"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3718"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3718"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3718"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}