Hi, I have created a flat table from my DB and defined a solr core on it. It works excellent so far.
My problem is that my table has two hierarchies. So when flatted it is too big. Lets consider the following example scenario My Tables are School Students (1:n with school) Teachers(1:n with school) Now, each school has many students and teachers but each student/teacher has another multivalue field. i.e. the following table studentHobbies - 1:N with students teacherCourses - 1:N with teachers My main Entity is School and that what I want to get in the result. Flattening does not help me much and is very expensive. Can you direct me to how I define 1:n relationships ( and 1:n:n) In data-config.xml Thanks.
