Ga naar inhoud

Userperformanceraw

Report UserPerformanceRaw

  • Filename: UserPerformanceRaw
  • Title: Working Performance
  • Sample: Unit174

Synopsis

User work time.

SQL

SELECT
  OPTYPE, ARTCODE, QTY, ORDERNO,  SCANSTARTDATE, UserName,
  CreationDate,
  DateDiff(second, ScanStartDate, CreationDate) as WorkTime,
  originallocation,
  location
FROM
  SCANHISTORY
WHERE
  (CreationDate>=:StartDate) AND (CreationDate<:EndDate)
  and OPTYPE in ('PICK', 'MOVE', 'MOVE-FL')
ORDER BY
  USERNAME, OPTYPE, creationdate asc

Parameters

  • StartDate Start date of performance period.
  • EndDate End date of performance period.

Accessible in forms