Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have done Edit Script then loaded the following query
select s.SITE SITE, s.SFC SFC, s.QTY QTY, stat.STATUS SFC_STATUS,
stat.STATUS_DESCRIPTION SFC_STATUS_DESCRIPTION, i.ITEM ITEM, i.REVISION ITEM_REVISION,
ss.OPERATION_BO, ss.QTY_IN_QUEUE, ss.QTY_IN_WORK, so.SHOP_ORDER SHOP_ORDER,
sot.DESCRIPTION SHOP_ORDER_TYPE
from SFC s inner join ITEM i on
s.ITEM_BO = i.HANDLE inner join STATUS stat on s.STATUS_BO = stat.HANDLE
inner join SFC_ROUTING srg on s.HANDLE = srg.SFC_BO
inner join SFC_ROUTER sr on srg.HANDLE = sr.SFC_ROUTING_BO
inner join SFC_STEP ss on sr.HANDLE = ss.SFC_ROUTER_BO
inner join SHOP_ORDER so on s.SHOP_ORDER_BO = so.HANDLE
inner join SHOP_ORDER_TYPE sot on so.SHOP_ORDER_TYPE_BO = sot.HANDLE
where s.SITE = 'PPM' --and i.ITEM = 'ITEM_PANEL' and i.REVISION = 'A'
and sot.ORDER_TYPE = 'PRODUCTION' and stat.STATUS_DESCRIPTION = 'Scrapped'
order by SFC_BO
Then when click reload button it gives Script Execution Process not responding.
Can anyone suggest how to recover from this?
Regards
Glory
Hi Glory,
was that select command performed on sql or resident tables?
regards
It was performed in SQL query
use below code
select s.SITE as SITE, s.SFC as SFC, s.QTY as QTY, stat.STATUS as SFC_STATUS,
stat.STATUS_DESCRIPTION as SFC_STATUS_DESCRIPTION, i.ITEM as ITEM, i.REVISION as ITEM_REVISION,
ss.OPERATION_BO, ss.QTY_IN_QUEUE, ss.QTY_IN_WORK, so.SHOP_ORDER as SHOP_ORDER,
sot.DESCRIPTION as SHOP_ORDER_TYPE
from SFC s inner join ITEM i on
s.ITEM_BO = i.HANDLE inner join STATUS stat on s.STATUS_BO = stat.HANDLE
inner join SFC_ROUTING srg on s.HANDLE = srg.SFC_BO
inner join SFC_ROUTER sr on srg.HANDLE = sr.SFC_ROUTING_BO
inner join SFC_STEP ss on sr.HANDLE = ss.SFC_ROUTER_BO
inner join SHOP_ORDER so on s.SHOP_ORDER_BO = so.HANDLE
inner join SHOP_ORDER_TYPE sot on so.SHOP_ORDER_TYPE_BO = sot.HANDLE
where s.SITE = 'PPM' --and i.ITEM = 'ITEM_PANEL' and i.REVISION = 'A'
and sot.ORDER_TYPE = 'PRODUCTION' and stat.STATUS_DESCRIPTION = 'Scrapped'
order by SFC_BO
hope this helps
Try to measure how much time select execution takes when run from db tool and how many rows has final result.
One option would be to create corresponding resident tables in QV and inner joins perform on them.
regards