How to get multiple result set using executeStoredProcedureForQuery

Multiple result sets: Different queries, not batches of same data
Exceed 10K limit: No, maxTotalRows=10000 is usually a hard platform limit. You cannot increase it beyond Appian's maximum.
Solution for >10K rows: Implement pagination in your stored procedure (pass page number/offset) and call the function multiple times.

Multiple result sets: Different queries, not batches of same data
Exceed 10K limit: No, maxTotalRows=10000 is usually a hard platform limit. You cannot increase it beyond Appian's maximum.
Solution for >10K rows: Implement pagination in your stored procedure (pass page number/offset) and call the function multiple times.

Hi Shubham Aware Shubham. I'm calling this plugin in a local variable. Now, I need to replace it with the function as it is deprecated. I need this function to behave the same as plugin. i need more data than 1000 Need help with that. I am putting code here so that it will be understandable easily.

a!localVariables(
  local!selectedSite: {},
  local!selectedType: {},
  local!selected: false,
  local!finalData: index(
    executestoredprocedure(
      dataSourceName: "jdbc/SPTAM",
      procedureName: "sptam_sp_site_wise_batch",
      inputs: {
        {
          name: "nto",
          type: "VARCHAR",
          value: if(
            or(ri!esoType = "All", ri!esoType = "NTO"),
            "FALSE",
            ""
          )
        },
        {
          name: "eso",
          type: "VARCHAR",
          value: if(
            or(ri!esoType = "All", ri!esoType = "ESO"),
            "TRUE",
            ""
          )
        },
        {
          name: "notFound",
          type: "VARCHAR",
          value: if(
            or(
              ri!esoType = "All",
              ri!esoType = "NOT FOUND"
            ),
            "NOT FOUND",
            ""
          )
        },
        {
          name: "pharma",
          type: "VARCHAR",
          value: if(
            contains(
              ri!companyId,
              cons!SPTAM_DIVISION_ID_LIST[1]
            ),
            cons!SPTAM_DIVISION_ID_LIST[1],
            ""
          )
        },
        {
          name: "sandoz",
          type: "DATE",
          value: if(
            contains(
              ri!companyId,
              cons!SPTAM_DIVISION_ID_LIST[2]
            ),
            cons!SPTAM_DIVISION_ID_LIST[2],
            ""
          )
        },
        {
          name: "toDate",
          type: "DATE",
          value: ri!toDate
        },
        {
          name: "fromDate",
          type: "DATE",
          value: ri!fromDate
        }
      }
    ),
    "result",
    null
  )