【問(wèn)題現(xiàn)象】

工序匯報(bào)單選擇派工單界面產(chǎn)品下拉報(bào)錯(cuò)

【解決方案】

備份數(shù)據(jù)，執(zhí)行腳本。

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')