Ga naar inhoud

Scansbycategory

Report ScansByCategory

  • Filename: ScansByCategory
  • Title: Scans by category
  • Sample: form141 (unit141)

Synopsis

Report per person the scans per kind of operation.

SQL

SELECT
  A.UserName,
  Count(*) AS NoOfRec,
  SUM(CASE WHEN Left(OpType, 4)='Move' THEN 1 ELSE 0 END) AS NoOfMoves,
  SUM(CASE WHEN OpType ='TRANSFER' THEN 1 ELSE 0 END) AS NoOfTransfers,
  SUM(CASE WHEN Left(OpType, 6)='RETURN' THEN 1 ELSE 0 END) AS NoOfReturns,
  SUM(CASE WHEN OpType ='RECEPTION' THEN 1 ELSE 0 END) AS NoOfReceptions,
  SUM(CASE WHEN OpType ='PICK' THEN 1 ELSE 0 END) AS NoOfPickings,
  SUM(CASE WHEN OpType ='CHECK' THEN 1 ELSE 0 END) AS NoOfCheckings,
  SUM(CASE WHEN Left(OpType, 3)='COR' THEN 1 ELSE 0 END) AS NoOfCorections
FROM
  SCANHISTORY A
WHERE
  (A.CREATIONDATE>=:StartDate)
  AND (A.CREATIONDATE<:EndDate)
GROUP BY
  A.UserName

Parameters

  • StartDate Start of period of scans.
  • EndDate end of period of scans.

Accessible in forms