Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Suggested Answer
  • Replies 13 replies
  • Answers 5 answers
  • Subscribers 9 subscribers
  • Views 1852 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

First grid is not refreshing when deleting the selected records

sandeepkumarn185922_Coforge
Certified Senior Developer

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

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0
    Certified Senior Developer
     in reply to Harsha Sharma

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

  • 0
    Certified Lead Developer
     in reply to sandeepkumarn185922_Coforge

    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} 

  • 0
    Certified Senior Developer
     in reply to Harsha Sharma

    Tested by adding local!interpretationChangeMappings in refreshOnVarChange list but still it is not refreshing:


  • 0
    Certified Senior Developer
     in reply to sandeepkumarn185922_Coforge

    For local variables {local!interpretationChangeMappings, local!interpretationChangeMappingsGridData}, i was using generic query record type which is using old version a!queryRecordType_24r4().
    Me and my team member when we changed to a!queryRecordType() and tested then grid is refreshing fine when deleting selected rules.

    Inserted code for reference.

    a!localVariables(
  local!refreshFlag,
  local!isSuccess: false(),
  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
        )
      ),
      a!queryRecordType(
        recordType: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings',
        fields: {
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{4ad36d8c-515c-43be-957f-c1b652e5b5b8}mappingId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{07376c63-ac77-4c4d-87b7-0e22da07754d}wfId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{c10ce2d5-d26a-46ae-9b08-3a21a5318f0f}interpretationId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{04497cb9-4323-4c12-89aa-d58bf439c133}changeType',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{a3572ccd-cabf-45bb-be97-1c03f46d3760}interpretationType'
        },
        filters: {
          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]
        )
      ).data,
      {}
    ),
    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
            )
          )
        )
      ),
      a!queryRecordType(
        recordType: 'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings',
        fields: {
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{4ad36d8c-515c-43be-957f-c1b652e5b5b8}mappingId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{07376c63-ac77-4c4d-87b7-0e22da07754d}wfId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{c10ce2d5-d26a-46ae-9b08-3a21a5318f0f}interpretationId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{ac3c4ed2-2452-4f0d-b155-0cd7c57e2e2b}ruleId',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{04497cb9-4323-4c12-89aa-d58bf439c133}changeType',
          'recordType!{11e2a512-26dd-460d-81b3-e0a40ffad01b}TRICS Interpretation Change Mappings.fields.{a3572ccd-cabf-45bb-be97-1c03f46d3760}interpretationType'
        },
        filters: {
          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]
        )
      ).data,
      {}
    ),
    refreshOnVarChange: {
      local!refreshFlag,
      local!interpretationChangeMappings
    }
  ),
  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!selectionOfRulesIdsForDelete,
                            local!selectionOfRulesForDelete
                          },
                          null()
                        ),
                        a!save(local!refreshFlag, rand()),

                      },
                      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: "Regulator",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{d6a85e0f-11d1-4493-b426-71cec430c80c}ruleRegulator',
              value: {
                index(
                  rule!TRICS_qry_referenceData(refId: fv!row.regulator),
                  'recordType!{a5df3b5a-fa94-4763-a929-635cc5d66609}TRICS Reference Data.fields.{f115887f-d909-4f5d-8c5e-50897b6dd218}label',
                  "N/A"
                )
              },
              align: "START",
              width: "NARROW_PLUS"
            ),
            a!gridColumn(
              label: "Rule Source",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{ba799e31-9a6d-4cbe-afc3-487f8aaa14be}source',
              value: rule!TRICS_ExpandAndCollapseContent(inputText: fv!row.source),
              align: "START",
              width: "NARROW_PLUS"
            ),
            a!gridColumn(
              label: "Rule Type",
              sortField: 'recordType!{9a7c6e30-40be-4e30-b20e-026e445cadc7}TRICS Rule.fields.{7a89ec2b-31c0-4920-8e4a-f6c05c77f3b9}ruleType',
              value: index(
                rule!TRICS_qry_referenceData(refId: fv!row.type),
                'recordType!{a5df3b5a-fa94-4763-a929-635cc5d66609}TRICS Reference Data.fields.{f115887f-d909-4f5d-8c5e-50897b6dd218}label',
                "N/A"
              ),
              align: "START",
              width: "NARROW_PLUS"
            ),
            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()
        )
      }
    )
  }
)


    Thank you Shubham Aware and Harsha Sharma for quick support.

    Regards,
    Sandeep

  • 0
    Certified Senior Developer
     in reply to sandeepkumarn185922_Coforge

    For local variables {local!interpretationChangeMappings, local!interpretationChangeMappingsGridData}, i was using old version a!queryRecordType_24r4(). 
    Me and my team member tried with using latest version a!queryRecordType() and tested then the grid refreshing fine.

    Thank you Shubham Aware and Harsha Sharma for quick support.

© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.