??changed: - -- Show all new items posted by user #65804 - mysql> SELECT * FROM bugs WHERE submitted_by='65804' - UNION SELECT * FROM task WHERE submitted_by='65804' - UNION SELECT * FROM patch WHERE submitted_by='65804' - UNION SELECT * FROM support WHERE submitted_by='65804'; - - -- Show all follow-ups posted by user #65804 - mysql> SELECT * FROM bugs_history WHERE mod_by='65804' AND field_name='details' - UNION SELECT * FROM task_history WHERE mod_by='65804' AND field_name='details' - UNION SELECT * FROM patch_history WHERE mod_by='65804' AND field_name='details' - UNION SELECT * FROM support_history WHERE mod_by='65804' AND field_name='details'; -- Show all content posted by user #67738 mysql> SELECT "bugs_p", summary,details FROM bugs WHERE submitted_by=67738 UNION SELECT "support_p",summary,details FROM support WHERE submitted_by=67738 UNION SELECT "task_p", summary,details FROM task WHERE submitted_by=67738 UNION SELECT "patch_p", summary,details FROM patch WHERE submitted_by=67738 UNION SELECT "bugs_c", field_name,old_value FROM bugs_history WHERE mod_by=67738 AND field_name='details' UNION SELECT "support_c",field_name,old_value FROM support_history WHERE mod_by=67738 AND field_name='details' UNION SELECT "task_c", field_name,old_value FROM task_history WHERE mod_by=67738 AND field_name='details' UNION SELECT "patch_c", field_name,old_value FROM patch_history WHERE mod_by=67738 AND field_name='details' UNION SELECT "forum",subject,body FROM forum WHERE posted_by=67738;
-- forwarded from https://savannah.gnu.org/maintenance/savanetasks#msg20090730152906+0...@https://savannah.gnu.org/maintenance _______________________________________________ Savannah-cvs mailing list [email protected] http://lists.gnu.org/mailman/listinfo/savannah-cvs
