Skip to main content
S
sandeepkumarn185922
January 22, 2026
Question

First grid is not refreshing when deleting the selected records

  • January 22, 2026
  • 13 replies
  • 0 views

Hi Team,
I have two read-only grids, first grid display data from table A and querying from record type. Second grid from table B and querying from query entity.
When i am Deleting selected records from first grid, the grid is not refreshing even though i am using refresh variables.
When i am Adding selected records from second grid then both the first and second grids are refreshing properly. 

Inserted code for reference, please guide me if i am missing anything:

a!localVariables(
  local!refreshFlag,
  local!refreshFlagForDelete,
  local!isSuccess: false(),
  local!refreshCounter: 0,
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: cons!TRICS_BATCH_SIZE[6]
  ),
  local!selectionOfRulesIdsForDelete,
  local!selectionOfRulesForDelete,
  local!selectionOfRulesIdsForAdd,
  local!selectionOfRulesForAdd,
  local!interpretationChangeMappingRuleIds,
  local!interpretationChangeMappings: a!refreshVariable(
    value: if(
      a!isNotNullOrEmpty(
        index(
          ri!taskDetails,
          'recordType!{6e2ddb78-06f3-47fa-b21c-4c925bbe8a14}TRICS Transaction Task.fields.{4a370a45-2ddc-4966-a66e-90a65c727aa6}workflowTypeId',
          null
        )
      ),
      rule!TRICS_genericQueryRecordType(
        inputRecord: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings',
        logicalExpression: {
          a!queryFilter(
            field: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{07376c63-ac77-4c4d-87b7-0e22da07754d}wfId',
            operator: "=",
            value: index(
              ri!taskDetails,
              'recordType!{6e2ddb78-06f3-47fa-b21c-4c925bbe8a14}TRICS Transaction Task.fields.{4a370a45-2ddc-4966-a66e-90a65c727aa6}workflowTypeId',
              null
            )
          )
        },
        pagingInfo: a!pagingInfo(
          startIndex: 1,
          batchSize: cons!TRICS_BATCH_SIZE[5]
        )
      ),
      {}
    ),
    refreshOnVarChange: local!refreshFlag
  ),
  local!interpretationChangeMappingsGridData: a!refreshVariable(
    value: if(
      and(
        a!isNotNullOrEmpty(
          index(
            ri!taskDetails,
            'recordType!{6e2ddb78-06f3-47fa-b21c-4c925bbe8a14}TRICS Transaction Task.fields.{4a370a45-2ddc-4966-a66e-90a65c727aa6}workflowTypeId',
            null
          )
        ),
        or(
          a!isNotNullOrEmpty(
            index(
              local!interpretationChangeMappings,
              'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
              {}
            )
          ),
          a!isNotNullOrEmpty(
            tointeger(
              local!interpretationChangeMappingRuleIds
            )
          )
        )
      ),
      rule!TRICS_genericQueryRecordType(
        inputRecord: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings',
        logicalExpression: {
          a!queryFilter(
            field: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{07376c63-ac77-4c4d-87b7-0e22da07754d}wfId',
            operator: "=",
            value: index(
              ri!taskDetails,
              'recordType!{6e2ddb78-06f3-47fa-b21c-4c925bbe8a14}TRICS Transaction Task.fields.{4a370a45-2ddc-4966-a66e-90a65c727aa6}workflowTypeId',
              null
            )
          ),
          a!queryFilter(
            field: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
            operator: "in",
            value: if(
              a!isNullOrEmpty(
                local!interpretationChangeMappingRuleIds
              ),
              index(
                local!interpretationChangeMappings,
                'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
                {}
              ),
              tointeger(
                local!interpretationChangeMappingRuleIds
              )
            )
          )
        },
        pagingInfo: a!pagingInfo(
          startIndex: 1,
          batchSize: cons!TRICS_BATCH_SIZE[5]
        )
      ),
      {}
    ),
    refreshOnVarChange: local!refreshCounter,

  ),
  local!allRules: a!refreshVariable(
    value: rule!TRICS_genericQueryEntity(
      inputEntity: cons!TRICS_DSE_RULES,
      fields: {
        "ruleId",
        "name",
        "regulator",
        "source",
        "type",
        "description"
      },
      filter: {
        if(
          or(
            a!isNotNullOrEmpty(
              index(
                local!interpretationChangeMappings,
                'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
                {}
              )
            ),
            a!isNotNullOrEmpty(
              local!interpretationChangeMappingRuleIds
            )
          ),
          a!queryFilter(
            field: "ruleId",
            operator: "not in",
            value: if(
              a!isNullOrEmpty(
                local!interpretationChangeMappingRuleIds
              ),
              index(
                local!interpretationChangeMappings,
                'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
                {}
              ),
              tointeger(
                local!interpretationChangeMappingRuleIds
              )
            )
          ),
          {}
        ),
        a!queryFilter(
          field: "isActive",
          operator: "=",
          value: true()
        )
      },
      fetchTotalCount: true(),
      pagingInfo: local!pagingInfo,
      isDataSubset: true()
    ),
    refreshOnVarChange: local!refreshFlag
  ),
  /*local!test,*/
  {
    a!cardLayout(
      contents: {
        a!sideBySideLayout(
          items: {
            a!sideBySideItem(
              item: a!richTextDisplayField(
                value: a!richTextItem(
                  text: "Rule Interpretation Mapping",
                  style: "STRONG"
                ),
                align: "LEFT"
              )
            ),
            a!sideBySideItem(width: "2X"),
            a!sideBySideItem(
              item: a!buttonArrayLayout(
                buttons: {
                  a!buttonWidget(
                    label: "Delete Rule Mapping",
                    icon: "times",
                    saveInto: a!startProcess(
                      processModel: cons!TRICS_PM_MARK_INACTIVE_FOR_RULE_INTERPRETATION_MAPPINGS,
                      processParameters: {
                        selectionOfRulesForDelete: local!selectionOfRulesForDelete,
                        taskDetails: ri!taskDetails,
                        isSuccess: local!isSuccess
                      },
                      isSynchronous: true,
                      onSuccess: {
                        a!save(
                          local!interpretationChangeMappingRuleIds,
                          fv!processInfo.pv.interpretationChangeMappingRuleIds
                        ),
                        a!save(
                          local!refreshCounter,
                          local!refreshCounter + 1
                        ),
                        a!save(
                          local!isSuccess,
                          fv!processInfo.pv.isSuccess
                        ),
                        a!save(local!refreshFlag, rand()),
                        a!save(local!refreshFlagForDelete, rand()),
                        /*a!save(*/
                        /*local!test,*/
                        /*fv!processInfo.pv.selectionOfRulesForDeleteUpdated*/
                        /*),*/
                        a!save(
                          {
                            local!selectionOfRulesIdsForDelete,
                            local!selectionOfRulesForDelete
                          },
                          null()
                        )/*a!save(*/
                        /*local!interpretationChangeMappingsGridData,*/
                        /*a!localVariables(*/
                        /*local!gridRuleIds: index(*/
                        /*local!interpretationChangeMappingsGridData,*/
                        /*'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',*/
                        /*{}*/
                        /*),*/
                        /*local!testRuleIds: index(*/
                        /*local!test,*/
                        /*'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',*/
                        /*{}*/
                        /*),*/
                        /*local!indicesToUpdate: wherecontains(local!testRuleIds, local!gridRuleIds),*/
                        /*local!newValues: a!forEach(*/
                        /*items: local!indicesToUpdate,*/
                        /*expression: index(*/
                        /*local!test,*/
                        /*where(*/
                        /*local!testRuleIds = local!gridRuleIds[fv!item]*/
                        /*),*/
                        /*1,*/
                        /*{}*/
                        /*)*/
                        /*),*/
                        /*a!update(*/
                        /*local!interpretationChangeMappingsGridData,*/
                        /*local!indicesToUpdate,*/
                        /*local!newValues*/
                        /*)*/
                        /*)*/
                        /*),*/

                      },
                      onError: {}
                    ),
                    width: "FILL",
                    style: "SOLID",
                    color: if(
                      a!isNullOrEmpty(local!selectionOfRulesIdsForDelete),
                      cons!TRICS_HSBC_TEXT_LIST_HEX_COLOR_PALLETE[4],
                      cons!TRICS_HSBC_TEXT_LIST_HEX_COLOR_PALLETE[1]
                    ),
                    disabled: a!isNullOrEmpty(local!selectionOfRulesIdsForDelete),
                    loadingIndicator: true()
                  )
                },
                align: "END",
                marginBelow: "NONE"
              )
            )
          }
        ),
        a!gridField(
          label: "",
          data: local!interpretationChangeMappingsGridData,
          columns: {
            a!gridColumn(
              label: "Rule Name",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{4c44dab4-9bc4-4e7e-8e3c-3aa61fb58f1f}ruleName',
              value: index(
                rule!TRICS_genericQueryRecordType(
                  inputRecord: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule',
                  recordFields: {
                    'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{3236c18b-9e25-439c-964c-4821abed0f02}ruleId',
                    'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{4c44dab4-9bc4-4e7e-8e3c-3aa61fb58f1f}ruleName'
                  },
                  logicalExpression: a!queryLogicalExpression(
                    operator: "AND",
                    filters: {
                      a!queryFilter(
                        field: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{3236c18b-9e25-439c-964c-4821abed0f02}ruleId',
                        operator: "=",
                        value: fv!row['recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId']
                      )
                    }
                  )
                ),
                'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{4c44dab4-9bc4-4e7e-8e3c-3aa61fb58f1f}ruleName',
                ""
              ),
              align: "CENTER"
            ),
            a!gridColumn(
              label: "Rule Description",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{30a67c25-6d3e-4219-817e-6d799fb0e57c}ruleDesc',
              value: rule!TRICS_ExpandAndCollapseContent(
                inputText: index(
                  rule!TRICS_genericQueryRecordType(
                    inputRecord: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule',
                    recordFields: {
                      'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{3236c18b-9e25-439c-964c-4821abed0f02}ruleId',
                      'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{30a67c25-6d3e-4219-817e-6d799fb0e57c}ruleDesc'
                    },
                    logicalExpression: a!queryLogicalExpression(
                      operator: "AND",
                      filters: {
                        a!queryFilter(
                          field: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{3236c18b-9e25-439c-964c-4821abed0f02}ruleId',
                          operator: "=",
                          value: fv!row['recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId']
                        )
                      }
                    )
                  ),
                  'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{30a67c25-6d3e-4219-817e-6d799fb0e57c}ruleDesc',
                  ""
                )
              ),
              width: "WIDE",
              align: "START"
            ),
            a!gridColumn(
              label: "Change Type",
              sortField: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{04497cb9-4323-4c12-89aa-d58bf439c133}changeType',
              value: fv!row['recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{04497cb9-4323-4c12-89aa-d58bf439c133}changeType'],
              align: "CENTER"
            )
          },
          pageSize: 5,
          /*showExportButton: true()*/
          selectable: true(),
          selectionValue: local!selectionOfRulesIdsForDelete,
          selectionSaveInto: {
            local!selectionOfRulesIdsForDelete,
            a!save(
              local!selectionOfRulesForDelete,
              append(
                local!selectionOfRulesForDelete,
                fv!selectedRows
              )
            ),
            a!save(
              local!selectionOfRulesForDelete,
              symmetricdifference(
                local!selectionOfRulesForDelete,
                fv!deselectedRows
              )
            )
          },
          disableRowSelectionWhen: or(
            fv!row['recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{04497cb9-4323-4c12-89aa-d58bf439c133}changeType'] = "Delete",
            tointeger(
              index(
                ri!taskDetails,
                'recordType!{6e2ddb78-06f3-47fa-b21c-4c925bbe8a14}TRICS Transaction Task.fields.{38ac65a5-9d16-44f1-9278-1575d537aebf}taskStatus',
                null
              )
            ) = tointeger(cons!TRICS_STATUS_ID[2])
          ),
          validations: {},
          borderStyle: "STANDARD",
          shadeAlternateRows: true(),
          /*loadDataAsync: true*/

        )
      }
    ),
    a!richTextDisplayField(),
    a!cardLayout(
      contents: {
        a!sideBySideLayout(
          items: {
            a!sideBySideItem(
              item: a!richTextDisplayField(
                value: a!richTextItem(
                  text: "Add New Rule Interpretation Mapping",
                  style: "STRONG"
                ),
                align: "LEFT"
              )
            ),
            a!sideBySideItem(width: "2X"),
            a!sideBySideItem(
              item: a!buttonArrayLayout(
                buttons: {
                  a!buttonWidget(
                    label: "Add Rule Mapping",
                    icon: "plus",
                    saveInto: {
                      a!startProcess(
                        processModel: cons!TRICS_PM_ADD_SELECTED_RULES_TO_RULE_INTERPRETATION_MAPPING,
                        processParameters: {
                          selectionOfRulesIdsForAdd: local!selectionOfRulesIdsForAdd,
                          taskDetails: ri!taskDetails
                        },
                        isSynchronous: true,
                        onSuccess: {
                          a!save(local!refreshFlag, rand()),
                          a!save(
                            local!interpretationChangeMappingRuleIds,
                            fv!processInfo.pv.interpretationChangeMappingRuleIds
                          ),
                          a!save(
                            {
                              local!selectionOfRulesIdsForAdd,
                              local!selectionOfRulesForAdd
                            },
                            null()
                          )
                        },
                        onError: {}
                      )
                    },
                    width: "FILL",
                    style: "SOLID",
                    color: if(
                      a!isNullOrEmpty(local!selectionOfRulesIdsForAdd),
                      cons!TRICS_HSBC_TEXT_LIST_HEX_COLOR_PALLETE[4],
                      cons!TRICS_HSBC_TEXT_LIST_HEX_COLOR_PALLETE[8]
                    ),
                    disabled: a!isNullOrEmpty(local!selectionOfRulesIdsForAdd),
                    loadingIndicator: true()
                  )
                },
                align: "END",
                marginBelow: "NONE"
              )
            )
          }
        ),
        a!gridField_25r2(
          label: "",
          labelPosition: "ABOVE",
          data: local!allRules,
          columns: {
            a!gridColumn(
              label: "Rule Name",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{4c44dab4-9bc4-4e7e-8e3c-3aa61fb58f1f}ruleName',
              value: fv!row.name,
              align: "START",
              width: "MEDIUM"
            ),
            a!gridColumn(
              label: "Rule Description",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{30a67c25-6d3e-4219-817e-6d799fb0e57c}ruleDesc',
              value: rule!TRICS_ExpandAndCollapseContent(inputText: fv!row.description),
              width: "WIDE",
              align: "START"
            )
          },
          pagingSaveInto: local!pagingInfo,
          /*showExportButton: true()*/
          selectable: true(),
          selectionValue: local!selectionOfRulesIdsForAdd,
          selectionSaveInto: {
            local!selectionOfRulesIdsForAdd,
            a!save(
              local!selectionOfRulesForAdd,
              append(
                local!selectionOfRulesForAdd,
                fv!selectedRows
              )
            ),
            a!save(
              local!selectionOfRulesForAdd,
              symmetricdifference(
                local!selectionOfRulesForAdd,
                fv!deselectedRows
              )
            )
          },
          disableRowSelectionWhen: tointeger(
            index(
              ri!taskDetails,
              'recordType!{6e2ddb78-06f3-47fa-b21c-4c925bbe8a14}TRICS Transaction Task.fields.{38ac65a5-9d16-44f1-9278-1575d537aebf}taskStatus',
              null
            )
          ) = tointeger(cons!TRICS_STATUS_ID[2]),
          validations: {},
          borderStyle: "STANDARD",
          shadeAlternateRows: true()
        )
      }
    )
  }
)
 


Regards,
Sandeep

    13 replies

    shubhama926776
    shubhama926776
    January 22, 2026

    The grid isn't refreshing because local!interpretationChangeMappingsGridData has refreshOnVarChange: local!refreshCounter, but the query inside still uses the old filter logic.

    Change line 108 ->
    from :
    refreshOnVarChange: local!refreshCounter
    To :
    refreshOnVarChange: {local!refreshCounter, local!interpretationChangeMappingRuleIds}

    S
    sandeepkumarn185922Author
    January 22, 2026

     

    Changed to refreshOnVarChange: {local!refreshCounter, local!interpretationChangeMappingRuleIds} and tested, but still the first grid is not refreshing after deleting selected rule.

    shubhama926776
    shubhama926776
    January 22, 2026

    Check if fv!processInfo.pv.interpretationChangeMappingRuleIds actually returns different values.

    Add this temporarily in onSuccess to debug:
    a!save(local!refreshCounter, local!refreshCounter + 1),
    a!save(local!refreshFlag, rand())

    If local!refreshFlag works but local!refreshCounter doesn't, the problem is in your process model.

    harshas2775
    harshas2775
    January 22, 2026

    You are using local!refreshCounter in the grid A query as refreshvariable while grid B has refreshFlag. As a quick fix try changing refreshonCarChange for grid A to local!refreshFlag. 

    Also, on deletion and addition, both time refreshFlag is being updated not the refreshCounter. So consistency wise as well changing from refreshCounter to refreshFlag should work. 

    S
    sandeepkumarn185922Author
    January 22, 2026

    Yes Harsha,
    Tested by using  refreshOnVarChange: local!refreshFlag for both grids, but still it is not refreshing.

    harshas2775
    harshas2775
    January 22, 2026

    Try adding 'interpretationChangeMappings' as well in the Grid A refreshonVarChange list because the grid query depends on this data as well. e.g.

    refreshOnVarChange: {local!refreshFlag, local!interpretationChangeMappings} 

    Terms & ConditionsAccessibility statement