Pop up different applets from the same control based on condition

Steps to configure:

1. The Control should be created with the following details:
Method Invoked: ShowPopup
HTML Type: MiniButton

2. The control should be added to the Applet Web Layout.

3. In WebApplet_PreCanInvokeMethod of the Applet Server Script, CanInvoke should be set to 'TRUE' and return (CancelOperation) should be mentioned.

4. In the Applet User Property a new record with the following details should be created :
Name: Named Method: ShowPopup
Value: 'INVOKE', 'ShowPopup', 'IIF([Field Name] = "Value","Popup Applet A","Popup Applet B")', 'Edit List'

If the value of the field given in the Field Name matches with the value given in Value then the Popup Applet A will get invoked, otherwise Popup Applet B will get invoked. Both Popup Applets will get invoked in the Edit List mode.

How to To make a field read-only in smartscripts

From the application-level menu, Navigate to > Site Map > Administration - SmartScript > Scripts.
In the Scripts list, query to find the SmartScript you want to modify.
Click the Programs view tab.
From the Programs list, select Script_Open.
In the Program Language field, select eScript, and then click Save.
In the eScript form, use the script function SetQuestionEnable(false) to set the question to read-only. Verify that each read-only field has a SetQuestionEnable(false) statement attached to it.

How to set more than 500 values in static picklist?

In Tools, at the business component called Picklist Generic, you will notice that it has a property called Prefetch Size, which is by default set to 500.

There is also a related property called Maximum Cursor Size, which should be set to the same value as Prefetch Size.If you change these values, you will be able to change the number of values displayed in the picklist.

Exposing more List Columns in List Applets

Requirement : Requirement is to expose more List Columns in the List applet.


Solution  : For exposing more List columns in List applet we have to change the “count” property in the “For” loop of the CCListBody.swt and CCListHeader.swt files. We can add any number of List columns in List applet. But for performance and usability reasons, a maximum of 40 list columns should bound to a list applet web template.

SQL Error Creating Table to Verify Previleges

Hi Friends,

During development when you are connected to your Local Database, you might need to test out any schema changes to a Table or Column.
In order to achieve this, you will be needing to apply the logical changes from Tools to your Local Database.

While doing so, you need to give Privileged Database User & Password to make changes to your Local DB Schema.
If you use your Tools login username & password; you would be greeted with this two errors:

First Error:
SQL Error Creating table Dummy Table to Verify Privileges


Second Error:
42000 (-121): [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Permission denied: you do not have permission to use the "CREATE TABLE" statement


To avoid above errors, you need to change the Privileged User & Password being supplied before applying the change:

Siebel Application User Id User Password
Prior to Version 7.7 DBA SQL
Version 7.7 SIEBEL Local
Version 8.0 SIEBEL Local

Here, Local means to use your own Local User Password.
i.e. Say if you use dummyuser/dummypassword to login to your Local Tools, then you need to use SIEBEL/dummypassword as your Privileged User Id & Privileged User Password for making schema changes to your Local DB.