load(
  local!requestStatus:"All",
  local!team:"All",
  local!pagingInfo:a!pagingInfo(startIndex:1,batchsize:100),
  with(
    local!datasubset:a!queryProcessAnalytics(
      report:cons!EU_MOB_ALL_REQUEST_REPORT,
      contextProcessModels:cons!EU_MOB_REPOSITORY_REGISTRATION_MAIN,
      query: a!query(
        logicalExpression: if(and(local!team="All",local!requeststatus="All"),null,
        a!queryLogicalExpression(
        operator: "AND",
        filters:{
          if(local!requeststatus="All",{},
         a!queryFilter(
          field: "c20",
          operator:  if(local!requeststatus="All","not in",if(or(local!requeststatus="Completed",local!requeststatus="Cancel"),"in","=")),
          value:     if(local!requeststatus="All",{"Cancel","Cancelled","Complete","Completed","New"},
                        if(local!requeststatus="Completed",{"Complete","Completed"},
                        if(local!requeststatus="Cancel",{"Cancel","Cancelled"}, 
                        if(local!requeststatus="New","New",
                        local!requeststatus))))
        )),
        if(local!team="All",{},
          a!queryFilter(
          field: "c45",
           operator: "includes",
          value:local!team

        )),
        }
        )),
        pagingInfo:local!pagingInfo
      
      )
     
      ),
      a!formLayout(
        firstColumnContents: {
        a!sectionLayout(
      firstColumnContents: {
       a!dropdownField(
        label: "Request Status",
  
        choiceLabels: {"All","New","In Progress", "Completed","Cancel"},
        choiceValues: {"All","New","In Progress", "Completed","Cancel"},
        value: requestStatus,
        saveInto: {
          requestStatus,
        }
      ),
       a!dropdownField(
        label: "Asset Class",
       
        choiceLabels:  {"All","Ag","F","En","IR","ME","Others"},
        choiceValues: {"All","Ag","F","En","IR","Me","Others"},
        value: team,
        saveInto:team
          
      
   
      )     },
      secondColumnContents: { 
       
        }
    ),
       a!sectionLayout(
      firstColumnContents: {
      a!gridField(
        totalCount:
                if(local!datasubset.totalCount=0,101,local!datasubset.totalCount),
        columns:{
          if(local!datasubset.totalCount=0,{ 
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[1].label,
          
          data:"No Records"
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[2].label,
      
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[3].label,
         
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[4].label,
         
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[5].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[6].label,
         
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[7].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[8].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[9].label,
       
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[10].label,
         
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[11].label,
         
          data:""
        
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[12].label,
          data:""
       
        
        ) ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[13].label,
          
          data:""
        )
        ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[14].label,
        
          data:""
        )
        ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[15].label,
      
          data:""
        )
        ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[16].label,
         
          data:""
         
        )
        ,
        
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[17].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[18].label,
         
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[19].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[20].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[22].label,
          
          data:""
        )
        ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[21].label,
          
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[22].label,
         
          data:""
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[23].label,
          
          data:""
        ),
         a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[24].label,
          data:""
        )
        ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[25].label,
          data:""
        )},{
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[1].label,
          field:local!datasubset.ColumnConfigs[1].field,
          data:index(local!datasubset.data,"c0",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[2].label,
          field:local!datasubset.ColumnConfigs[2].field,
          data:index(local!datasubset.data,"c50",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[3].label,
          field:local!datasubset.ColumnConfigs[3].field,
          data:index(local!datasubset.data,"c51",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[4].label,
          field:local!datasubset.ColumnConfigs[4].field,
          data:index(local!datasubset.data,"c6",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[5].label,
          field:local!datasubset.ColumnConfigs[5].field,
          data:index(local!datasubset.data,"c8",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[6].label,
          field:local!datasubset.ColumnConfigs[6].field,
          data:index(local!datasubset.data,"c9",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[7].label,
          field:local!datasubset.ColumnConfigs[7].field,
          data:index(local!datasubset.data,"c45",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[8].label,
          field:local!datasubset.ColumnConfigs[8].field,
          data:index(local!datasubset.data,"c10",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[9].label,
          field:local!datasubset.ColumnConfigs[9].field,
          data:index(local!datasubset.data,"c19",{})
        ),
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[10].label,
          field:local!datasubset.ColumnConfigs[10].field,
          data:index(local!datasubset.data,"c30",{})
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[11].label,
          field:local!datasubset.ColumnConfigs[11].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c36",{})),
        size :"ICON"
        
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[12].label,
          field:local!datasubset.ColumnConfigs[12].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c37",{}))
        ,size :"ICON"
        
        ) ,
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[13].label,
          field:local!datasubset.ColumnConfigs[13].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c21",{})),
          size :"ICON"
        )
        ,
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[14].label,
          field:local!datasubset.ColumnConfigs[14].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c22",{})),
          size :"ICON"
        )
        ,
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[15].label,
          field:local!datasubset.ColumnConfigs[15].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c23",{})),
            size :"ICON"
        )
        ,
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[16].label,
          field:local!datasubset.ColumnConfigs[16].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c24",{})),
          size :"ICON"
        )
        ,
        
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[17].label,
          field:local!datasubset.ColumnConfigs[17].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c48",{})),
          size :"ICON"
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[18].label,
          field:local!datasubset.ColumnConfigs[18].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c11",{})),
          size :"ICON"
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[19].label,
          field:local!datasubset.ColumnConfigs[19].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c12",{})),
          size :"ICON"
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[20].label,
          field:local!datasubset.ColumnConfigs[20].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c13",{})),
          size :"ICON"
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[22].label,
          field:local!datasubset.ColumnConfigs[22].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c13",{})),
          size :"ICON"
        )
        ,
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[21].label,
          field:local!datasubset.ColumnConfigs[21].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c14",{})),
          size :"ICON"
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[22].label,
          field:local!datasubset.ColumnConfigs[22].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c15",{})),
          size :"ICON"
        ),
        a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[23].label,
          field:local!datasubset.ColumnConfigs[23].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c16",{})),
          size :"ICON"
        ),
         a!gridImageColumn(
          label:local!datasubset.ColumnConfigs[24].label,
          field:local!datasubset.ColumnConfigs[24].field,
          data:apply(rule!euMobStatusGamCoustomerDocumentation(_),index(local!datasubset.data,"c17",{})),
          size :"ICON"
        )
        ,
        a!gridTextColumn(
          label:local!datasubset.ColumnConfigs[25].label,
          field:local!datasubset.ColumnConfigs[25].field,
          data:index(local!datasubset.data,"c20",{})
        )})
    },
        value:local!pagingInfo,
        saveInto:local!pagingInfo
        
      )
      
      })}
    )
  )
)