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
It is almost impossible to support you without knowing any details about that stored procedure. If there is no error, the problem might be bad parameters, or the procedure itself.