Refresh grid with data from recorType after record deletion

The automatic refresh works for record action fields only. You will have to refresh the data manually. I typically add a local called "refreshCounter", then fetch the data for the grid an a local variable which is then refreshed if that counter is incremented. Feed that locally stored data to the data attribute of the grid.

I tried to spool the query in the local!data variable at the beginning.

  local!datarefresh: 0,
  local!data: a!refreshVariable(
  value: a!recordData(
    recordType: 'recordType Request',
    filters: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: 'recordType Request.fields.{endDate}endDate',
          operator: "is null"
        ),
        a!queryFilter(
          field: 'recordType! Request.fields.{active}active',
          operator: "=",
          value: true
        )
      },
      ignoreFiltersWithEmptyValues: true
    )
  ),
 refreshOnVarChange: local!datarefresh
  ),

Then into the button, on succes i increase local!datarefresh variable to arrange an update

 a!startProcess(
                  processModel: cons!PM_deleteRequests,
                  processParameters: {
                    requestsToBeDeleted: local!selectedRequests
                  },
                  onSuccess: {
                    a!save(local!datarefresh, local!datarefresh + 1),
                    a!save(local!selectedRequests, null())
                  },
                  onError: a!save(local!error, true())
                )

The in the grid, i fetch local!data as data:

 a!gridField(
          data: local!data,
          columns: ...
          initialSorts:...
          secondarySorts:..
            selectable: true,
          selectionStyle: "CHECKBOX",
          selectionValue: local!selectedRequests,
          selectionSaveInto: local!selectedRequests,
          validations: {},
          spacing: "DENSE",
          height: "AUTO",
          borderStyle: "STANDARD",
          /*refreshAlways: true(),*/
          refreshOnVarChange: local!datarefresh,
          /*refreshAfter: "RECORD_ACTION",*/
    /*the 3 options above had been tested in any possible combination*/
          showSearchBox: false,
          showRefreshButton: false,
          recordActions: {}
        )
      },

No way, refresh does not happen.

What's wrong?

thanks a lot

I tried to spool the query in the local!data variable at the beginning.

  local!datarefresh: 0,
  local!data: a!refreshVariable(
  value: a!recordData(
    recordType: 'recordType Request',
    filters: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: 'recordType Request.fields.{endDate}endDate',
          operator: "is null"
        ),
        a!queryFilter(
          field: 'recordType! Request.fields.{active}active',
          operator: "=",
          value: true
        )
      },
      ignoreFiltersWithEmptyValues: true
    )
  ),
 refreshOnVarChange: local!datarefresh
  ),

Then into the button, on succes i increase local!datarefresh variable to arrange an update

 a!startProcess(
                  processModel: cons!PM_deleteRequests,
                  processParameters: {
                    requestsToBeDeleted: local!selectedRequests
                  },
                  onSuccess: {
                    a!save(local!datarefresh, local!datarefresh + 1),
                    a!save(local!selectedRequests, null())
                  },
                  onError: a!save(local!error, true())
                )

The in the grid, i fetch local!data as data:

 a!gridField(
          data: local!data,
          columns: ...
          initialSorts:...
          secondarySorts:..
            selectable: true,
          selectionStyle: "CHECKBOX",
          selectionValue: local!selectedRequests,
          selectionSaveInto: local!selectedRequests,
          validations: {},
          spacing: "DENSE",
          height: "AUTO",
          borderStyle: "STANDARD",
          /*refreshAlways: true(),*/
          refreshOnVarChange: local!datarefresh,
          /*refreshAfter: "RECORD_ACTION",*/
    /*the 3 options above had been tested in any possible combination*/
          showSearchBox: false,
          showRefreshButton: false,
          recordActions: {}
        )
      },

No way, refresh does not happen.

What's wrong?

thanks a lot

This setup looks correct from an initial skim-through.  The one thing you'll need to double-check (which you haven't provided either way here) is that your process has chaining enabled all the way through to the node that performs the "deletion" in the database.  The "onSuccess" save will execute *immediately* upon the first chaining break in the process, and if, for example, you have no chaining set up in the process, it would be happening way too early to be properly caught by your refresh variable setup seen here.

Hi Mike,

Thanks for your reply.

yes, steps in the PM workflow are chained as you can see in the attached pic:

Btw, I also tried by using QueryEntity instead of recordType. Same options, no refresh.

Gotcha, thanks for confirming.  Another thing you should watch is to make sure your refresh counter is actually incrementing when the form action is done.  And if so, one way you can brute-force test the behavior is to make a *manual* edit directly to the DB data, then force-increment the refresh counter by itself (like via a separate debug-only button/link), and see if you can get the local data to refresh.  The point here is to narrow down where the disconnect is happening.