How to use executeStoredProcedureForQuery in an interface

Additionally, you have it in the "contents" parameter of your a!formLayout - which isn't really valid since contents expects one or many interface components (including sections, column layouts, fields, etc), but even if your stored procedure call worked, it would be spitting out plain data which is not a valid form content.  If you're curious, you could always set it as the "value" parameter of a ParagraphField and see what happens then.  the more common way to handle this, though, would be to set it to the value of a local variable, then display that in the value parameter of text / paragraph / grid / rich text field(s), as appropriate.

I have removed it from the content., Please, see code. Still have issues

  a!formLayout(
    label: "New Purchase Request",
    contents: {
             
          a!dateField(
            label: "payment Run Date",
            labelPosition: "ABOVE",
            value: rule!APN_replaceNull("05/01/2022",now()),
            saveInto: {}
          )
      
    },
    
    executestoredprocedure(
      datasourceName: "jdbc/DXXX",
      procedureName: "dbo.procFileProcessingLog",
      inputs: {
        {
          name: "date_param",
          value: {}
        }
      }
    )
    
    buttons: a!buttonLayout(
      primaryButtons: {
        a!buttonWidget(
          label: "Submit",
          saveInto: {},
          submit: true,
          style: "PRIMARY",
          /* Prevent form submission while a new address is being configured */
          
          validationGroup: "main"
        )
      }
 
    )
  )

In this example the stored procedure is run when the Submit button is pressed, as part of its SaveInto list - and the button becomes active only upon entry of a date.  The stored procedure output is saved into a Rule Input variable such that it can be passed out to your process instance.

If this doesn't sound like what you're after then you might need to provide some additional clarification as to what exactly you're trying to do with the result of your Stored Procedure call - since up until now I was under the assumption that you were trying to get the result of a stored procedure query to be used in some way in your process.

The stored proc simply clears a log on the DB based on the date; I am not expecting to get any result from the stored proc, other than success or failure.

Also, the date is saved in a process variable and it's used by other process nodes in the process model.

Thanks

The original rule you'd asked about was ExecuteStoredProcedureForQuery hence the confusion - this rule is designed to execute a stored procedure for data querying purposes and is restricted against executing any stored procedures that cause data changes, AFAIK.

You probably want to use the old Execute Stored Procedure process node (the one included in the plug-in since your appian version doesn't yet support the new smart service).  You would still require the user to enter the date in an interface and save it into a PV, and then you would use that date in the procedure inputs in the in-process node.

For this node, the configuration is just done (as far as I remember) by just adding node inputs named exactly after the procedure input (with the same data type) and passing your process value.

Okay; I think am changing my process now. I will be creating a script task and that will allow users execute the procedure from the actions Tab. Do you have something in that line.

For that sort of thing, you should be able to call the procedure during the process - I'd recommend using the dedicated Stored Procedure node, though, as opposed to a script task.

Do you mean using the execute stored proc smart service?

yes.

how do I pass the date parameter to the executed stored proc.

I included that in my screenshot several replies ago.

Hi,

You can find execute stored procedure plugin here.

Also, see some instructional document how you can configure stored procedure here 

Hi,

You can find execute stored procedure plugin here.

Also, see some instructional document how you can configure stored procedure here