Execute Store Procedure for Query, Null Output

Hi, I have a rule in which I call an SP.
I made changes to a field so that it accepts an array and now my Rule is not working. 


I'm not getting an error, just nulls. Any idea?


with(

local!result: a!executeStoredProcedureForQuery(
dataSource: cons!SOP_ARC_CONS_ALMACEN_DATOS,
procedureName:"SOP_ARC_GETTOTAL_INFORMESLAS",
inputs:{
a!storedProcedureInput(
name: "STARTINDEX",
value: if(
isnull(
ri!startIndex
),
0,
ri!startIndex - 1
)
),
a!storedProcedureInput(
name: "BATCHSIZE",
value: if(
isnull(
ri!batchSize
),
100,
ri!batchSize
)
),
a!storedProcedureInput(
name: "SORTBY",
value: if(
isnull(
ri!sortBy
),
"idinstancia",
lower(ri!sortBy.field)
)
),
a!storedProcedureInput(
name: "ASCENDING",
value: if(
isnull(
ri!sortBy
),
true,
tointeger(ri!sortBy.ascending)
)
),
a!storedProcedureInput(
name: "RESULTADOSMAXIMOS",
value: cons!SOP_ARC_INFORMES_MAX_RESULTADO_PANTALLA_ONLINE[ri!codigoInforme]
),
a!storedProcedureInput(
name: "TIPOPROCESO",
value: "'"&joinarray(ri!procesoS,"','")&"'"
),
}

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data