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

No hay comentarios:

Publicar un comentario