load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 50,
    sort: a!sortInfo(
      field: "c3",
      ascending: false
    )
  ),
  local!statusFilter: null,
  local!button,
  local!process,
  local!task,
  local!assigned,
  local!accept,
  local!totalCountOfRecordsInAllTasksReport: a!queryProcessAnalytics(
    report: cons!ALL_TASK_REPORT,
    query: a!query(
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: 1
      )
    )
  ).totalCount,
  local!columnConfigs: local!totalCountOfRecordsInAllTasksReport: a!queryProcessAnalytics(
    report: cons!ALL_TASK_REPORT,
    query: a!query(
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: 1
      )
    )
  ).columnConfigs,
  local!additionalFilters: null,
  local!allTasksReportData: rule!CMN_queryProcessAnalyticsRecursively(
    report: cons!ALL_TASK_REPORT,
    totalCount: local!totalCountOfRecordsInAllTasksReport,
    additionalFilters: local!additionalFilters,
    resultantData: null,
    identifierField: "c10"
  ),
  with(
    local!datasubset: todatasubset(
      local!allTasksReportData,
      local!pagingInfo
    ),
    a!dashboardLayout(
      firstColumnContents: {
        a!sectionLayout(
          firstColumnContents: {
            a!dropdownField(
              label: "Status",
              choiceLabels: {
                "Assigned",
                "Accepted",
                "Completed"
              },
              choiceValues: enumerate(
                3
              ),
              placeholderLabel: "All",
              value: local!statusFilter,
              saveInto: {
                local!statusFilter,
                a!save(
                  local!pagingInfo.startIndex,
                  1
                )
              }
            ),
            a!textField(
              label: "Search By Task Display Name",
              value: local!task,
              refreshAfter: "KEYPRESS",
              saveInto: {
                local!task,
                a!save(
                  local!pagingInfo.startIndex,
                  1
                )
              }
            )
          },
          secondColumnContents: {
            a!pickerFieldUsersAndGroups(
              label: "Filter by Assigned To",
              value: local!accept,
              maxSelections: 1,
              saveInto: {
                local!accept,
                a!save(
                  local!pagingInfo.startIndex,
                  1
                )
              }
            ),
            a!pickerFieldUsers(
              label: "Accepted By",
              value: local!assigned,
              maxSelections: 1,
              saveInto: {
                local!assigned,
                a!save(
                  local!assigned,
                  tostring(
                    save!value
                  )
                ),
                a!save(
                  local!pagingInfo.startIndex,
                  1
                )
              }
            ),
            a!buttonLayout(
              primaryButtons: {
                a!buttonWidget(
                  label: "Submit",
                  style: "PRIMARY",
                  value: "Submit",
                  saveInto: {
                    local!button,
                    a!save(
                      local!additionalFilters,
                      if(
                        and(
                          isnull(
                            local!statusFilter
                          ),
                          isnull(
                            local!task
                          ),
                          isnull(
                            local!assigned
                          ),
                          or(
                            isnull(
                              local!accept
                            ),
                            local!accept = ""
                          )
                        ),
                        null,
                        {
                          if(
                            isnull(
                              local!statusFilter
                            ),
                            null,
                            a!queryFilter(
                              field: "c1",
                              operator: "=",
                              value: local!statusFilter
                            )
                          ),
                          if(
                            isnull(
                              local!task
                            ),
                            null,
                            a!queryFilter(
                              field: "c6",
                              operator: "includes",
                              value: local!task
                            )
                          ),
                          if(
                            or(
                              isnull(
                                local!accept
                              ),
                              local!accept = ""
                            ),
                            null,
                            a!queryFilter(
                              field: "c4",
                              operator: "in",
                              value: local!accept
                            )
                          ),
                          if(
                            isnull(
                              local!assigned
                            ),
                            null,
                            a!queryFilter(
                              field: "c5",
                              operator: "=",
                              value: local!assigned
                            )
                          )
                        }
                      )
                    ),
                    a!save(
                      local!allTasksReportData,
                      rule!CMN_queryProcessAnalyticsRecursively(
                        report: cons!ALL_TASK_REPORT,
                        totalCount: a!queryProcessAnalytics(
                          report: cons!ALL_TASK_REPORT,
                          query: a!query(
                            pagingInfo: a!pagingInfo(
                              startIndex: 1,
                              batchSize: 1
                            )
                          )
                        ).totalCount,
                        additionalFilters: local!additionalFilters,
                        resultantData: null,
                        identifierField: "c10"
                      )
                    )
                  }
                )
              }
            )
          }
        ),
		if(or(isnull(local!datasubset),local!datasubset=""), {}, 
		a!sectionLayout(
		firstColumnContents: {
    a!gridField(
      label: "All Task Report",
	  totalCount: local!datasubset.totalCount,
      columns: {
        apply(
          rule!util_portalReportColumn(columnConfig: _, data: local!datasubset.data),
          local!columnConfigs
        )
      },
      value: local!pagingInfo,
      saveInto: local!pagingInfo
    )
	}))
      }
    )
  )
)