NetSuite和/或过滤器 [英] NetSuite And/Or Filter

问题描述

我正在尝试在NetSuite中创建报告.我想过滤掉有关一个参数的某些数据，然后我想使用另一个参数过滤掉数据. NetSuite中是否有AND/OR过滤器?

I am trying to create a report in NetSuite. I want to filter out certain data in regards to one parameter, then I want to filter in data by using another parameter. Is there an AND/OR filter in NetSuite?

推荐答案

如果使用Netsuite报告/搜索界面进行操作，请单击使用高级搜索，然后选中使用表达式.您会在条件"标签中看到与/或"列.

If you are doing it using Netsuite Report/search interface, click on Use Advanced Search and then check Use Expressions. You would see the And/Or column in the Criteria Tab.

如果您使用诉讼脚本执行此操作，请使用搜索过滤器表达式

If you are doing it using Suit Script use Search Filter Expressions

//Define search filter expression
var filterExpression = [ 
   [ 'trandate', 'onOrAfter', 'daysAgo90' ],
   'or',
   [ 'projectedamount', 'between', 1000, 100000 ],
   'or',
   'not', [ 'customer.salesrep', 'anyOf ', -5] 
];

这篇关于NetSuite和/或过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！