z.B.
Nextcloud Deck - Daten
- in Suchergebnissen
- oder in Office-Berichte
- ...
einbinden.
--> /ainfojs2000/InfoPrint_Default?only_REPORT_KNZ=TxtDoc&search_text=IT%25Dokumentation
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
;
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
;
- 1 - (TxtDoc-nextcloud-daten-sql-office2026-10-16.html)
