Beschreibung
Bemerkung

---

Support Hist Plan

OK abbrechen

Material Stunden Wiederholung

OK abbrechen

	z.B. Nextcloud Deck - Daten - in Suchergebnissen - oder in Office-Berichte - ... einbinden.
	...
	...

z.B. Nextcloud Deck SQL: ---- create view ocl_dec_car_raw as SELECT boa.id as boa_id, boa.title as boa_title, boa.deleted_at as boa_deleted_at, sta.id as sta_id, sta.title as sta_title, -- car.id as car_id, car.title as car_title, car.description as car_description, car.owner as car_owner, car.startdate as car_startdate, car.duedate as car_duedate, car.done as car_done, car.last_editor as car_last_editor, car.last_modified as car_last_modified, -- ( TIMESTAMP WITHOUT TIME ZONE 'epoch' + car.created_at * INTERVAL '1 second' ) as car_created_at_as_ts, ( TIMESTAMP WITHOUT TIME ZONE 'epoch' + car.last_modified * INTERVAL '1 second' ) as car_last_modified_as_ts, -- car_use.use_participants, -- car_lab.area_lab_titles, car_lab.psta_lab_titles, car_lab.max_car_done, car_lab.sum_car_archived_raw, car_lab.wsta_lab_titles -- FROM oc_deck_boards boa LEFT OUTER JOIN oc_deck_stacks sta on boa.id = sta.board_id LEFT OUTER JOIN oc_deck_cards car on sta.id = car.stack_id LEFT OUTER JOIN ocl_dec_app.ocl_dec_car_use_qry car_use on car.id = car_use.car_id LEFT OUTER JOIN ocl_dec_app.ocl_dec_car_lab_qry car_lab on car.id = car_lab.car_id -- WHERE boa.deleted_at = 0 -- ORDER BY boa.id, sta.id, car.id ;

z.B. Nextcloud Tabellen SQL: ---- create view ocl_tab_val_raw_raw as SELECT tab.id as tab_id, tab.title as tab_title, tab_sle.id as sle_id, tab_sle.created_by as sle_created_by, tab_sle.created_at as sle_created_at, tab_col.id as col_id, tab_col.title as col_title, tab_col.technical_name as col_name, -- tab_cel_rel.row_id as rel_row_id, tab_cel_rel.value as rel_value, tab_cel_tex.row_id as tex_row_id, tab_cel_tex.value as tex_value, tab_cel_num.row_id as num_row_id, tab_cel_num.value as num_value, tab_cel_dat.row_id as dat_row_id, tab_cel_dat.value as dat_value, tab_cel_sel.row_id as sel_row_id, tab_cel_sel.value as sel_value -- FROM oc_tables_tables tab LEFT OUTER JOIN oc_tables_row_sleeves tab_sle ON tab.id = tab_sle.table_id LEFT OUTER JOIN oc_tables_columns tab_col ON tab.id = tab_col.table_id LEFT OUTER JOIN oc_tables_row_cells_relation tab_cel_rel on tab_sle.id = tab_cel_rel.row_id and tab_col.id = tab_cel_rel.column_id LEFT OUTER JOIN oc_tables_row_cells_text tab_cel_tex on tab_sle.id = tab_cel_tex.row_id and tab_col.id = tab_cel_tex.column_id LEFT OUTER JOIN oc_tables_row_cells_number tab_cel_num on tab_sle.id = tab_cel_num.row_id and tab_col.id = tab_cel_num.column_id LEFT OUTER JOIN oc_tables_row_cells_datetime tab_cel_dat on tab_sle.id = tab_cel_dat.row_id and tab_col.id = tab_cel_dat.column_id LEFT OUTER JOIN oc_tables_row_cells_selection tab_cel_sel on tab_sle.id = tab_cel_sel.row_id and tab_col.id = tab_cel_sel.column_id -- ORDER BY 1, 2, 3 ;