• State Suggested Answer
  • Replies 13 replies
  • Answers 5 answers
  • Subscribers 11 subscribers
  • Views 463 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 Associate 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
  • 0
    Certified Lead Developer

    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. 

  • 0
    Certified Associate 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 Associate Developer
     in reply to Harsha Sharma

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


  • 0
    Certified Associate 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 Associate 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.

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