load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 20,
    sort: a!sortInfo(
      field: "TrialName",
      ascending: true
    )
  ),
  local!monthofrelease,
  local!analyst,
  
  with(
    local!datasubset: queryrecord(cons!CONS_GCO_RECORD,
      a!query(
        selection: a!querySelection(columns: {
          a!queryColumn(field: "TrialName"),
          a!queryColumn(field: "WeekRelease"),
          a!queryColumn(field: "Analyst"),
          a!queryColumn(field: "Reviewer"),
          a!queryColumn(field: "MonthofRelease")
        }),
        
        
          logicalExpression: if(
          and(
            isnull(local!monthofrelease)
            ),
            null,
   a!queryLogicalExpression(
                      operator:"AND",
                        filters:{
                            if(
  
          isnull(local!monthofrelease),
          {},
          a!queryFilter(
            field:"MonthofRelease",
            operator:choose(local!monthofrelease,"=","=","=","=","=","=","=","=","=","=","=","="),
            value:choose(local!monthofrelease,1,2,3,4,5,6,7,8,9,10,11,12)
          )),
        }
        )
        ),
        pagingInfo: local!pagingInfo
      )
    ),
      {
      a!dropdownField(
        label:"Filter by Month of Release",
        labelPosition:"ADJACENT",
        choiceLabels:{{cons!CONS_GCO_MONTH_RELEASE_DISPLAY}},
        placeholderLabel:"ALL",
        choicevalues:{{cons!CONS_GCO_MONTH_RELEASE_VALUE}},
        value:local!monthofrelease,
        saveInto:{
          local!monthofrelease,
          a!save(local!pagingInfo.startIndex,1)
        }
        ),
    a!gridField(
      totalCount: local!datasubset.totalCount,
      columns: {
        a!gridTextColumn(
          label: "Trial Name",
          field: "TrialName",
          data: index(local!datasubset.data, "TrialName", null)
        ),
        a!gridTextColumn(
          label: "Week Release",
          field: "WeekRelease",
          data: index(local!datasubset.data, "WeekRelease", null)
        ),
        a!gridTextColumn(
          label: "CAF Analyst",
          field: "Analyst",
          data:apply(rule!getFormattedUserName(_),index(local!datasubset.data,"Analyst",null))
        ),
        a!gridTextColumn(
          label: "CAF Reviewer",
          field: "Reviewer",
          data:apply(rule!getFormattedUserName(_),index(local!datasubset.data,"Reviewer",null))
        )
      },
      value: local!pagingInfo,
      saveInto: local!pagingInfo
    )
      }
  )
)