{"id":4439,"date":"2017-08-21T15:11:18","date_gmt":"2017-08-21T15:11:18","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-use-internal-id-for-math-filters-and-columns-in-netsuite-saved-searches-2\/"},"modified":"2026-07-28T18:26:46","modified_gmt":"2026-07-28T18:26:46","slug":"comment-utiliser-lidentifiant-interne-pour-les-filtres-mathematiques-et-les-colonnes-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-utiliser-lidentifiant-interne-pour-les-filtres-mathematiques-et-les-colonnes-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Comment utiliser l’identifiant interne pour les filtres math\u00e9matiques et les colonnes dans les recherches enregistr\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":"Comprenez la diff\u00e9rence entre les noms de champs requis pour appliquer des filtres math\u00e9matiques et ceux n\u00e9cessaires pour sp\u00e9cifier des colonnes correspondant aux identifiants internes des enregistrements NetSuite dans les scripts.","ga_short_answer":"Lorsque vous cr\u00e9ez des scripts pour les recherches enregistr\u00e9es de NetSuite, utilisez \u00ab internalidnumber \u00bb pour appliquer des filtres math\u00e9matiques tels que \u00ab lessthan \u00bb ou \u00ab greaterthan \u00bb \u00e0 un identifiant interne. Toutefois, lorsque vous d\u00e9finissez une colonne pour afficher ou agr\u00e9ger l\u2019identifiant interne, le nom de champ correct \u00e0 utiliser est \u00ab internalid \u00bb. Cette distinction garantit le bon fonctionnement de la recherche et la r\u00e9cup\u00e9ration correcte des donn\u00e9es.","ga_scenario":"Les utilisateurs qui d\u00e9veloppent des scripts NetSuite ont souvent besoin de filtrer des recherches enregistr\u00e9es en fonction de l\u2019identifiant interne des enregistrements \u00e0 l\u2019aide d\u2019op\u00e9rateurs math\u00e9matiques (par exemple, inf\u00e9rieur \u00e0, sup\u00e9rieur \u00e0). Un probl\u00e8me courant survient lorsqu\u2019on tente d\u2019utiliser le m\u00eame nom de champ \u00e0 la fois pour le filtrage et la sp\u00e9cification des colonnes, ce qui entra\u00eene des r\u00e9sultats inattendus ou des erreurs.","ga_solution":"Pour appliquer correctement des filtres math\u00e9matiques \u00e0 un identifiant interne dans un script de recherche enregistr\u00e9e NetSuite, utilisez le nom de champ \u00ab internalidnumber \u00bb. \u00c0 l\u2019inverse, lorsque vous sp\u00e9cifiez l\u2019identifiant interne en tant que colonne dans les r\u00e9sultats de recherche, vous devez utiliser le nom de champ \u00ab internalid \u00bb. Cela garantit que les filtres sont appliqu\u00e9s num\u00e9riquement et que les colonnes sont correctement r\u00e9cup\u00e9r\u00e9es. Exemple d\u2019utilisation de \u00ab internalidnumber \u00bb pour les filtres et de \u00ab internalid \u00bb pour les colonnes :\n\n```\nsearchFiltersPreviousCase[0] new nlobjSearchFilter('internalidnumber', null, 'lessthan', caseIdRejected);searchFiltersPreviousCase[1] new nlobjSearchFilter('status', null, 'is', CASE_STATUS_CLOSED, null);searchFiltersPreviousCase[2] new nlobjSearchFilter('email', null, 'isnotempty', null);searchFiltersPreviousCase[3] new nlobjSearchFilter('closeddate', null, 'onorafter', START_COUNTER_ON_DATE);searchColumnsPreviousCase[0] new nlobjSearchColumn('internalid', null, 'max');\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:11:18+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"SOL0204 InternalID (Number)","ga_ans_id":"ANS-0780","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"SuiteScript Development","footnotes":""},"ga_category":[108,23,108],"ga_audience":[10],"ga_difficulty":[92],"class_list":["post-4439","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\/4439","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\/4439\/revisions"}],"predecessor-version":[{"id":6360,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4439\/revisions\/6360"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4439"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4439"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4439"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}