First grid is not refreshing when deleting the selected records

Question

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

Shubham Aware · Answer

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}

Shubham Aware · Answer

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.

Shubham Aware · Answer

Lets give this try once, 
 Add rand() to force refresh in delete button's onSuccess: a!save(local!refreshCounter, local!refreshCounter + 1), a!save(local!refreshFlag, rand()) 
 And ensure line 108 uses: refreshOnVarChange: {local!refreshCounter, local!refreshFlag}

Harsha Sharma · Answer

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.

Harsha Sharma · Answer

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}

First grid is not refreshing when deleting the selected records

Top Replies