rule!PD_getOpportunitiesForStatusReport( logicalExpression: a!queryLogicalExpression( operator: "AND", logicalExpressions: { if( and( rule!APN_isBlank(a!fromJson(ri!input).filterOpportunityID), rule!APN_isBlank(a!fromJson(ri!input).filterFID), rule!APN_isBlank(a!fromJson(ri!input).filterName), rule!APN_isBlank(a!fromJson(ri!input).filterManagementRegion), rule!APN_isBlank(a!fromJson(ri!input).filterGeographicRegion), rule!APN_isBlank(a!fromJson(ri!input).filterAccount), rule!APN_isBlank(a!fromJson(ri!input).filterCustomer), rule!APN_isBlank(a!fromJson(ri!input).filterFabSegment), rule!APN_isBlank(a!fromJson(ri!input).filterProjectType), rule!APN_isBlank(a!fromJson(ri!input).filterReportingType), rule!APN_isBlank(a!fromJson(ri!input).filterCorporateLevel), rule!APN_isBlank(a!fromJson(ri!input).filterCompetitor), rule!APN_isBlank(a!fromJson(ri!input).filterStrategicRelevance), rule!APN_isBlank(a!fromJson(ri!input).filterProductGroupOwner), rule!APN_isBlank(a!fromJson(ri!input).filterAccountTeamOwner), rule!APN_isBlank(a!fromJson(ri!input).filterProjectStage), rule!APN_isBlank(a!fromJson(ri!input).filterProjectStatus), rule!APN_isBlank(a!fromJson(ri!input).filterAlignmentStatus), rule!APN_isBlank(a!fromJson(ri!input).filterDecisionQuarter), rule!APN_isBlank(a!fromJson(ri!input).filterProductGroup), rule!APN_isBlank(a!fromJson(ri!input).filterBusinessUnit), rule!APN_isBlank(a!fromJson(ri!input).filterProductLine), rule!APN_isBlank(a!fromJson(ri!input).filterTargetTool), rule!APN_isBlank(a!fromJson(ri!input).filterNode), rule!APN_isBlank(a!fromJson(ri!input).filterPGPriority), rule!APN_isBlank(a!fromJson(ri!input).filterATPriority), rule!APN_isBlank(a!fromJson(ri!input).filterPGTargetBudget), rule!APN_isBlank(a!fromJson(ri!input).filterATTargetBudget) ), {}, a!queryLogicalExpression( operator: "AND", filters: { if( rule!APN_isBlank(a!fromJson(ri!input).filterOpportunityID), null, a!queryFilter( field:"opportunityId", operator:"in", value: a!fromJson(ri!input).filterOpportunityID ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterFID), null, a!queryFilter( field:"forecastId", operator:"in", value: a!fromJson(ri!input).filterFID ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterName), null, a!queryFilter( field:"applicationName", operator:"in", value: a!fromJson(ri!input).filterName ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterManagementRegion), null, a!queryFilter( field:"managementRegion", operator:"=", value: a!fromJson(ri!input).filterManagementRegion ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterGeographicRegion), null, a!queryFilter( field:"geoRegion", operator:"=", value: a!fromJson(ri!input).filterGeographicRegion ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterAccount), null, a!queryFilter( field:"account", operator:"=", value: a!fromJson(ri!input).filterAccount ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterCustomer), null, a!queryFilter( field:"customer", operator:"=", value: a!fromJson(ri!input).filterCustomer ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterFabSegment), null, a!queryFilter( field:"fabSegment", operator:"=", value: a!fromJson(ri!input).filterFabSegment ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterProjectType), null, a!queryFilter( field:"projectType", operator:"in", value: a!fromJson(ri!input).filterProjectType ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterReportingType), null, a!queryFilter( field:"reportingType", operator:"=", value: a!fromJson(ri!input).filterReportingType ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterCorporateLevel), null, a!queryFilter( field:"corporateLevel", operator:"=", value: a!fromJson(ri!input).filterCorporateLevel ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterCompetitor), null, a!queryFilter( field:"competitor", operator:"=", value: a!fromJson(ri!input).filterCompetitor ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterStrategicRelevance), null, a!queryFilter( field:"strategicRelevance", operator:"=", value: a!fromJson(ri!input).filterStrategicRelevance ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterProductGroupOwner), null, a!queryFilter( field:"productGroupOwner", operator:"=", value: a!fromJson(ri!input).filterProductGroupOwner ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterAccountTeamOwner), null, a!queryFilter( field:"accountTeamOwner", operator:"in", value: a!fromJson(ri!input).filterAccountTeamOwner ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterProjectStage), null, a!queryFilter( field:"projectStage", operator:"in", value: a!fromJson(ri!input).filterProjectStage ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterProjectStatus), null, a!queryFilter( field:"projectStatus", operator:"in", value: a!fromJson(ri!input).filterProjectStatus ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterAlignmentStatus), null, a!queryFilter( field:"alignmentStatus", operator:"=", value: a!fromJson(ri!input).filterAlignmentStatus ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterDecisionQuarter), null, a!queryFilter( field:"decisionQuarter", operator:"in", value: a!fromJson(ri!input).filterDecisionQuarter ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterProductGroup), null, a!queryFilter( field:"productGroup", operator:"=", value: a!fromJson(ri!input).filterProductGroup ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterBusinessUnit), null, a!queryFilter( field:"businessUnit", operator:"=", value: a!fromJson(ri!input).filterBusinessUnit ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterProductLine), null, a!queryFilter( field:"productLine", operator:"=", value: a!fromJson(ri!input).filterProductLine ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterTargetTool), null, a!queryFilter( field:"targetTool", operator:"=", value: a!fromJson(ri!input).filterTargetTool ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterNode), null, a!queryFilter( field:"node", operator:"=", value: a!fromJson(ri!input).filterNode ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterPGPriority), null, a!queryFilter( field:"pgPriority", operator:"=", value: a!fromJson(ri!input).filterPGPriority ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterATPriority), null, a!queryFilter( field:"atPriority", operator:"=", value: a!fromJson(ri!input).filterATPriority ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterPGTargetBudget), null, a!queryFilter( field:"pgTargetBudget", operator:"=", value: a!fromJson(ri!input).filterPGTargetBudget ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterATTargetBudget), null, a!queryFilter( field:"atTargetBudget", operator:"=", value: a!fromJson(ri!input).filterATTargetBudget ) ) } ) ), if( rule!APN_isBlank(a!fromJson(ri!input).filterFab), {}, a!queryLogicalExpression( operator: "OR", filters: { a!applyComponents( a!queryFilter( field: "customerFab", operator: "includes", value: _ ), a!fromJson(ri!input).filterFab ) } ) ), rule!PD_getUserAccessLogicalExpression(a!fromJson(ri!input).user) } ), selection: a!querySelection( columns: { a!queryColumn(field: "opportunityId", alias: "opportunityId", visible: true()), a!queryColumn(field: "projectType", alias: "projectType", visible: true()), a!queryColumn(field: "projectAndAlignmentStatus", alias: "projectAndAlignmentStatus", visible: true()), a!queryColumn(field: "applicationName", alias: "applicationName", visible: true()), a!queryColumn(field: "corpReportingType", alias: "corpReportingType", visible: true()), a!queryColumn(field: "node", alias: "node", visible: true()), a!queryColumn(field: "customer", alias: "customer", visible: true()), a!queryColumn(field: "relevantDivision", alias: "relevantDivision", visible: true()), a!queryColumn(field: "strategicRelevance", alias: "strategicRelevance", visible: true()), a!queryColumn(field: "threeYearRevenue", alias: "threeYearRevenue", visible: true()), a!queryColumn(field: "pgPriority", alias: "pgPriority", visible: true()), a!queryColumn(field: "atPriority", alias: "atPriority", visible: true()), a!queryColumn(field: "decisionQuarter", alias: "decisionQuarter", visible: true()), a!queryColumn(field: "modifiedBy", alias: "modifiedBy", visible: true()), a!queryColumn(field: "modifiedDate", alias: "modifiedDate", visible: true()), a!queryColumn(field: "forecastId", alias: "forecastId", visible: false()), a!queryColumn(field: "managementRegion", alias: "managementRegion", visible: false()), a!queryColumn(field: "geoRegion", alias: "geoRegion", visible: false()), a!queryColumn(field: "geoRegionGroupIds", alias: "geoRegionGroupIds", visible: false()), a!queryColumn(field: "account", alias: "account", visible: false()), a!queryColumn(field: "accountId", alias: "accountId", visible: false()), a!queryColumn(field: "customerFab", alias: "customerFab", visible: false()), a!queryColumn(field: "fabSegment", alias: "fabSegment", visible: false()), a!queryColumn(field: "reportingType", alias: "reportingType", visible: false()), a!queryColumn(field: "corporateLevel", alias: "corporateLevel", visible: false()), a!queryColumn(field: "competitor", alias: "competitor", visible: false()), a!queryColumn(field: "productGroupOwner", alias: "productGroupOwner", visible: false()), a!queryColumn(field: "accountTeamOwner", alias: "accountTeamOwner", visible: false()), a!queryColumn(field: "projectStage", alias: "projectStage", visible: false()), a!queryColumn(field: "projectStatus", alias: "projectStatus", visible: false()), a!queryColumn(field: "alignmentStatus", alias: "alignmentStatus", visible: false()), a!queryColumn(field: "productGroup", alias: "productGroup", visible: false()), a!queryColumn(field: "businessUnit", alias: "businessUnit", visible: false()), a!queryColumn(field: "productLine", alias: "productLine", visible: false()), a!queryColumn(field: "targetTool", alias: "targetTool", visible: false()), a!queryColumn(field: "pgTargetBudget", alias: "pgTargetBudget", visible: false()), a!queryColumn(field: "atTargetBudget", alias: "atTargetBudget", visible: false()), a!queryColumn(field: "oneYearRevenue", alias: "oneYearRevenue", visible: false()) } ), pagingInfo: ri!pagingInfo )