related to bug 34766: fixed view for Oracle
authorAsier Lostalé <asier.lostale@openbravo.com>
Mon, 19 Dec 2016 15:16:13 +0100
changeset 30992 d7eecb18eb32
parent 30991 c96d31582199
child 30993 7027d3669e56
related to bug 34766: fixed view for Oracle
src-db/database/model/views/AD_AUDIT_TRAIL_V.xml
--- a/src-db/database/model/views/AD_AUDIT_TRAIL_V.xml	Mon Dec 19 13:37:47 2016 +0000
+++ b/src-db/database/model/views/AD_AUDIT_TRAIL_V.xml	Mon Dec 19 15:16:13 2016 +0100
@@ -1,4 +1,4 @@
 <?xml version="1.0"?>
   <database name="VIEW AD_AUDIT_TRAIL_V">
-    <view name="AD_AUDIT_TRAIL_V"><![CDATA[SELECT at.ad_audit_trail_id, at.ad_client_id, at.ad_org_id, at.isactive, at.created, at.createdby, at.updated, at.updatedby, at.ad_table_id, at.record_id, at.record_revision, at.ad_user_id, at.event_time, at.processtype, at.process_id, at.action, at.ad_column_id, at.old_char, at.new_char, at.old_nchar, at.new_nchar, at.old_number, at.new_number, at.old_date, at.new_date, at.old_text, at.new_text, CASE WHEN at.processtype = 'P' THEN (SELECT to_char(p.name) AS to_char FROM ad_process p WHERE p.ad_process_id = at.process_id) WHEN at.processtype = 'W' THEN (SELECT to_char(w.name) AS to_char FROM ad_tab t, ad_window w WHERE t.ad_tab_id = at.process_id AND t.ad_window_id = w.ad_window_id) WHEN at.processtype = 'X' THEN (SELECT to_char(f.name) AS to_char FROM ad_form f WHERE f.ad_form_id = at.process_id) ELSE COALESCE((SELECT ad_message.msgtext FROM ad_message WHERE ad_message.value = at.process_id), at.process_id) END AS process_desc, COALESCE(at.old_char, to_char(at.old_nchar), to_char(at.old_date), to_char(at.old_number), CASE WHEN ad_get_rdbms() = 'ORACLE' THEN CASE WHEN length(at.old_text) > 3996 THEN (to_char(substr(at.old_text, 1, 3996)) || '...') ELSE to_char(at.old_text) END ELSE to_char(at.old_text) END) AS old_value, COALESCE(at.new_char, to_char(at.new_nchar), to_char(at.new_date), to_char(at.new_number), CASE WHEN ad_get_rdbms() = 'ORACLE' THEN CASE WHEN length(at.new_text) > 3996 THEN (to_char(substr(at.new_text, 1, 3996)) || '...') ELSE to_char(at.new_text) END ELSE to_char(at.new_text) END) AS new_value FROM ad_audit_trail at]]></view>
+    <view name="AD_AUDIT_TRAIL_V"><![CDATA[SELECT at.ad_audit_trail_id, at.ad_client_id, at.ad_org_id, at.isactive, at.created, at.createdby, at.updated, at.updatedby, at.ad_table_id, at.record_id, at.record_revision, at.ad_user_id, at.event_time, at.processtype, at.process_id, at.action, at.ad_column_id, at.old_char, at.new_char, at.old_nchar, at.new_nchar, at.old_number, at.new_number, at.old_date, at.new_date, at.old_text, at.new_text, CASE WHEN at.processtype = 'P' THEN (SELECT to_char(p.name) AS to_char FROM ad_process p WHERE p.ad_process_id = at.process_id) WHEN at.processtype = 'W' THEN (SELECT to_char(w.name) AS to_char FROM ad_tab t, ad_window w WHERE t.ad_tab_id = at.process_id AND t.ad_window_id = w.ad_window_id) WHEN at.processtype = 'X' THEN (SELECT to_char(f.name) AS to_char FROM ad_form f WHERE f.ad_form_id = at.process_id) ELSE COALESCE((SELECT to_char(ad_message.msgtext) FROM ad_message WHERE ad_message.value = at.process_id), at.process_id) END AS process_desc, COALESCE(at.old_char, to_char(at.old_nchar), to_char(at.old_date), to_char(at.old_number), CASE WHEN ad_get_rdbms() = 'ORACLE' THEN CASE WHEN length(at.old_text) > 3996 THEN (to_char(substr(at.old_text, 1, 3996)) || '...') ELSE to_char(at.old_text) END ELSE to_char(at.old_text) END) AS old_value, COALESCE(at.new_char, to_char(at.new_nchar), to_char(at.new_date), to_char(at.new_number), CASE WHEN ad_get_rdbms() = 'ORACLE' THEN CASE WHEN length(at.new_text) > 3996 THEN (to_char(substr(at.new_text, 1, 3996)) || '...') ELSE to_char(at.new_text) END ELSE to_char(at.new_text) END) AS new_value FROM ad_audit_trail at]]></view>
   </database>