# mes.fnGetModeEventData

## Description
Returns production mode event data for a given asset within a time range.

## Syntax
  <b>mes.fnGetModeEventData(@assetId, @startDate, @endDate)</b>  
  <br /><br />
  <b>Parameters:</b><br />
  <li>@assetId (int): Asset Id (nullable)</li>
  <li>@startDate (datetime): Start of the time range (nullable)</li>
  <li>@endDate (datetime): End of the time range (nullable)</li>
  <br />
  <b>Returns:</b><br />
  Returns a table with columns:<br />
    <li>modeEventId (int): Mode event Id</li>
    <li>modeCode (nvarchar(50)): Mode code</li>
    <li>assetId (int): Asset Id</li>
    <li>workOrderId (int): Work order Id</li>
    <li>itemId (int): Item Id</li>
    <li>counterId (int): Counter Id</li>
    <li>startDate (datetime): Start timestamp</li>
    <li>endDate (datetime): End timestamp</li>

### Code Example
```sql
-- Get mode events for a specific asset and time range
SELECT *
FROM mes.fnGetModeEventData(2076, '2025-07-01T00:00:00', '2025-07-30T23:59:59');