- 1. MySQL: Display Users and Duration in Matrix Timesheet
- / MySQL /
- ... NOT IN ('expired','guest','test account') AND u.TeamID='$t_value' ORDER BY CONCAT(u.FirstName, ' ', u.LastName) "; Activity Query $w_value = $number_of_weeks_from_now; // usually 0 for ...
- Created on 27 April 2012
- 2. MySQL parameters in Excel 2007 PivotTables
- / MySQL /
- ... Users u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, ...
- Created on 24 August 2011