Skip to main content

mes.fnGetOrderCount

Description

Returns total quantity completed for a given work order using mode event data.

Syntax

mes.fnGetOrderCount(@modeEventData, @workOrderId)

Parameters:
  • @modeEventData (tempModeEventData): Pre-filtered mode event data table
  • @workOrderId (int): Work order Id

    • Returns:
    Returns a table with columns:
  • woActualQty (float): Total quantity completed for the work order

    • Code Example​

    -- Assume #modeEventData is a temp table with event data
    -- Get the total quantity completed for a specific work order
    SELECT *
    FROM mes.fnGetOrderCount(#modeEventData, 55421);