load( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: cons!GLOB_BATCH_SIZE_FOR_OUTSTANDING_PROCESS_REPORT_GRID ), local!wellName_txt, local!uwi_txt, local!classification_txt, local!operatingDistrict_txt, local!license_txt, local!businessUnit_txt, local!wellNameFilter_txt, local!uwiFilter_txt, local!classificationFilter_txt, local!operatingDistrictFilter_txt, local!licenseFilter_txt, local!businessUnitFilter_txt, with( local!dataSubset: getportalreportdatasubset( reportId: cons!GM_REPORT_REPAIR_SCHEDULE, pagingInfo: local!pagingInfo, contextIds:{}, filters: { {field: 5, operator: "LIKE", value: "*" & local!wellNameFilter_txt & "*"}, {field: 7, operator: "LIKE", value: "*" & local!uwiFilter_txt & "*"}, {field: 4, operator: "LIKE", value: "*" & local!licenseFilter_txt & "*"}, if( isnull(local!businessUnitFilter_txt), {}, {field: 3, operator: "EQUAL", value: local!businessUnitFilter_txt} ), if( isnull(local!operatingDistrictFilter_txt), {}, {field: 16, operator: "EQUAL", value: local!operatingDistrictFilter_txt} ), if( isnull(local!classificationFilter_txt), {}, {field: 9, operator: "EQUAL", value: local!classificationFilter_txt} ) } ), { a!sectionLayout( label: "Export and Filters", firstColumnContents:{ rule!GLOB_linkFieldExportToExcel(cons!GM_REPORT_REPAIR_SCHEDULE_FOR_EXCEL,"Export GM Repair Schedule Report") } ), a!sectionLayout( firstColumnContents:{ a!textField( label: "Well Name", labelPosition: "ADJACENT", value: local!wellName_txt, saveInto: local!wellName_txt ), a!textField( label: "UWI", labelPosition: "ADJACENT", value: local!uwi_txt, saveInto: local!uwi_txt ), a!dropdownField( label: "Classification", labelPosition: "ADJACENT", choiceLabels: {cons!GM_CLASSIFICATION_SERIOUS, cons!GM_CLASSIFICATION_CONSIDERED_NONSERIOUS, cons!GM_CLASSIFICATION_NON_SERIOUS}, placeHolderLabel: cons!GLOB_PLACEHOLDER_LABEL_ALL,/*{cons!GM_CLASSIFICATION_SERIOUS, cons!GM_CLASSIFICATION_NON_SERIOUS, cons!GM_CLASSIFICATION_BECAME_SERIOUS, cons!GM_CLASSIFICATION_REMAIN_NONSERIOUS, cons!GM_CLASSIFICATION_CONSIDERED_NONSERIOUS, cons!GM_CLASSIFICATION_DIED_OUT},*/ choiceValues: {cons!GM_CLASSIFICATION_SERIOUS, cons!GM_CLASSIFICATION_CONSIDERED_NONSERIOUS, cons!GM_CLASSIFICATION_NON_SERIOUS}, value: local!classification_txt, saveInto: local!classification_txt ) }, secondColumnContents:{ a!dropdownField( label: "Business Unit", labelPosition: "ADJACENT", choiceLabels: cons!GLOB_LIST_OF_BUSINESS_UNITS, placeHolderLabel: cons!GLOB_PLACEHOLDER_LABEL_ALL, choiceValues: cons!GLOB_LIST_OF_BUSINESS_UNITS, value: local!businessUnit_txt, saveInto: local!businessUnit_txt ), a!dropdownField( label: "Operating District", labelPosition: "ADJACENT", choiceLabels: cons!GLOB_LIST_OF_OPERATING_DISTRICT, placeholderLabel:cons!GLOB_PLACEHOLDER_LABEL_ALL, choiceValues: cons!GLOB_LIST_OF_OPERATING_DISTRICT, value: local!operatingDistrict_txt, saveInto: local!operatingDistrict_txt ), a!textField( label: "License", labelPosition: "ADJACENT", value: local!license_txt, saveInto: local!license_txt ) } ), a!buttonLayout( primaryButtons:{ a!buttonWidget( label:cons!GLOB_LABEL_SEARCH_BUTTON, style:"PRIMARY", saveInto:{ local!businessUnitFilter_txt << rule!GLOB_returnFirstInput(local!businessUnit_txt,_), local!wellNameFilter_txt << rule!GLOB_returnFirstInput(local!wellName_txt,_), local!uwiFilter_txt << rule!GLOB_returnFirstInput(local!uwi_txt,_), local!operatingDistrictFilter_txt << rule!GLOB_returnFirstInput(local!operatingDistrict_txt,_), local!classificationFilter_txt << rule!GLOB_returnFirstInput(local!classification_txt,_), local!licenseFilter_txt << rule!GLOB_returnFirstInput(local!license_txt,_), local!pagingInfo.startIndex << rule!GLOB_returnFirstInput(1,_) } ), a!buttonWidget( label:cons!GLOB_LABEL_CLEAR_SEARCH_BUTTON, style:"NORMAL", saveInto:{ local!businessUnit_txt << rule!GLOB_returnFirstInput(null,_), local!businessUnitFilter_txt << rule!GLOB_returnFirstInput(null,_), local!wellName_txt << rule!GLOB_returnFirstInput(null,_), local!wellNameFilter_txt << rule!GLOB_returnFirstInput(null,_), local!uwi_txt << rule!GLOB_returnFirstInput(null,_), local!uwiFilter_txt << rule!GLOB_returnFirstInput(null,_), local!operatingDistrict_txt << rule!GLOB_returnFirstInput(null,_), local!operatingDistrictFilter_txt << rule!GLOB_returnFirstInput(null,_), local!classification_txt << rule!GLOB_returnFirstInput(null,_), local!classificationFilter_txt << rule!GLOB_returnFirstInput(null,_), local!license_txt << rule!GLOB_returnFirstInput(null,_), local!licenseFilter_txt << rule!GLOB_returnFirstInput(null,_), local!pagingInfo.startIndex << rule!GLOB_returnFirstInput(1,_) } ) } ), a!sectionLayout( firstColumnContents:{ a!gridField( label: "Repair Schedule Report", totalCount: local!datasubset.totalCount, columns: { a!gridTextColumn( label: local!datasubset.columns[1].label, field: local!datasubset.columns[1].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[1].cells.value ), alignment: local!datasubset.columns[1].alignment, links: if( local!datasubset.totalCount=0, {}, apply(a!recordLink( identifier: _, recordType: cons!GLOB_RECORD_WELL), local!datasubset.data[14].cells.value ) ) ), a!gridTextColumn( label: local!datasubset.columns[2].label, field: local!datasubset.columns[2].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[2].cells.value ), alignment: local!datasubset.columns[2].alignment ), a!gridTextColumn( label: local!datasubset.columns[3].label, field: local!datasubset.columns[3].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[3].cells.value ), alignment: local!datasubset.columns[3].alignment ), a!gridTextColumn( label: local!datasubset.columns[4].label, field: local!datasubset.columns[4].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[4].cells.value ), alignment: local!datasubset.columns[4].alignment ), a!gridTextColumn( label: local!datasubset.columns[5].label, field: local!datasubset.columns[5].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[5].cells.value ), alignment: local!datasubset.columns[5].alignment ), a!gridTextColumn( label: local!datasubset.columns[14].label, field: local!datasubset.columns[14].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[14].cells.value ), alignment: local!datasubset.columns[14].alignment ), a!gridTextColumn( label: local!datasubset.columns[6].label, field: local!datasubset.columns[6].field, data: if( local!datasubset.totalCount=0, {}, apply(rule!displayDateTimeSimple(_), local!datasubset.data[6].cells.value) ), alignment: local!datasubset.columns[6].alignment ), a!gridTextColumn( label: local!datasubset.columns[7].label, field: local!datasubset.columns[7].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[7].cells.value ), alignment: local!datasubset.columns[7].alignment, links: if( local!datasubset.totalCount=0, {}, apply(a!recordLink( identifier: _, recordType: cons!GM_RECORD), local!datasubset.data[15].cells.value ) ) ), a!gridTextColumn( label: local!datasubset.columns[8].label, field: local!datasubset.columns[8].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[8].cells.value ), alignment: local!datasubset.columns[8].alignment ), a!gridTextColumn( label: local!datasubset.columns[9].label, field: local!datasubset.columns[9].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[9].cells.value ), alignment: local!datasubset.columns[9].alignment ), a!gridTextColumn( label: local!datasubset.columns[10].label, field: local!datasubset.columns[10].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[10].cells.value ), alignment: local!datasubset.columns[10].alignment ), a!gridTextColumn( label: local!datasubset.columns[11].label, field: local!datasubset.columns[11].field, data: if( local!datasubset.totalCount=0, {}, local!datasubset.data[11].cells.value ), alignment: local!datasubset.columns[11].alignment ), a!gridTextColumn( label: local!datasubset.columns[12].label, field: local!datasubset.columns[12].field, data: if( local!datasubset.totalCount=0, {}, apply(rule!APN_displayGroupOrUsername(_),local!datasubset.data[12].cells.value) ), alignment: local!datasubset.columns[12].alignment ), a!gridTextColumn( label: local!datasubset.columns[13].label, field: local!datasubset.columns[13].field, data: if( local!datasubset.totalCount=0, {}, apply(rule!APN_displayGroupOrUsername(_),local!datasubset.data[13].cells.value) ), alignment: local!datasubset.columns[13].alignment ) }, value: local!pagingInfo, saveInto: local!pagingInfo ) } ) } ) )