T+销货单工作台，在查询条件中想要按“单值查询”如何处理？

iufida

【问题现象】
在销货单工作台想要有【条件类型】字段可以选择【单值】，就像销售订单执行表查询页面一样，【条件类型】字段可以选择【单值】。

                               
登录/注册后可看大图

【解决方案】
修改了销货单工作台的话，那么销货单列表的查询也会随着变成单值，以下脚本为处理销货单列表查询的客户和结算客户，如果结算客户不需要修改则不用执行；
同时下面还有恢复到区间的脚本，执行完成以后，重新刷新页面或者重启T+服务，如有问题及时反馈联系；（请注意备份账套再执行！）


--处理客户

update EAP_SearchItem_Ext set IsBetween = 0,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext  where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.Customer.Code'

update  EAP_SearchPlanItem_Ext  set ItemType = NULL where SearchItemId in (

select id from EAP_SearchItem_Ext where SearchId in (select id from EAP_SearchInfo_Ext  where Name = 'SA_SaleDeliveryList') and (FieldName = 'SaleDelivery.Customer.Code')

)

--处理结算客户

update EAP_SearchItem_Ext set IsBetween = 0,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext  where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.SettleCustomer.Code'

update  EAP_SearchPlanItem_Ext  set ItemType = NULL where SearchItemId in (

select id from EAP_SearchItem_Ext where SearchId in (select id from EAP_SearchInfo_Ext  where Name = 'SA_SaleDeliveryList') and (FieldName = 'SaleDelivery.Customer.Code')

)

--恢复区间的脚本

update EAP_SearchItem_Ext set IsBetween = 1,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext  where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.Customer.Code'

update EAP_SearchItem_Ext set IsBetween = 1,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext  where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.SettleCustomer.Code'