SELECT Examples
Find Window for Table Name
select * from ad_table_windows_v where tablename='C_ValidCombination';
Window including tabs, fields and Web UI Config
SELECT
w.name as window_name,
t.name as tab_name,
f.name as field_name,
uis.name as ui_section_name,
uic.seqno as ui_column,
uig.name as ui_group_name,
uie.name,
uie.isdisplayed,
uie.isdisplayedgrid,
uie.isactive
FROM ad_window w
JOIN ad_tab t ON t.ad_window_id = w.ad_window_id
JOIN ad_field f ON f.ad_tab_id = t.ad_tab_id
JOIN ad_ui_section uis ON uis.ad_tab_id = t.ad_tab_id
JOIN ad_ui_column uic ON uic.ad_ui_section_id = uis.ad_ui_section_id
JOIN ad_ui_elementgroup uig ON uig.ad_ui_column_id = uic.ad_ui_column_id
JOIN ad_ui_element uie ON uie.ad_ui_elementgroup_id = uig.ad_ui_elementgroup_id
WHERE w.name = 'Geschäftspartner'
ORDER BY w.name
Window including above plus AD table and AD Column
SELECT
w.name as window_name,
t.name as tab_name,
f.name as field_name,
uis.name as ui_section_name,
uic.seqno as ui_column,
uig.name as ui_group_name,
uie.name,
uie.isdisplayed,
uie.isdisplayedgrid,
uie.isactive,
tab.tablename,
c.columnname,
columnsql
FROM ad_window w
JOIN ad_tab t ON t.ad_window_id = w.ad_window_id
JOIN ad_field f ON f.ad_tab_id = t.ad_tab_id
JOIN ad_ui_section uis ON uis.ad_tab_id = t.ad_tab_id
JOIN ad_ui_column uic ON uic.ad_ui_section_id = uis.ad_ui_section_id
JOIN ad_ui_elementgroup uig ON uig.ad_ui_column_id = uic.ad_ui_column_id
JOIN ad_ui_element uie ON uie.ad_ui_elementgroup_id = uig.ad_ui_elementgroup_id and uie.ad_field_id = f.ad_field_id
JOIN ad_table tab on tab.ad_table_id = t.ad_table_id
JOIN ad_column c on f.ad_column_id = c.ad_column_id
WHERE f.name = 'Produktionsauftrag'
ORDER BY w.name
Find Table and Column by Field Name and Window ID
SELECT
w.name as window_name,
f.name as field_name,
tab.tablename,
c.columnname,
columnsql
FROM ad_window w
JOIN ad_tab t ON t.ad_window_id = w.ad_window_id
JOIN ad_field f ON f.ad_tab_id = t.ad_tab_id
JOIN ad_table tab on tab.ad_table_id = t.ad_table_id
JOIN ad_column c on f.ad_column_id = c.ad_column_id
WHERE true
and f.name='Anrede (ID)'
and w.ad_window_id=<Window ID>
ORDER BY w.name
Find Window ID and Name by Table Name
-- Table Name => Find Window Name and ID
SELECT DISTINCT
w.name as window_name,
w.ad_window_id,
t.name as tab_name
FROM ad_window w
JOIN ad_tab t ON t.ad_window_id = w.ad_window_id
join ad_table adt on t.ad_table_id = adt.ad_table_id
JOIN ad_field f ON f.ad_tab_id = t.ad_tab_id
JOIN ad_ui_section uis ON uis.ad_tab_id = t.ad_tab_id
JOIN ad_ui_column uic ON uic.ad_ui_section_id = uis.ad_ui_section_id
JOIN ad_ui_elementgroup uig ON uig.ad_ui_column_id = uic.ad_ui_column_id
JOIN ad_ui_element uie ON uie.ad_ui_elementgroup_id = uig.ad_ui_elementgroup_id
WHERE adt.tablename ilike '%c_vat_code%'
ORDER BY w.name
View source file on GitHub.com