{"id":3775,"date":"2017-08-21T15:16:16","date_gmt":"2017-08-21T15:16:16","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-filter-netsuite-transaction-searches-by-customer-name-range-using-formulas-2\/"},"modified":"2026-07-28T18:26:06","modified_gmt":"2026-07-28T18:26:06","slug":"comment-filtrer-les-recherches-de-transactions-netsuite-par-plage-de-noms-de-clients-a-laide-de-formules","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-filtrer-les-recherches-de-transactions-netsuite-par-plage-de-noms-de-clients-a-laide-de-formules\/","title":{"rendered":"Comment filtrer les recherches de transactions NetSuite par plage de noms de clients \u00e0 l’aide de formules"},"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":"Apprenez \u00e0 mettre en \u0153uvre des filtres avanc\u00e9s bas\u00e9s sur des formules dans NetSuite SuiteScript afin d\u2019affiner avec pr\u00e9cision les r\u00e9sultats de recherche de transactions en fonction d\u2019une plage alphab\u00e9tique sp\u00e9cifi\u00e9e de noms de clients.","ga_short_answer":"Pour filtrer les recherches de transactions NetSuite en fonction d\u2019une plage de noms de clients, utilisez un filtre de recherche \u00ab formulatext \u00bb. Cela implique de cr\u00e9er une formule SQL CASE WHEN qui \u00e9value UPPER(SUBSTR({customer.companyname},0,length)) par rapport aux cha\u00eenes de caract\u00e8res de d\u00e9but et de fin que vous avez d\u00e9finies. Cette m\u00e9thode permet un filtrage par plage flexible, ind\u00e9pendant de la longueur des caract\u00e8res, au sein de SuiteScript.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019affiner leurs recherches de transactions dans NetSuite afin de n\u2019inclure que les clients dont les noms se situent dans une plage alphab\u00e9tique sp\u00e9cifique. Les filtres de recherche standard peuvent ne pas offrir la flexibilit\u00e9 requise pour un filtrage par plage dynamique, ind\u00e9pendant de la longueur des caract\u00e8res, en particulier lorsque les points de d\u00e9part et d\u2019arriv\u00e9e de la plage peuvent varier.","ga_solution":"Pour obtenir un filtre flexible sur la plage de noms de clients dans une recherche de transactions NetSuite, il est possible de mettre en \u0153uvre un filtre \u00ab formulatext \u00bb \u00e0 l\u2019aide de SuiteScript. Cette approche exploite les fonctions SQL au sein d\u2019une formule afin de comparer des sous-cha\u00eenes du nom de la soci\u00e9t\u00e9 du client aux valeurs de d\u00e9but et de fin de plage sp\u00e9cifi\u00e9es. Commencez par d\u00e9finir les variables `custNameStartRange` et `custNameEndRange` sous forme de cha\u00eenes de caract\u00e8res repr\u00e9sentant respectivement le d\u00e9but et la fin de la plage de noms souhait\u00e9e. Construisez ensuite la cha\u00eene de formule comme suit :\n\n`GA_KEEP_0001`\n\n. Enfin, ajoutez cette formule en tant que filtre `formulatext` \u00e0 votre recherche. Dans SuiteScript 2.x, cela s\u2019effectue \u00e0 l\u2019aide de la m\u00e9thode search.createFilter :\n\n```\nfilters.push(search.createFilter({name: 'formulatext',operator: 'is',values: ['1'],formula: formula}));\n```\n\nCette m\u00e9thode permet d\u2019effectuer un filtrage en fonction d\u2019un nombre quelconque de caract\u00e8res de part et d\u2019autre de la plage, offrant ainsi une solution robuste pour les recherches dynamiques portant sur des plages de noms de clients.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:16:16-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How can I add a filter to my transaction search to get a range of customer names?","ga_ans_id":"ANS-0116","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The use of `nlobjSearchFilter` is specific to SuiteScript 1.0, which has been largely superseded by SuiteScript 2.x. The current equivalent is `search.createFilter`.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[10],"ga_difficulty":[94],"class_list":["post-3775","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-avance"],"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":94,"label":"Avanc\u00e9"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3775","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\/3775\/revisions"}],"predecessor-version":[{"id":5696,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3775\/revisions\/5696"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3775"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3775"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3775"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}