Operation | Stereotype | Options | Description | SQL |
insert | insert | AUTO_ID: trainingID
AUTO_ID_KEY: TRAIN
| Creates a new record on Training table. | |
read | read | | Reads an existing record on Training table. | |
modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies an existing record on training table. | |
searchBy | readmulti | ORDER_BY: trainingName
WHERE: (
:searchByName = '0'
OR Training.trainingNameUpper like :trainingName
)
AND
(
:searchByType = '0'
OR Training.trainingType = :trainingType
)
AND
Training.recordStatus = :recordStatus
| Searches for the records in Training table matching the search criteria entered . | |
readAll | nkreadmulti | ORDER_BY: trainingName
| Retrieves all the records from the Training table. | |
searchByName | readmulti | | Searches for the records in Training table matching the training name. | |
insertTraining | nsinsert | | Inserts record to Training entity. This method expects Training
ID to be set by the caller, if not set it delegates the call to insert() which
is modeled to auto generate primary key field Training ID). It's
preferred to call insertTraining only in scenario's where caller wants to
set the value of primary key by itself. | |
|