= load(
 local!status, 
 local!pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 10,
      sort: a!sortInfo(
        field: "parentRequestId",
        ascending: true
      )
    ),
  with(
    
     local!periodicData:if(or(isnull(local!status),local!status=""),rule!GOE_getPeriodicRechargeData(),rule!GOE_getPeriodicRechargeByStatus(local!status)),
     local!datasubset: todatasubset(
      local!periodicData,
      local!pagingInfo
    ),
	
   a!sectionLayout( 
   
     label: "Periodic and True-up Recharge Requests",
   firstColumnContents:{
  
        a!dropdownField(
          label:"Status",
          choiceLabels:cons!GOE_PERIODIC_STATUS,
          PlaceholderLabel:"All",
          choiceValues:cons!GOE_PERIODIC_STATUS,
          value:local!status,
          saveInto: local!status
        ),
	
		 if(or(local!datasubset.data="",isnull(local!datasubset.data),local!datasubset.totalCount=0),a!textField(label:"No Data Available",readOnly:true()),{
        a!gridField(
          label: " ",
          totalCount: local!datasubset.totalCount,
          columns: {
            a!gridTextColumn(
              label: "Parent/Initial Approval Request ID",
              field: "parentRequestId",
              data: apply(rule!GOE_getAppianRequestIdByReqId,index(
                local!datasubset.data,
                "parentRequestId",
                {}
              )),
               links: apply(rule!GOE_buildRequestRecordLink,index(local!datasubset.data, "parentRequestId", null))
            ),
            a!gridTextColumn(
              label: "Recharge Type",
              field: "rquestType",
              data: index(
                local!datasubset.data,
                "requestType",
                {}
              )
            ),
         a!gridTextColumn(
              label: "Start Date",
              field: "periodStartDate",
              data: apply(rule!GOE_checkDateforNull,index(
                local!datasubset.data,
                "periodStartDate",
                {}
              ))),
            a!gridTextColumn(
              label: "Amount",
              field: "Amount",
              data: index(
                local!datasubset.data,
                "Amount",
                {}
              )
            ),  a!gridTextColumn(
              label: "Status",
              field: "Status",
             data:apply(rule!GOE_getStatusAppendedWithReqId,merge(index(
                local!datasubset.data,
                "Status",
                {}
              ),index(local!datasubset.data, "appianRequestId", null))),
			 links: apply(rule!GOE_buildLinkforActivatedRequests,index(local!datasubset.data, "appianRequestId", null))
            ),
            a!gridTextColumn(
              label: "Activation Date",
              field: "periodActivationDate",
              data:apply(rule!GOE_formatActivationDate,index(
                local!datasubset.data,
                "periodActivationDate",
                {}
              ))
            ),
            a!gridTextColumn(
              label: "Completion Date",
              field: "periodCompletionDate",
              data: index(
                local!datasubset.data,
                "periodCompletionDate",
                {}
              )
            )
          },
           value: local!pagingInfo,
		  saveInto: local!pagingInfo
        
        )
		})
 }
  )
)
)

```````````````````````````````
Link Code
````````````````````````````````

with(
  requestId: if(
    or(
      ri!appianReqId = "",
      isnull(
        ri!appianReqId
      )
    ),
    - 1,
    rule!GOE_getRequestIdByAppianReqId(
      ri!appianReqId
    ).requestId
  ),
  if(
    tointeger(
      local!requestId < 0
    ),
    {},
    a!safeLink(
      uri: urlforrecord(
        cons!GOE_REQUESTS_RECORD,
        local!requestId
      ),
      label: ""
    )
  )
)