Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejava
( $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'":"")

...