{"id":3744,"date":"2017-08-21T14:35:54","date_gmt":"2017-08-21T14:35:54","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-filter-netsuite-saved-search-results-by-logged-in-partner-user-2\/"},"modified":"2026-07-28T18:26:05","modified_gmt":"2026-07-28T18:26:05","slug":"comment-filtrer-les-resultats-dune-recherche-enregistree-dans-netsuite-en-fonction-de-lutilisateur-partenaire-connecte","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-filtrer-les-resultats-dune-recherche-enregistree-dans-netsuite-en-fonction-de-lutilisateur-partenaire-connecte\/","title":{"rendered":"Comment filtrer les r\u00e9sultats d’une recherche enregistr\u00e9e dans NetSuite en fonction de l’utilisateur partenaire connect\u00e9"},"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 traite d\u2019un probl\u00e8me courant : le mot-cl\u00e9 {me} utilis\u00e9 dans les formules de recherche enregistr\u00e9es de NetSuite ne parvient pas \u00e0 identifier correctement l\u2019utilisateur actuel du centre de partenariat. Il propose une solution fiable.","ga_short_answer":"Pour filtrer correctement les r\u00e9sultats d\u2019une recherche enregistr\u00e9e dans NetSuite pour l\u2019utilisateur connect\u00e9 au Centre des partenaires, int\u00e9grez la formule DECODE dans une instruction CASE WHEN. Cela garantit que le mot-cl\u00e9 {me} est \u00e9valu\u00e9 comme une formule ou un champ plut\u00f4t que comme une cha\u00eene litt\u00e9rale, ce qui permet un filtrage dynamique bas\u00e9 sur la fiche partenaire de l\u2019utilisateur actuel.","ga_scenario":"Lorsqu\u2019ils tentent de cr\u00e9er une recherche enregistr\u00e9e NetSuite qui filtre dynamiquement les r\u00e9sultats en fonction de l\u2019utilisateur actuellement connect\u00e9 au Centre des partenaires, les administrateurs peuvent rencontrer un probl\u00e8me. Le mot-cl\u00e9 {me}, lorsqu\u2019il est utilis\u00e9 directement dans un crit\u00e8re de texte de formule, est souvent interpr\u00e9t\u00e9 comme une cha\u00eene litt\u00e9rale plut\u00f4t que comme une r\u00e9f\u00e9rence dynamique \u00e0 l\u2019enregistrement de l\u2019utilisateur actuel, ce qui entra\u00eene des r\u00e9sultats incorrects ou l\u2019absence de r\u00e9sultats.","ga_solution":"Pour r\u00e9soudre ce probl\u00e8me, la formule DECODE doit \u00eatre plac\u00e9e entre les balises d\u2019une instruction CASE WHEN, en v\u00e9rifiant sp\u00e9cifiquement s\u2019il existe une correspondance avec le mot-cl\u00e9 {me}. Cette approche oblige NetSuite \u00e0 interpr\u00e9ter correctement {me} comme une r\u00e9f\u00e9rence de champ dynamique, ce qui permet \u00e0 la recherche de filtrer les r\u00e9sultats en fonction de l\u2019utilisateur connect\u00e9 au Partner Center. La formule \u00e0 utiliser dans les crit\u00e8res de recherche enregistr\u00e9s est la suivante :\n\n```\nCASE WHEN DECODE({partnerteammember},{custbody_sales_team_rep_1.custentity_partnerrecord},{custbody_sales_team_rep_1.custentity_sf_supervisor_partner.id},{custbody_sales_team_rep_2.custentity_partnerrecord}){me} THEN '1' ELSE '0' END *is* 1\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:35:54+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to get a saved search with results for different user logged in a Partner Center?","ga_ans_id":"ANS-0085","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-3744","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\/3744","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\/3744\/revisions"}],"predecessor-version":[{"id":5665,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3744\/revisions\/5665"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3744"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3744"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3744"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}