lunes, 23 de julio de 2018
Field Translations in iDempiere
SQL Query:
select
w.ad_window_id as id_ventana,
wt."name" as ventana,
tb.ad_tab_id as id_pestania,
tt."name" as pestania,
f.seqno as secuencia,
f.name as campo,
c.columnname as columna,
ft."name" as traduccion,
case f.isactive
when 'Y' then 'ACTIVO'
when 'N' then 'INACTIVO'
end as estado
from ad_table as t
join ad_tab as tb
on t.ad_table_id = tb.ad_table_id
join ad_tab_trl as tt
on (tb.ad_tab_id = tt.ad_tab_id
and tt.ad_language = 'es_NI')
join ad_window as w
on tb.ad_window_id = w.ad_window_id
join ad_window_trl as wt
on (wt.ad_window_id = w.ad_window_id
and wt.ad_language = 'es_NI')
join ad_field as f
on tb.ad_tab_id = f.ad_tab_id
join ad_field_trl as ft
on (f.ad_field_id = ft.ad_field_id
and ft.ad_language = 'es_NI')
join ad_column as c
on f.ad_column_id = c.ad_column_id
where wt.ad_window_id = $P{p_id_window}
and tt.ad_tab_id = $P{p_id_tab}
order by
wt."name",
tb.seqno,
f.seqno
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario