Mapped List Columns/Controls

As the chineese saying go "Ink is better than the best memory", documentation is key to success for any project.

UIS,LLD, HLD are generally part of Document deliverables. We will not discuss these specs here rather this blog will focus more on getting extract from siebel tools for future reference.

This tip may be useful for LLD spec. For most of the objects siebel gives direct export from tools. But consider a scenario when you want export of columns/controls which are mapped to applets. Direct export from list Columns or controls will give you all columns available in the applet and not the mapped one. An export from applet Web Template item will only give columns which are mapped but not the other desired properties like pickapplet or mvg applet.

Following SQL will help to extract list columns which are mapped to list applet in edit list mode. Anybody can change the name of Applet in the query for which columns need to be extracted.

select

D.NAME,

D.AVAILABLE_FLG,

D.DISPLAYFORMAT,

D.FIELD_NAME,

D.HTML_TYPE,

D.MVG_APPLET_NAME,

D.PICK_APPLET_NAME,

D.CHECKBITMAP,

D.COMMENTS,

D.READONLY,

D.RUNTIME_FLG,

D.VISIBLE

From

siebel.S_APPL_WTMPL_IT A,

siebel.S_APPL_WEB_TMPL B,

siebel.S_APPLET C,

siebel.S_LIST_COLUMN D,

siebel.S_LIST E

where

A.APPL_WEB_TMPL_ID = B.ROW_ID AND

B.APPLET_ID = C.ROW_ID AND

D.NAME = A.CTRL_NAME AND

E.ROW_ID = D.LIST_ID AND

E.APPLET_ID = B.APPLET_ID AND

C.NAME = 'Employee List Applet' AND -- Applet name

B.NAME= 'Edit List'; -- Base or Edit List Mode

OUTPUT TO employee_List_Column.csv

Following SQL will help to extract Controls which are mapped to Form Applet in edit mode. Applet name can be changed in order get desired output.

select

D.NAME,

D.FIELD_NAME,

D.HTML_TYPE,

D.MVG_APPLET_NAME,

D.PICK_APPLET_NAME,

D.COMMENTS,

D.READONLY,

D.RUNTIME_FLG

From

siebel.S_APPL_WTMPL_IT A,

siebel.S_APPL_WEB_TMPL B,

siebel.S_APPLET C,

siebel.S_CONTROL D,

where

A.APPL_WEB_TMPL_ID = B.ROW_ID AND

B.APPLET_ID = C.ROW_ID AND

D.NAME = A.CTRL_NAME AND

D.APPLET_ID = B.APPLET_ID AND

C.NAME = 'Case Form Applet' AND -- Applet name for which extract is required

B.NAME= 'Edit'; -- Edit Mode

OUTPUT TO Case_control.csv

This sql should be run on local databse using dbisql utility and could be fine tuned for columns which are desired in UIS.

Ink is truly, better than the best memory.