...
Code Block | ||
---|---|---|
| ||
( $P{eduProgramEnrolmentIdstudentPartyId}==null || $P{eduProgramEnrolmentIdstudentPartyId}.equals("") ? "" : "\n AND epep.edu_program_enrolment_idstudent_number = '" + $P{eduProgramEnrolmentIdstudentPartyId}+"'" ) + ( $P{academicTermIdstudentNumber}==null || $P{academicTermIdstudentNumber}.equals("") ? "" : "\n AND tpp.custom_time_period_idstudent_number = '" + $P{academicTermIdstudentNumber}+"'" ) + ( $P{courseIdeduProgramEnrolmentId}==null || $P{courseIdeduProgramEnrolmentId}.equals("") ? "" : "\n AND epe.edu_program_enrolment_id = '"+$P{courseIdeduProgramEnrolmentId}+"'" ) + ( $P{providerIdcourseProviderId}==null || $P{providerIdcourseProviderId}.equals("") ? "" : "\n AND epe.home_institution_party_id =IN '" + $P{providerIdcourseProviderId}+"'" ) + ( $P{studentNumbercourseIdList}==null || $P{studentNumbercourseIdList}.equals("") ? "" : "\n AND lsiepe.student_number = '"+$P{studentNumber}+"'"edu_program_id IN " + $P{courseIdList} ) + ( $P{censusPeriodIdcourseEnrolmentStatusList}==null || $P{censusPeriodIdcourseEnrolmentStatusList}.equals("") ? "" : "\n AND esuepe.destenrolment_censusstatus_dateid IN "+$P{censusPeriodId}) + /* ( $P{censusDateFromcourseEnrolmentStatusList}==null || $P{censusDateFrom}.equals("") ? "" : " AND esu.dest_census_date >= '"+$P{censusDateFrom}+"'" ) + ( $P{censusDateTograduationDateFrom} == null || $P{censusDateTograduationDateFrom}.equals("") ? "" : "\n AND esuepe.dest_censusgrad_date <>= '"+$P{censusDateTograduationDateFrom}+"'" ) + */ ( $P{unitEnrolmentStatusgraduationDateTo} == null || $P{unitEnrolmentStatusgraduationDateTo}.equals("") ? "" : "\n AND eueepe.enrolment_statusgrad_iddate IN<= '"+$P{unitEnrolmentStatusgraduationDateTo}+"'" ) + ((($P{eduProgramEnrolmentIdstudentPartyId}==null || $P{eduProgramEnrolmentIdstudentPartyId}.equals(""))&& ($P{academicTermIdstudentNumber}==null || $P{academicTermIdstudentNumber}.equals(""))&& ($P{courseIdeduProgramEnrolmentId}==null || $P{courseIdeduProgramEnrolmentId}.equals(""))&& ($P{providerIdcourseProviderId}==null || $P{providerIdcourseProviderId}.equals(""))&& ($P{studentNumbercourseIdList}==null || $P{studentNumbercourseIdList}.equals(""))&& ($P{censusDateFromcourseEnrolmentStatusList}==null || $P{censusDateFromcourseEnrolmentStatusList}.equals(""))&& ($P{censusDateTograduationDateFrom}==null || $P{censusDateTograduationDateFrom}.equals(""))&& ($P{censusPeriodIdgraduationDateTo}==null || $P{censusPeriodIdgraduationDateTo}.equals(""))&& ) ($P{unitEnrolmentStatus}==null || $P{unitEnrolmentStatus}.equals("")))?? " AND epe.edu_program_enrolment_id='No Parameters'":"") |
...