CREATE VIEW [dbo].[TeachersStudents]
AS
SELECT T.teacherId, TC.classId, S.studentId, S.studentFirstName, S.studentLastName,
C.className, CS.classstudentAcademicYear, T.teacherFirstName,
T.teacherLastName
FROM dbo.Teachers AS T INNER JOIN
dbo.TeachersClasses AS TC ON T.teacherId = TC.teacherId LEFT OUTER JOIN
dbo.ClassesStudents AS CS ON TC.classId = CS.classId LEFT OUTER JOIN
dbo.Classes AS C ON TC.classId = C.classId LEFT OUTER JOIN
dbo.Students AS S ON CS.studentId = S.studentId
TeachersClasses -> TeachersStudents by teacherId and classId
[MetadataType(typeof(TeachersStudents_MD))]
public partial class TeachersStudents
{
public class TeachersStudents_MD
{
[FilterUIHint("Cascade")]
[nacDA.Cascade("Teachers")]
public object TeachersClasses { get; set; }
}
}
[MetadataType(typeof(TeachersClasses_MD))]
public partial class TeachersClasses
{
public string classCall
{
get
{
return this.Classes.className;
}
}
[DisplayColumn("classCall")]
public class TeachersClasses_MD
{
}
}
Member
71 Points
48 Posts
Re: Filter Problem
May 31, 2013 05:31 AM|valZ|LINK
TeachersClasses -> TeachersStudents by teacherId and classId
If I understand correctly.