🚀 go-pugleaf

Hello,

I need to pass to a stored procedure a list of values similar to a list used 
in SQL using the ' IN' statement. I have written a procedure that works with 
=  but I do not know how to make it work with the IN stateement. I want to 
replace GROUP_ =  with GROUP_ IN. The input field is MSCALL.

Grateful for your assistance.

The stored procedure is as follows.

SET TERM ^ ;

/* Stored procedures */

CREATE PROCEDURE "DOSYSTRAFFIC"
(
  "MSCALL" CHAR(40),
  "DATE1" DATE,
  "DATE2" DATE,
  "TIME1" TIME,
  "TIME2" TIME
)
RETURNS
(
  "START_DATETIME" TIMESTAMP,
  "SYSTEM_TRAFFIC" DOUBLE PRECISION
)
AS
BEGIN EXIT; END ^


ALTER PROCEDURE "DOSYSTRAFFIC"
(
  "MSCALL" CHAR(40),
  "DATE1" DATE,
  "DATE2" DATE,
  "TIME1" TIME,
  "TIME2" TIME
)
RETURNS
(
  "START_DATETIME" TIMESTAMP,
  "SYSTEM_TRAFFIC" DOUBLE PRECISION
)
AS
 begin
 For
 Select START_DATETIME, SUM(TRAFFIC) from SysGrpPerf where
 START_DATE BETWEEN :"DATE1" and :"DATE2" AND GROUP_ = :"MSCALL" AND
 START_TIME BETWEEN :"TIME1" AND :"TIME2"
 GROUP BY START_DATETIME
 INTO :"START_DATETIME",:"SYSTEM_TRAFFIC"
 Do
  suspend;
end
 ^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;