private void selectComprehensiveColumns(SQLStringBuilder queryString) { string[] columns = {"ld.learnerNumber", "ld.Name", "ld.Surname", "ld.id", "DATE(e.theRegDate)", "ld.learnerStatus", "d.divisionName as Division", "ld.division as divisionAbrev"}; queryString.Select(columns); queryString.From("learner_Details ld"); }
private void selectCondensedColumns(SQLStringBuilder queryString) { string[] columns = { "ld.Division", "COUNT(ld.learnerKey)", "ld.learnerStatus" }; queryString.Select(columns); queryString.From("learner_Details ld"); }
private void includeRegDate(SQLStringBuilder queryString, bool filterByDate) { var subQuery = new SQLStringBuilder(); subQuery.Scope("Registration Dates", () => { string[] subColumns = { "learnerKey", "MIN(regDate) as theRegDate" }; subQuery.Select(subColumns); subQuery.From("enrollments"); subQuery.GroupBy("learnerKey"); if (filterByDate) { filterHavingByDate(subQuery); } }); if (filterByDate) { queryString.RightJoin(String.Format("{0} as e", subQuery.ToString()), "e.LearnerKey = ld.LearnerKey"); } else { queryString.LeftJoin(String.Format("{0} as e", subQuery.ToString()), "e.LearnerKey = ld.LearnerKey"); } }