{"id":2655,"date":"2017-08-21T15:15:34","date_gmt":"2017-08-21T15:15:34","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-filter-for-empty-list-record-fields-in-netsuite-scripted-searches-2\/"},"modified":"2026-07-28T18:25:06","modified_gmt":"2026-07-28T18:25:06","slug":"comment-filtrer-les-champs-vides-dune-liste-ou-dun-enregistrement-dans-les-recherches-scriptees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-filtrer-les-champs-vides-dune-liste-ou-dun-enregistrement-dans-les-recherches-scriptees-de-netsuite\/","title":{"rendered":"Comment filtrer les champs vides d’une liste ou d’un enregistrement dans les recherches script\u00e9es 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":"D\u00e9couvrez la m\u00e9thode SuiteScript 2.0 appropri\u00e9e pour identifier les enregistrements dans lesquels une liste ou un champ d'enregistrement sp\u00e9cifique est vide \u00e0 l'aide de la valeur \u00ab @NONE@ \u00bb.","ga_short_answer":"Pour rechercher des champs de liste ou d'enregistrement vides dans les recherches script\u00e9es de NetSuite, utilisez la valeur \u00ab @NONE@ \u00bb avec l'op\u00e9rateur ANYOF ou NONEOF. Dans SuiteScript 2.0, cela s'effectue \u00e0 l'aide de la fonction search.createFilter avec l'identifiant interne du champ et search.Operator.ANYOF ou search.Operator.NONEOF pour le param\u00e8tre de valeur : ['@NONE@'].","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019identifier dans NetSuite les enregistrements pour lesquels une liste ou un champ d\u2019enregistrement sp\u00e9cifique ne comporte aucune valeur. Ce besoin se pr\u00e9sente g\u00e9n\u00e9ralement lors du nettoyage des donn\u00e9es, de la cr\u00e9ation de rapports ou de l\u2019automatisation de processus qui d\u00e9pendent de la pr\u00e9sence ou de l\u2019absence d\u2019enregistrements li\u00e9s ou de s\u00e9lections. Les filtres de recherche standard ne permettent pas toujours de d\u00e9terminer intuitivement comment cibler ces champs vides dans le cadre d\u2019un script.","ga_solution":"Pour identifier les enregistrements dans lesquels un champ de liste ou d\u2019enregistrement sp\u00e9cifique est vide au sein d\u2019une recherche script\u00e9e NetSuite, utilisez la valeur \u00ab @NONE@ \u00bb avec l\u2019op\u00e9rateur ANYOF ou NONEOF. Dans SuiteScript 2.0, cela s\u2019effectue en cr\u00e9ant un filtre de recherche \u00e0 l\u2019aide de la m\u00e9thode search.createFilter.\n1. Assurez-vous que votre script SuiteScript 2.0 charge le module N\/search.\n2. Cr\u00e9ez le filtre en utilisant l\u2019identifiant interne du champ, l\u2019op\u00e9rateur search.Operator.ANYOF (ou NONEOF) et ['@NONE@'] comme valeur.Par exemple, pour rechercher les enregistrements dans lesquels le champ \u00ab custrecord_fabrication_wo_linked \u00bb est vide :\n\n```\njavascript\/** * @NApiVersion 2.x * @NModuleScope SameAccount *\/define(['N\/search'], function(search) {    \/\/ ... your script logic ...    var emptyFieldFilter = search.createFilter({        name: 'custrecord_fabrication_wo_linked',        operator: search.Operator.ANYOF,        values: ['@NONE@']    });    \/\/ This filter can then be added to a search.create or search.load operation.    \/\/ Example:    \/\/ var mySearch = search.create({    \/\/     type: search.Type.TRANSACTION,    \/\/     filters: [emptyFieldFilter],    \/\/     columns: ['internalid']    \/\/ });    \/\/ ...});\n```\n\n. Ce filtre cible effectivement les enregistrements pour lesquels aucune valeur n\u2019est s\u00e9lectionn\u00e9e dans le champ de liste\/d\u2019enregistrement sp\u00e9cifi\u00e9.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:15:34-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Filter to use in a scripted search to find empty list\/record","ga_ans_id":"ANS-0916","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The function name 'nlobjSearchFilter' is a SuiteScript 1.0 construct and has been superseded by 'search.createFilter' in SuiteScript 2.0, which is the current recommended approach for scripted searches.","ga_final_category":"SuiteScript Development","footnotes":""},"ga_category":[108,23,108],"ga_audience":[10],"ga_difficulty":[92],"class_list":["post-2655","qa_entry","type-qa_entry","status-publish","hentry","ga_category-developpement-suitescript","ga_category-suitescript-development","ga_audience-developer-suitescript","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":108,"label":"D\u00e9veloppement SuiteScript"},{"value":23,"label":"SuiteScript Development"},{"value":108,"label":"D\u00e9veloppement SuiteScript"}],"ga_audience":[{"value":10,"label":"Developer\/SuiteScript"}],"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\/2655","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\/2655\/revisions"}],"predecessor-version":[{"id":4575,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2655\/revisions\/4575"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2655"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2655"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2655"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}