Investeam

sin parametro: rolo ad client
esta es la plantilla para el importador que hicimos de roles

select
win.ad_window_id as ventana_id,
tradwin.name as ventana,
tab.ad_tab_id,
tradtab.name as pestaña,
camp.ad_field_id,
tradcamp.name as campo,
camp.IsReadOnly as sololectura,
TabLevel as nivelpestaña,
tab.SeqNo as ordenpestaña,
'' AS rol1,
'' as rol2,
'' as rol3,
'' as rol4,
'' as rol5
from AD_Window win
inner join AD_Window_Trl tradwin on tradwin.AD_Window_id = win.AD_Window_id and tradwin.AD_Language='es_EC'
inner join AD_tab tab on tab.AD_Window_id = win.AD_Window_id and tab.isactive = 'Y'
inner join AD_Tab_Trl tradtab on tradtab.ad_tab_id = tab.ad_tab_id and tradtab.AD_Language='es_EC'
inner join AD_Field camp on camp.AD_Tab_id = tab.AD_tab_id and camp.isactive = 'Y' and camp.IsDisplayed = 'Y'
inner join AD_Field_Trl tradcamp on tradcamp.AD_Field_id = camp.AD_Field_id and tradcamp.AD_Language='es_EC'
order by win.name, tab.tablevel, tab.SeqNo, camp.SeqNo