Reports2017-11-18T12:27:27+00:00

JTF Grid Datasources

Description
Categories: Application, Enginatics, Setup
JTF grid (CRM spreadtable) datasource and column definition

select
jgdv.grid_datasource_name datasource_name,
jgdv.title_text title,
jgdv.db_view_name view_name,
jgcv.grid_col_alias column_alias,
jgcv.db_col_name view_column,
xxen_util.meaning(jgcv.data_type_code,'COLUMN_TYPE',0) data_type,
jgcv.query_seq query_sequence,
xxen_util.meaning(jgcv.sortable_flag,'WSH_DEBUG_ENABLED',665) sortable,
jgcv.label_text label,
jgcv.display_seq display_sequence,
jgcv.display_hsize display_width,
xxen_util.meaning(jgcv.display_type_code,'JTF_DISPLAY_TYPE',0) display_type
from
jtf_grid_datasources_vl jgdv,
jtf_grid_cols_vl jgcv
where
1=1 and
jgdv.grid_datasource_name=jgcv.grid_datasource_name
order by
jgdv.grid_datasource_name,
jgcv.query_seq

Parameter Name SQL text Validation
Datasource Name
jgdv.grid_datasource_name=:datasource_name
LOV

By continuing to use the site, you agree to the use of cookies. Accept