封装查询
<h3>引用模块:helper/search_helper.js</h3>
<h3>查询记录</h3>
<h4>调用方法</h4>
<pre><code class="language-javascript">searchHelper.queryRecord({type},{filters}, {columns});</code></pre>
<h4>示例代码</h4>
<pre><code class="language-javascript">var filters = [];
//简单条件直接添加
filters.addFilter('type', search.Operator.IS, 'SalesOrd');
//关联条件可添加查询对象
filters.addFilter({
name : 'taxline',
operator : search.Operator.IS,
values : [ 'F' ]
});
//查询列:简单列直接写名字,关联列可写对象
var columns = [ 'type', 'tranid', {
name : 'email',
join : 'customer'
}, 'trandate', 'item', 'quantity' ];
var results = searchHelper.queryRecord(search.Type.TRANSACTION,filters, columns);</code></pre>
<h4>结果示例</h4>
<pre><code class="language-json">[
{
"type":{
"value":"SalesOrd",
"text":"销售订单"
},
"tranid":"1",
"customer_email":"1111@qq.com",
"trandate":"2019-11-19",
"item":"",
"quantity":""
}
]</code></pre>
<h4>结果数据结构</h4>
<p>key:列名即为key,如果为关联查询,则key为{join}_{name}
value:普通字段,根据key即可获取,列表字段则区分了value跟text</p>
<h3>查询搜索</h3>
<h4>调用方法</h4>
<pre><code class="language-javascript">searchHelper.querySavedSearch({searchId},{filters});</code></pre>
<h4>示例代码</h4>
<pre><code class="language-javascript">var filters = [];
filters.addFilter('internalid', search.Operator.IS, '1');
var results = searchHelper.querySavedSearch('customsearch_emp_v', filters);</code></pre>
<h4>结果示例</h4>
<p>同记录查询一样</p>
<h4>结果数据结构</h4>
<p>同记录查询一样</p>