| insert | insert | AUTO_ID: reservationID
| Creates a new row on Reservation table.
| |
| read | read | | Reads a row of data from Reservation table. | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies an existing row on Reservation table.
| |
| remove | remove | | Removes an existing row from Reservation table.
| |
| searchReservationByPlaceAndDateTime | readmulti | ORDER_BY: placeID
WHERE: placeId=:id
AND
fromDate<=:dateTime
AND (toDate is NULL or toDate>=:dateTime) AND status =:recordStatus
| Searches for all the Reservations on this Place with give date time. | |
| searchReservationByCaseParticipantRole | readmulti | | | |
| searchReservationByClient | nsmulti | | | SQL |
| searchReservationByStatus | readmulti | ORDER_BY: reservationID
| Searches for all Reservations based on status. | |
| searchReservationByPlace | readmulti | | Searches for all the Reservations on this Place. | |
| searchByProviderOffering | readmulti | ORDER_BY: fromDate
WHERE: providerOfferingID= :providerOfferingID
AND status= :status
| Searches reservation by a Provider Offering. | |
| searchBy | nsmulti | | | SQL |
| searchByCompartmentIDAndStatus | nsmulti | | Searches for all the latest Reservation based on Compartment and Reservation status. | SQL |
| searchReservationByPlaceAndDateTimeRange | readmulti | WHERE: placeID = :placeID AND status = :status AND (
(fromDate >= :fromDate AND (:toDate IS NULL OR fromDate <= :toDate)) OR
(fromDate <= :fromDate AND (toDate IS NULL OR toDate >= :fromDate))
)
| Searches for all the Reservations on the given Place, Date time range and the Status. | |
| searchByDateRangeAndStatus | nsmulti | | Searches all the reservations for a given status whose start date is between the date range.
@deprecated Since Curam 6.0 SP1, replaced with {@link #searchByDateTimeRangeAndStatus(DateTime, DateTime, RESERVATIONSTATUSEntry)}. This method is comparing reservation start date time with date range instead of date time range. Hence this method is deprecated. The newly added method will compare reservation start date time with date time range. See release note:CR00260608. | SQL |
| searchByProviderOfferingStartDateRangeAndStatus | nsmulti | | Searches all the reservations with given provider offering which are starting within the given date range for a given status.
@deprecated Since Curam 6.0 SP1, replaced with {@link #searchByProviderOfferingStartDateTimeRangeAndStatus(ProviderOffering, DateTime, DateTime, RESERVATIONSTATUSEntry)}. This method is comparing reservation start date time with date range instead of date time range. Hence this method is deprecated. The newly added method will compare reservation start date time with date time range. See release note:CR00260608.
| SQL |
| searchByDateTimeRangeAndStatus | nsmulti | | | SQL |
| searchByProviderOfferingStartDateTimeRangeAndStatus | nsmulti | | | SQL |
