Skip to main content

mes.fnGetWOCount

Description

Returns the total count (sum of values) for a given work order.

Syntax

mes.fnGetWOCount(@workOrderId)

Parameters:
  • @workOrderId (int): Work order Id

  • Returns:
  • float: Total count for the work order
  • Code Example

    SELECT mes.fnGetCount(
    '2025-07-01T00:00:00',
    '2025-07-30T00:00:00',
    1012
    ) AS total_count;