18 lines
623 B
Plaintext
18 lines
623 B
Plaintext
@AccessControl.authorizationCheck: #NOT_REQUIRED
|
|
@EndUserText.label: 'Lessons with instructor'
|
|
define view entity {{P}}I_LESSON_INSTR
|
|
as select from {{p}}lesson as lesson
|
|
association [1..1] to {{p}}instr as _instructor
|
|
on lesson.instr_id = _instructor.instr_id
|
|
{
|
|
key lesson.lesson_id as lesson_id,
|
|
lesson.instr_id as instr_id,
|
|
lesson.lesson_date as lesson_date,
|
|
lesson.duration as duration,
|
|
lesson.fee as fee,
|
|
_instructor.full_name as instructor_name,
|
|
_instructor.city as instructor_city,
|
|
_instructor
|
|
}
|
|
where lesson.duration >= 45
|