How to use executeStoredProcedureForQuery in an interface

Can you confirm which version of Appian you're running?  This function was just released with 22.1 for reference.

21.4.

if this cannot be done with this version. Can it be done using the previous "executestoredprocedure"; I am trying to see how i can include it in a form.

Thanks

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.

Yes - assuming you have the plug-in installed, it works in almost exaclty the same way, though the parameter names are slightly different.  The syntax is like this:

executeStoredProcedure(
  dataSourceName: "jdbc/Appian",
  procedureName: "your procedure name here",
  inputs: {
    {
      name: "p_inputname1",
      value: ri!input1Value
    },
    ...
  }
)

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"
        )
      }
 
    )
  )

The problem here is you still have it as a member of your a!formLayout() call even though it's not a valid thing to put there.  Instead you should be setting the value to a local variable and then referencing that inside the contents.  As I mentioned before, the simplest way to do this is in the value of a paragraph field (just for preview/display purposes).

a!localVariables(

  local!procedureOutput:  executestoredprocedure(
      datasourceName: "jdbc/DXXX",
      procedureName: "dbo.procFileProcessingLog",
      inputs: {
        {
          name: "date_param",
          value: {}
        }
      }
    ),

  a!formLayout(
    label: "New Purchase Request",
    contents: {
      a!paragraphField(
        label: "EXAMPLE procedure output:",
        value: local!procedureOutput,
        readOnly: true()
      ),
             
          a!dateField(
            label: "payment Run Date",
            labelPosition: "ABOVE",
            value: rule!APN_replaceNull("05/01/2022",now()),
            saveInto: {}
          )
      
    },
    
    
    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"
        )
      }
    )
  )
)

Thanks Mike, But, I want to get the date from the form and pass it to the stored proc.

The easiest way to handle that is to move the stored procedure call into the saveInto of a button or link (which only becomes enabled once the user has filled in the date you want to pass in), and calls the procedure (saving its returned data into the same local variable perhaps) instead of calling it immediately upon form load (which i initially assumed you were after, since you didn't specify this constraint either way).

I'm out of time tonight to work up a code example for this but it's not very difficult overall - and maybe one of the "night shift" guys will give it a shot.

this is what I am trying to achieve (this is triggered by a process model):

a!localVariables(

  local!procedureOutput: executestoredprocedure(
    datasourceName: "jdbc/Dxxx",
    procedureName: "dbo.procFileProcessingLog",
    inputs: {
      {
        name: "date_param",
        value: pv!paymentDate
      }
    }
  ),
  {
    a!dateField(
      label: "Payment Run Date",
      value: rule!APN_replaceNull(pv!paymentDate,now()),
      saveInto: pv!paymentDate),
      a!buttonLayout(
        primaryButtons: {
          a!buttonWidget(
            label: "Submit",
            saveInto: local!procedureOutput,
            submit: true,
            style: "PRIMARY"
          )
        },
        secondaryButtons: {

        }
      )
  }

)

Still getting errors.

Thanks for your help.

Can you clarify what you mean by "triggered by a process model"?  Is this an interface being used in a User Input Task?  If not, then your DateField component won't really do anything as it's only valid within an interface.