知识库

【问题现象】

工序汇报单选择派工单界面产品下拉报错

【解决方案】

备份数据，执行脚本。

UPDATE EAP_SearchItemCtrlInfo_Ext SET RefShowField=NULL WHERE id IN(

SELECT id FROM EAP_SearchItemCtrlInfo_Ext WHERE ItemId IN(

SELECT id FROM dbo.EAP_SearchItem_Ext WHERE SearchId IN(

SELECT id FROM EAP_SearchInfo_Ext WHERE name IN(

'MB_MP_ManufactureOrder_SelectForManufactureReport','MB_OM_OutSourceOrder_SelectForManufactureReport'

,'SW_ProcessDispatch_SelectForManufactureReport','SW_ProcessDispatch_SelectForMaterialDispatch'

,'MB_MP_ManufactureOrder_SelectForProcessTransfer','MB_SW_ProcessDispatchList'

))) AND RefShowField = 'Code+Name+Specification')