<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">@vibanu … No… your reasoning is sound. I would not change the db model you have. Try using the crosstab views module as I suggested earlier. Or if you are
comfortable with SQL give Forena a try: http://drupal.org/project/forena (shameless plug).
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">IMHO, You have the right data structure… most flexible and most sustainable.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Dave<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> support-bounces@drupal.org [mailto:support-bounces@drupal.org]
<b>On Behalf Of </b>Warren Vail<br>
<b>Sent:</b> Thursday, January 16, 2014 10:37 AM<br>
<b>To:</b> support@drupal.org<br>
<b>Subject:</b> Re: [support] how to show a view in a table format<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Not sure what the best answer would be here, in DB terms, you are trying to establish a many to many match, a course can be active during many semesters and a semester can have many courses in it. In the form you showed me the student
selects (or it's selected for him, based on the upcoming semester) a series of 5 semesters, and courses appearing in any of those 5 semesters are shown. That was the reason I had suggested flattening one of the dimensions of the match bo coding each of the
5 semesters as a separate column, and you are correct, you do wind up with redundant columns for as long as you keep the hidden columns, but implementing it in Drupal is simpler IMO. for example; flattening the joins results in a simple test to see if any
columns are checked (of the current 5 semesters) to decide whether who list the course, not listing courses that are not checked in any of the current 5 semester columns. Right or wrong that is the approach I would take.<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Jan 15, 2014 at 6:34 PM, vibanu <<a href="mailto:vibanu@gmail.com" target="_blank">vibanu@gmail.com</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We added semester as taxtonomy term with values Spring 2013, Fall 2013 and Spring 2014 for now to test this. Created a view of table format. We were thinking of showing a filter of semester for students to pick from and show one semester
at a time. However, this also did not work because I could only see the courses that were offered. I was unable to list all courses with offered YES or NO next to it.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">On adding new field each semester, we will end up with so many redundant fields in this so called 'courses' content type. Is this a suggested practice?<o:p></o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal">On Wed, Jan 15, 2014 at 2:09 PM, Warren Vail <<a href="mailto:warren@vailtech.net" target="_blank">warren@vailtech.net</a>> wrote:<o:p></o:p></p>
<div>
<p class="MsoNormal">It's easy to get tangled up in the details with Drupal, Datatables has a good interface with views, and hiding old columns, while not automatic, is simple. I would add a single checkbox for each semester as a separate column and hide the
old ones from displaying in the view, adding new columns each year or semester. Displaying the checkbox (checked or not) would do the trick. You might like the search box with datatables, it produces a very responsive filter that works with each character
you type, and your table is not so large that response issues will show up. You will need to play with CSS for styling, but nothing major as long as you don't mind manually hiding columns from time to time.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">On Tue, Jan 14, 2014 at 10:59 AM, vibanu <<a href="mailto:vibanu@gmail.com" target="_blank">vibanu@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<div>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We would like to replicate the following page into DRUPAL<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.cs.stonybrook.edu/students/undergrad/CSEcourses.html" target="_blank">http://www.cs.stonybrook.edu/students/undergrad/CSEcourses.html</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We have content type of courses. We are struggling to find a solution on how or the best way to show the 4 semesters.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Any ideas are appreciated.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, Jan 14, 2014 at 1:59 PM, vibanu <<a href="mailto:vibanu@gmail.com" target="_blank">vibanu@gmail.com</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We would like to replicate the following page into DRUPAL<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.cs.stonybrook.edu/students/undergrad/CSEcourses.html" target="_blank">http://www.cs.stonybrook.edu/students/undergrad/CSEcourses.html</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We have content type of courses. We are struggling to find a solution on how or the best way to show the 4 semesters.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Any ideas are appreciated.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance.<o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>