Configuring Siebel Business Applications > Configuring Applets > Customizing Applet Buttons, Controls and List Columns >

Identifying the Controls and List Columns That Siebel CRM Displays in the Siebel Client

To identify the controls and list columns that Siebel CRM displays in the Siebel client, you can run a query that is similar to SQL. This technique can be useful to determine the combination of columns and values that are required for the applet and web template. For example, an applet might include 30 fields and the applet web template item might include 28 fields, but only 19 fields are visible in the Siebel client.

To identify the controls and list columns that Siebel CRM displays in the Siebel client

• Run the following query against the Siebel database on the Siebel Server:

  SELECT a.NAME, wtmit.*

  FROM siebel.s_list_column a,

  siebel.s_applet b,

  siebel.s_list c,

  siebel.s_appl_web_tmpl wtmp,

  siebel.s_appl_wtmpl_it wtmit

  WHERE b.NAME IN ('Contact List Applet')

  AND c.applet_id = b.row_id

  AND c.row_id = a.list_id

  AND wtmp.applet_id = b.row_id

  AND wtmit.appl_web_tmpl_id = wtmp.row_id

  --and a.name in ('M/M','Birth Date','Suffix','Account','Postal Code'