=load( local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50, sort: a!sortInfo( field: "c3", ascending: false ) ), local!statusFilter: null, local!process, local!task, local!assigned, local!accept, with( local!datasubset: a!queryProcessAnalytics( report: cons!ALL_TASK_REPORT, query: a!query(logicalExpression: if( and(isnull(local!statusFilter),isnull(local!task),isnull(local!assigned),or(isnull(local!accept),local!accept="")), null, a!queryLogicalExpression( operator: "AND", filters: { if( isnull( local!statusFilter ), {}, a!queryFilter( field: "c1", operator: "=", value: local!statusFilter ) ), if( isnull( local!task ), {}, a!queryFilter( field: "c6", operator: "includes", value: local!task ) ), if( or(isnull(local!accept),local!accept=""), {}, a!queryFilter( field: "c4", operator: "in", value: local!accept ) ), if( isnull( local!assigned ), {}, a!queryFilter( field: "c5", operator: "=", value: local!assigned ) ) } ) ), pagingInfo: 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!sectionLayout( firstColumnContents: { a!gridField( label: local!datasubset.name, totalCount: local!datasubset.totalCount, columns: { apply( rule!util_portalReportColumn(columnConfig: _, data: local!datasubset.data), local!datasubset.columnConfigs ) }, value: local!pagingInfo, saveInto: local!pagingInfo ) }) } ) ) )