{"id":3759,"date":"2017-08-21T14:33:27","date_gmt":"2017-08-21T14:33:27","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-exclude-duplicate-records-from-a-netsuite-saved-search-2\/"},"modified":"2026-07-28T18:26:06","modified_gmt":"2026-07-28T18:26:06","slug":"comment-exclure-les-enregistrements-en-double-dune-recherche-enregistree-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-exclure-les-enregistrements-en-double-dune-recherche-enregistree-dans-netsuite\/","title":{"rendered":"Comment exclure les enregistrements en double d’une recherche enregistr\u00e9e 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":"Ce guide d\u00e9crit une m\u00e9thode permettant de filtrer les entr\u00e9es en double dans les r\u00e9sultats des recherches enregistr\u00e9es de NetSuite en utilisant des crit\u00e8res sp\u00e9cifiques et des regroupements de r\u00e9sultats.","ga_short_answer":"Pour exclure les doublons, configurez vos crit\u00e8res de recherche enregistr\u00e9s afin de filtrer par statut et par formule num\u00e9rique. Dans les r\u00e9sultats, utilisez des fonctions de regroupement et d\u2019agr\u00e9gation telles que \u00ab minimum \u00bb et \u00ab maximum \u00bb sur les champs cl\u00e9s, ainsi qu\u2019un tri d\u00e9croissant sur une formule num\u00e9rique, afin de vous assurer que seuls les enregistrements uniques s\u2019affichent.","ga_scenario":"Les utilisateurs sont souvent confront\u00e9s \u00e0 des situations o\u00f9 les recherches enregistr\u00e9es dans NetSuite renvoient plusieurs enregistrements identiques, ce qui entra\u00eene des rapports encombr\u00e9s ou inexacts. L\u2019objectif est d\u2019affiner ces recherches afin de n\u2019afficher que des entr\u00e9es uniques, en particulier lors du suivi des changements de statut et des dates associ\u00e9es.","ga_solution":"Pour exclure les doublons d\u2019une recherche enregistr\u00e9e dans NetSuite, configurez la recherche \u00e0 l\u2019aide des crit\u00e8res et des param\u00e8tres de r\u00e9sultats suivants : Crit\u00e8res : statut : est \u00ab en attente de validation client \/ pr\u00eat \u00e0 \u00eatre publi\u00e9 \u00bb ; formule (num\u00e9rique) :\n\n```\nCASE WHEN {systemnotes.newvalue} 'Pending Customer Review \/ Ready toRelease' OR {systemnotes.newvalue} 'Pending Customer Review \/ Release' THENround({today} - {systemnotes.date}) ELSE -1 END\n```\n\nCette formule doit \u00eatre d\u00e9finie sur \u00ab diff\u00e9rent de -1 \u00bb. R\u00e9sultats : trier par : formule (num\u00e9rique), par ordre d\u00e9croissant ; formule (num\u00e9rique) (minimum) :\n\n```\nCASE WHEN {systemnotes.newvalue} 'Pending Customer Review \/ Ready toRelease' OR {systemnotes.newvalue} 'Pending Customer Review \/ Release' THENround({today} - {systemnotes.date}) ELSE -1 END\n```\n\nformule (texte) (groupe)sujet (groupe)soci\u00e9t\u00e9 (maximum)date de d\u00e9but (maximum)date d\u2019\u00e9ch\u00e9ance (maximum)","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:33:27-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Excluding duplicates from a saved search","ga_ans_id":"ANS-0100","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-3759","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\/3759","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\/3759\/revisions"}],"predecessor-version":[{"id":5680,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3759\/revisions\/5680"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3759"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3759"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3759"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}