Changes between Version 19 and Version 20 of verfahrenUmstellung

Timestamp:

May 2, 2007, 3:06:08 PM (17 years ago)

Author:

casties

Comment:

--

verfahrenUmstellung

@@ -69 +69 @@
  FROM personal_www;
 }}}
+
+Liste mit current_work:
+
+{{{
+CREATE OR REPLACE VIEW personal_www_list AS 
+ SELECT personal_www.last_name, personal_www.first_name, personal_www.status, personal_www.e_mail, personal_www.telefon, personal_www.fax, personal_www.department, personal_www.id, personal_www.e_mail_p, personal_www.telefon_p, personal_www.fax_p, personal_www.cv, personal_www.awards, personal_www.image, personal_www.title, personal_www.date_stay_at_mpiwg, personal_www.home_inst, personal_www.private_homepage, personal_www.publish_the_data, personal_www.date_from, personal_www.date_to, personal_www.date_special_text, personal_www.funded_by, personal_www.e_mail2, personal_www.id_zahl, personal_www.room_no, personal_www.e_mail2_p, personal_www."key", personal_www.web_object_created, personal_www."group", 
+        CASE
+            WHEN personal_www."group" = 'Wissenschaftler'::text OR personal_www."group" = 'wissenschaftliche Gäste'::text OR personal_www."group" = 'Stipendiaten'::text THEN 'yes'::text
+            ELSE 'no'::text
+        END AS is_scholar, ( SELECT current_work.current
+           FROM current_work
+          WHERE current_work.key_main = personal_www."key" AND current_work.publish = 'yes'::text
+          ORDER BY current_work.priority
+         LIMIT 1) AS current_work
+   FROM personal_www;
+}}}