[Savannah-cvs] [SavaneTasks] (edit) single query to check all stuff posted by a user

[Beuc]

??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/address@hidden://savannah.gnu.org/maintenance