Contents

• Title and Copyright Information
• Preface

1 What’s New in This Release

• What’s New in Siebel Developer’s Reference, Siebel CRM 20.1 Update
• What’s New in Siebel Developer’s Reference, Siebel CRM 19.1 Update

2 Overview for Using This Book

• Overview for Using This Book
• How This Book Describes Objects
  • How This Book Describes Relationships Between Objects
• Getting Help From Oracle

3 Applet Classes

• Applet Classes
• Overview of Applet Classes
  • Using SWE Classes Starting with Siebel CRM Version 7.x
• CSSSWEFrame Class
• CSSSWEFrameBase Class
• CSSSWEFrameList Classes
• CSSSWEFrameListBase Class
• CSSSWEFrameListFile Class
• CSSSWEFrameListDocGen Class
• CSSSWEFrameListWeb Class
• CSSSWEFrameSalutation Class
• CSSSWEFrameContactOrgChart Class
• CSSSWEFrameListFINApplication Class
• CSSSWEFrameUserRegistration Class

4 Business Component Classes

• Business Component Classes
• Overview of Business Component Classes
  • Generalized and Specialized Business Component Classes
    • Generalized Business Component Classes
    • Using Specialized Classes
  • Guidelines for Using Methods in Business Component Classes
  • Calling a Method
• CSSBusComp Class
• CSSBCBase Class
  • User Properties That Can Reference the CSSBCBase Class
  • Methods That the CSSBCBase Class Can Reference
    • Evaluate Boolean Expression Method
    • Evaluate Expression Method
    • Is Active Method
    • Refresh Business Component Method
    • Refresh Record Method
    • Revise Method
    • Sequence Method
    • Set Aspect Method
• CSSBCAccountSIS Class
  • Dependencies and Limitations for the CSSBCAccountSIS Class
  • Business Component User Properties That Can Reference the CSSBCAccountSIS Class
• CSSBCActivity Class
  • Dependencies and Limitations for the CSSBCActivity Class
    • Fields That the CSSBCActivity Class Requires
    • Date Fields That the CSSBCActivity Class Requires
    • How an Applet Class Determines Whether or Not the CSSBCActivity Class Is Required
  • Business Component User Properties That Can Reference the CSSBCActivity Class
  • Methods That the CSSBCActivity Class Can Reference
    • Clear Grid Begin End Date Method
    • Complete Activity Method
    • Is Primary In MVG Method
    • Set Employee Id Method
    • Set Grid Begin End Date Method
• CSSBCActivityPlan Class
• CSSBCContactSIS Class
  • User Properties and Methods That You Can Use with the CSSBCContactSIS Class
    • User Properties That Can Reference the CSSBCContactSIS Class
    • Methods That the CSSBCContactSIS Class Can Reference
• CSSBCFile Class
  • Dependencies and Limitations for the CSSBCFile Class
  • Methods That the CSSBCFileClass Can Reference
    • Create File Method
    • Delete File Method
    • Get File Method
    • Put File Method
    • Update Src From Link Method
• CSSBCFINOppty Class
  • User Properties and Methods That You Can Use with the CSSBCFINOppty Class
    • Business Component User Properties That Can Reference The CSSBCFINOppty Class
    • Methods That the CSSBCFINOppty Class Can Reference
• CSSBCFINSActivity Class
• CSSBCForecast Class
  • Dependencies and Limitations for Forecast Classes
  • Business Component User Properties That Can Reference the CSSBCForecast Class
  • Methods That the CSSBCForecastClass Can Reference
    • Forecast Generate Method
    • Rollup Forecast Method
• CSSBCForecastBase Class
  • Methods That the CSSBCForecastBase Class Can Reference
• CSSBCForecastItem Class
• CSSBCForecastItemDetail Class
  • Methods That the CSSBCForecastItemDetail Class Can Reference
• CSSBCFundReq Class
• CSSBCOppty Class
• CSSBCOrderMgmtQuoteItem Class
• CSSBCPharmaSpecializedAct Class
• CSSBCPosition Class
  • Methods That the CSSBCPosition Class Can Reference
• CSSBCProposal Class
  • Methods That the CSSBCProposal Class Can Reference
• CSSBCServiceRequest Class
  • Dependencies and Limitations
• CSSBCTaskTransient Class
• CSSBCTaskTransientBase Class
• CSSBCUser Class
  • Guidelines for Using the CSSBCUser Class

5 User Properties

• User Properties
• Overview of User Properties
  • How This Book Describes the User Property Format
  • Numbering Instances of a User Property
    • Example of Numbering Instances of a User Property
    • Guidelines for Numbering Instances of a User Property
• Alphabetic List of User Properties
• Application User Properties
  • Calling Business Services from the Client
  • Disabling Predefined Queries in Views
  • Disabling the View Cache
• Applet User Properties
  • Calling Methods from Applets
    • Format You Must Use with the Named Method n Applet User Property
    • Calling Methods in a Specific Order
    • Actions That You Can Use with the Named Method n User Property for Applets
  • Disabling Hierarchies in List Applets
  • Disabling Methods for FINS Applets in Query Mode
  • Disabling New Record Creation
  • Enabling Methods for Applets
  • Enabling Record Manipulation in Field Service and Task Views
  • Hiding Applets That Contain No Data
  • Making an Applet Control Required
  • Specifying Gantt Chart Behavior
  • Specifying Template Values for Proposals
  • Specifying Drilldown Visibility
  • Specifying Field Names According to Parent Id
  • Specifying Political Influence in Organization Charts
  • Specifying Post Invoke Methods
  • Specifying Relationships in Organization Charts
  • Specifying the Application That Creates Proposals
  • Specifying the Calendar Visibility Filter
  • Specifying the Default Applet Focus
    • Setting the Default Focus for an Object That Siebel CRM Does Not Display
    • Specifying the Default Applet Focus for Base, Edit, or Edit List Mode
    • Specifying the Default Applet Focus for New Mode
    • Specifying the Default Applet Focus for Query Mode
  • Specifying the Error Web Page for SmartScript
  • Specifying the Finish or Cancel Web Page for SmartScript
  • Specifying the Method That the Enter Key Calls
  • Specifying the Parent Business Component
• Business Service User Properties
  • Specifying the BAPI Adapter Service
  • Specifying the Batch Size for SAP IDOCs
  • Specifying the Time Out Interval for Receive Requests
• Control User Properties
  • Forcing Controls to Be Active
  • Saving Unsaved Data
  • Specifying the Goto URL
  • Specifying the Goto View
  • Specifying the Goto Web Page
• Field User Properties
  • Disabling Search on Text Fields or Unindexed Fields
  • Disabling Sort on Business Component Fields
  • Making a Field Required
  • Setting the Field Text Length
  • Specifying Encryption for Fields
    • Overview of Encryption User Properties
    • Upgrading Encryption
    • Enabling Encryption on a Field
    • Specifying the Field That Contains the Encryption Key
    • Specifying the RC2 or AES Encryption Service
    • Setting an Encrypted Field to Read Only if Encryption Fails
    • Masking Credit Card, Account, and Other Secure Data
    • Specifying the Field That Contains Secure Data
  • Updating Assets
  • Cascading Asset Updates
    • Configuring Siebel CRM to Cascade Asset Updates
  • Specifying the Field That Stores the Account Id of a Contact
  • Specifying the SQL for EXISTS Search Specifications
  • Using Literals Instead of Bind Variables
    • Guidelines for Using Literals Instead of Bind Variables
• Integration Component User Properties
  • Specifying Association Business Components
  • Specifying MVG Business Components
  • Preventing Siebel EAI From Deleting Records
  • Preventing Siebel EAI From Inserting Records
• Integration Component Field User Properties
  • Specifying the Field Name for an MVG
  • Preventing Siebel EAI From Updating Fields
• Integration Object User Properties
  • Specifying the IDOC Message Type for SAP
• List Column User Properties
  • Disabling Sort on List Columns
  • Forcing Fields That a List Column References to be Active
• View User Properties
  • Specifying the Default Applet Focus

6 Business Component User Properties

• Business Component User Properties
• Alphabetic List of Business Component User Properties
• Viewing a Business Component User Property
• Controlling Siebel CRM Data
  • Controlling Accounts
  • Validating Parent Account IDs
  • Specifying the Parent Business Component for Accounts
  • Specifying the Field That Stores Parent Account IDs
  • Specifying the Field That Stores Parent Account IDs for Contacts
  • Specifying the Master Account Field
  • Maintaining the Master Account in Account Hierarchies
  • Controlling Activities
  • Determining Charges for Service Activities
  • Updating the Synchronization Status for Activities
  • Controlling Revenues
  • Specifying Revenue Aggregation Fields
  • Specifying Pop-up Revenues Lists
  • Specifying the Field That Siebel CRM Copies for New Revenue Forecasts
  • Controlling Campaigns
  • Copying Contacts to Campaigns
  • Specifying Group Only Visibility in Campaigns
  • Specifying Group Plus Team Visibility in Campaigns
  • Controlling Forecasts
  • Specifying Client Timeouts for Forecasts
  • Specifying Server Timeouts for Forecasts
  • Specifying Sleep Time Between Forecast Save Attempts
  • Specifying Search Specifications for Forecasts
  • Specifying Search Specifications for Forecast Rollup
  • Specifying Business Components for Forecast Analysis
  • Disallowing Users to Pick Dates in the Forecast Date Dialog Box
  • Allowing Users to Update Closed Service Requests
  • Allowing Users to Update Assets
  • Adding Contacts to the Action Business Component
  • Creating Numbered Revisions of Quotes, Orders, or Agreements
  • Extending Quote Quantities
  • Automatically Assigning Responsibilities to Users
  • Making Sure the Current Employee Holds a Position
  • Setting the Close Out Flag Field
  • Specifying State Models
  • Specifying Assignment Objects
  • Protecting Seed Data
• Controlling Search and Sort
  • Optimizing Sort Searches
  • Removing Duplicate Records From Queries
  • Using Duplicate Elimination with a Denormalized Relationship
  • Overriding Sort Specifications on Business Components
  • Guidelines for Overriding Sort Specifications on Business Components
  • Sorting According to the View Mode That the Business Component Uses
  • Example of Configuring the View Mode Sort User Property
  • Disabling Automatic Trailing Wildcards in Queries
  • Adding Search Criteria to the Query Assistant
  • Saving Query Results in Target Lists
  • Specifying How to Sort Predefined Queries for Opportunities
  • Example of Configuring the Sort Field Map User Property
  • Alternative to Configuring the Sort Field Map User Property
  • Specifying Search Specifications for the Action Business Component
  • Specifying Search Specifications for Nonsales Rep Views
• Controlling Visibility Filters
  • Controlling Global Account Visibility
    • Dynamic Hierarchy Id Field
    • Dynamic Hierarchy Parent Field Id
    • Dynamic Hierarchy Visibility Organization Id Field
    • Dynamic Hierarchy Visibility Position Id Field
  • Controlling My Visibility Filters
  • Controlling Manager Visibility Filters
• Controlling Records
  • Making Records Read-Only According to a Field Value
  • Disabling Modifications to Saved Records
  • Allowing Administrators to Modify Records
    • Requirements for Using Admin Mode
    • Using a Script to Set the Admin Mode
  • Preventing Administrators from Deleting Records
  • Preventing Administrators from Updating Records
  • Calculating Values When Writing Records
  • Specifying Sequential Line Numbers for New Records
  • Specifying Sequential Line Numbers for New Records According to Maximum Values
  • Setting Business Components to Read-Only According to a Field Value
  • Setting Business Components to Read-Only According to a Name
  • Using Literals Instead of Bind Variables When Merging Records
• Controlling Fields
  • Making Fields Active
  • Making Fields Read-Only
  • Disallowing Empty Fields
  • Disabling Field Deletion
  • Setting Field Values According to Conditions
  • Updating Fields When Siebel CRM Updates Other Fields
    • Setting the Value Parameter of On Field Update Set
    • Setting the Condition Parameter of On Field Update Set
    • Guidelines for Updating Fields When Siebel CRM Updates Other Fields
  • Calling Methods When Siebel CRM Updates Fields
  • Setting the Field Created Date to the Saved Date
  • Updating the Planned Field if the Start Date Field Is Modified
  • Overriding the Type for Fields That Users Read from Right-To-Left
  • Setting Default Values for Fields That Use Drop-Down Lists
    • Using Multiple Instances of Picklist Pre Default Field
  • Modifying the Currency That a Field Uses
  • Specifying Field Name Prefixes for File Attachment Business Components
• Controlling Primaries
  • Specifying Who Can Modify Primary Team Members
  • Setting the Primary Sales Rep as the Owner
  • Setting the Current User as the Primary Contact
  • Allowing Only the Primary to Modify Sales Methods for Opportunities
  • Restricting How Siebel CRM Displays Private Activities for Primaries
• Specifying Business Services
  • Calling Business Service Methods from Business Components
  • Specifying Business Service Parameters
  • Specifying External Data Sources for Business Services
  • Specifying Business Services for Virtual Business Components
• Controlling Parent and Child Relationships
  • Copying and Deleting Child and Grandchild Records
    • Using Deep Copy to Copy Records in Child Business Components
    • Using Deep Delete to Delete Records in Child Business Components
    • Specifying the Link for Deep Copy and Delete
  • Updating the Parent Business Component if Siebel CRM Modifies Children
    • Example of Updating the Parent Business Component if Siebel CRM Modifies Children
  • Specifying Recursive Links Between Parent and Child Business Components
    • Naming a Link
  • Enabling Service Request Updates in Child Business Components
    • Enabling Service Request Updates in Child Business Components with Customer Surveys
• Controlling Email
  • Specifying Statuses for Outgoing Email
    • Specifying the Status for In Progress Emails
    • Specifying the Status for Sent Emails
    • Specifying the Status for Unsent Outbound Emails
    • Specifying the Status for Rejected Emails
  • Specifying the Manager That Sends Email
  • Sending Email Packages to Recipients
    • Recipient First Name Field
    • Recipient Last Name Field
    • Recipient Email Address Field
    • Recipient Fax Address Field
    • Recipient Preferred Medium Field
    • Recipient Id Field
  • Responding to Email or Web Offers
    • Response Type Call Back
    • Response Type More Info
    • Response Type Unsubscribe
• Controlling Specific Siebel Business Applications
  • Controlling Siebel Automotive
  • Specifying Opportunity Business Components in Siebel Automotive
    • Specifying Values for New Opportunities in Siebel Automotive
    • Specifying Values for Used Opportunities in Siebel Automotive
    • Specifying Opportunity Sales Steps in Siebel Automotive
    • Specifying the Sales Step Admin in Siebel Automotive
    • Specifying Reassignment in Siebel Automotive
    • Specifying Positions in Siebel Automotive
  • Specifying Activities to Synchronize for Siebel Mobile
  • Specifying Position Join Fields for Siebel Life Sciences
  • Specifying Business Components for Product Selection and Pricing
    • Using the Product Selection and Pricing User Properties
  • Identifying Business Components That Siebel Financial Services Uses
  • Specifying Room Types for Siebel Hospitality
  • Specifying Arrival Dates, Room Blocks, and Function Spaces for Siebel Hospitality
    • Specifying the Arrival Date Field for the Day Number Business Service
    • Specifying the Business Component for the Function Space
    • Specifying the Business Component for the Room Block
  • Enabling Credit Check
  • Specifying the Workflow Process for Credit Check
  • Specifying Credit Card User Properties
    • Credit Card Expired Month
    • Credit Card Expired Year
    • Credit Card Number
    • Credit Card Type
• Doing Other Work
  • Specifying the Application Name
  • Using Aspects to Control Read Only, Insert, and Other Behavior
    • Aspect User Properties for the CSSBCBase Class
    • Aspect User Properties for the CSSSWEFrameBase or CSSSWEFrameListBase Class
  • Specifying the Default Bookmark View
  • Enabling the Dispatch Board
  • Making Sure an Attachment File Exists
  • Enabling the Revise Button According to Conditions
    • Using the Revision Condition User Property
  • Specifying Joins to the S_PARTY Table
    • Numbering Instances of the Inner Join Extension Table User Property
  • Specifying the DB2 Optimization Level for SQL Statements
  • Capturing User Drilldown Behavior
    • Example of Capturing User Drilldown Behavior
    • DrilldownObject User Property
    • Profile Name: attributename User Property
    • Profile Name: attributevalue User Property

7 Siebel Web Engine Tags

• Siebel Web Engine Tags
• About OD Tags
• Applet Tags
  • Applet Tag
  • Applet Layout Tag
  • Control Tag
    • Defining the Property Attribute of the Control Tag
  • Form Applet Layout Tag
  • Master and Detail Applet Tags
    • Example of Using Master and Detail Applet Tags
    • Iterate Child Applets Tag
    • Child Applet Tag
  • Select Row Tag
    • Using the Select Row Tag
    • How the Select Row Tag Positions the Current Record
    • How the HTML Client Framework Chooses Records
• Form and Web Page Tags
  • Form Tag
  • Web Page Item Tag
• Frame Tags
  • Frame Tag
  • Frameset Tag
• Navigation Control Tag
  • First-Level Navigation Example
  • Second-Level Navigation Example
  • Third-Level Navigation Example
  • Support for the Navigation Control Tag Across Siebel CRM Versions
• Program Logic Tags
  • Error Tag
  • JavaScript Tag
  • If Tag
  • Iterate Tag
  • Iterate Rows Tag
  • Switch, Case, and Default Tags
• Referential Tags
  • Include Tag
  • Map Siebel Object to OD Tag
    • Example of Mapping Siebel Objects to OD
  • This Tag
  • This Id Tag
  • This Table Id Tag
• Threadbar Tags
  • About Threadbar Behavior
  • For Each Thread Tag
  • Thread Separator Tag
  • Thread Link Tag
  • About Link Navigation
  • Example of Using the Threadbar Tags
• Togglebar Tags
  • For Each Toggle Tag
  • Toggle Bar Tag
  • Toggle Link Tag
  • Toggle Name Tag
  • Examples of Using the Togglebar Tags
• Toolbar Tags
  • Configuring an HTML or Java Toolbar
  • Toolbar Tag
  • Toolbar Item Tag
• Tree Tags
  • Applet Tree List Tag
  • For Each Indent Tag
  • For Each Node Tag
  • Indent Image Tag
  • Node Tag
• View Tags
  • Overview of Using View Tags
    • Modifications That Occurred Starting with Siebel CRM Version 8.x
    • Displaying More Views in the Content Area
  • Current View Tag
  • For Each View Tag
  • View Tag
  • View Bar Tag
    • How the Viewbar Tag Implements Drop-Down Lists and Tabs
  • View Link Tag
    • View Name Tag
  • Predefined Query Tag
• Tags That Support a Specific Feature
  • Language Conversion Tag
  • Training Tag
  • Wireless Tag
  • XSL Stylesheet Tag
• Tags That Are for Oracle Internal Use Only
  • All Applets, All Controls, and List Control Tags
  • Calendar Tags
  • Gantt Chart Tags

8 Siebel Templates for Employee Applications

• Siebel Templates for Employee Applications
• Overview of Configuring Siebel Templates for Employee Applications
  • Guidelines for Configuring Applet Templates
  • About Mapping IDs to Placeholders
  • Elements in the Client of an Employee Application
• Form Templates
  • Overview of Using Applet Form Templates
    • About Form Layouts That Use a Grid
    • About Form Layouts That Do Not Use a Grid
    • About the Style That Some Four Column Form Templates Use
  • Form Template for Edit, New, or Query Mode
  • One Column Form Template
  • One Column Form, Light Template
  • One Column Form, Light Template for Base, Edit, or New Mode
  • Four Column Form Template for Base Mode
  • Four Column Form Template for Edit or New Mode
  • Four Column Form Template With No Record Navigation
  • Grid Layout Form Template
• List Templates
  • List Template for Base or Edit List Mode
    • Configuring How Siebel CRM Uses the Columns Displayed Feature
  • Inverted Axis List Template
  • Message List Template
  • Portal List Template
  • Portal List Template With Graphics
  • Totals List Template for Base or Edit List Mode
• Calendar Templates
  • Daily Calendar Template
  • Daily Calendar Template for Portals
  • Weekly Calendar Template
  • Monthly Calendar Template
  • Service Calendar Template
• Chart Templates
  • Chart Template
  • Gantt Chart Template
  • Gantt Chart Activity Template
  • Gantt Chart Template for Portals
• Container Templates
  • Container Template
  • CC Container Logic Template
• Popup Templates
  • Popup Form Template
  • Popup Form, Grid Layout Template
  • Popup List Template
  • Popup Spell Checker Template
  • Popup Query Template
• Search Templates
  • Search Center, Top Template
  • Search Center, Bottom Template
  • Advanced Search Template
  • Find Template
  • Save Search Template
  • Search Preference Template
  • Search Results Templates
    • Search Results Header
    • Search Results Body
    • Search Refine Category
    • Search Results List Template
    • Search Results View Template
• Tree Templates
  • Applet Tree Template
  • Applet Tree, Marketing Template
  • View Tree Template
  • View Tree Two Template
• View Templates
  • Overview of Using View Templates
    • Guidelines for Using View Templates
  • View 1 Over 2 Over 1 Template
  • View 25 - 50 – 25 Template
  • View 25 – 75 Template
  • View 25 – 75 Framed Template
  • View 25 – 75 Framed Two Template
  • View 50 – 50 Template
  • View 66 – 33 Template
  • View Admin Template
  • View Admin Template With Grandchild Indented Applets
  • View Basic Template
  • View Catalog Admin Template
  • View Detail Template
  • View Detail Template With Grandchild Indented Applets
  • View Detail Two Template
  • View Detail Two Template With Grandchild Indented Applets
  • View Detail Three Template
  • View Detail Three Template With Grandchild Indented Applets
  • View Detail Three Multichild Template
  • View Detail Multichild Template
  • View Parent List With Tabs Template
• Specialized Employee Templates
  • Columns Displayed Template
  • Dashboard Template
  • Email Response Template for Inbound Messages
  • Email Response Template for Outbound Messages
  • Salutation Applet Template
  • Salutation Applet Template With Graphics
  • Screen Links Template
  • Send Mail Template
  • Send Mail Template for Picking Recipients
  • Site Map Template
  • View Dashboard Template
  • View Segment Detail Template
• Wizard, Error, and Smart Script Templates
  • Applet Wizard Template
  • Error Page Template
  • Smart Script Player Template
  • Smart Script Player Template With Tree Only

9 Siebel Templates for Customer Applications

• Siebel Templates for Customer Applications
• Overview of Configuring Siebel Templates for Customer Applications
  • Overview of User Interface Elements
• Customer Form Templates
  • Basic Form Template
  • One Column Form Template
  • Two Column Form Template
  • Four Column Form Template
  • Item Detail Form Template
  • Search, Top Form Template
  • Title, Form Template
  • Four Column, Merged, Form Template for Base, Edit, or New Mode
• Customer List Templates
  • Brief, Bullet, List Template
  • Brief, Bullet, Border, List Template
  • Brief, Bullet, Shade, List Template
  • Brief, Image Bullet, List Template
  • Brief, Image Bullet Two, List Template
  • Brief, Image Bullet, Border, List Template
  • Categorized List Template With Tabs
  • Categorized List Template With No Tabs
  • Brief, Image Bullet, Shade, List Template
  • Categorized Bullet, List Template
  • Categorized Bullet, List Template With Tabs
  • Categorized Table of Contents, List Template
  • Detailed, Image Bullet, List Template
  • Detailed, Image Bullet, List Template With Record Navigation
  • Detailed, Image Bullet, List Template With Record Navigation Two
  • Go To View, List Template
  • Horizontal List Template
  • List Template With Tabs
  • Light List Template
  • Search Results, List Template
  • Subcategory List Template
  • Subcategory, One Per Row, List Template
  • Subcategory, Four Per Column, List Template
  • Subcategory, Six Per Column, List Template
  • Subcategory, Indented, List Template
  • Merged List Template for Base or Edit List Mode
  • Links List Template
• Customer View Templates
  • Admin View Template
  • Basic View Template
  • Detail View Template
  • Detail View Two Template
  • Detail, Multiple Child, View Template
  • 25 50 25, View Template
  • 25 50 25, Home, View Template
  • 50 50, View Template
  • 66 33, View Template
  • 100 66 33 100, View Template
• Customer Container Templates
  • Container Template With Frames
  • Container Template Without Frames
  • Container Template for Employee and Customer Applications
• Specialized Customer Templates
  • Find Template
  • License, Base, One Column Template
  • Parametric Search, Head Template
  • Parametric Search, Tail Template
  • Real-Time Shopping Cart Template
  • Advanced Search Template
  • Advanced Search Template With Tabs
  • Basic Search Template
  • Totals Template

10 Cascading Style Sheets

• Cascading Style Sheets
• Overview of Cascading Style Sheets
• Elements of Cascading Style Sheets
  • Applet Elements
    • Applet Layout Style Elements
    • Applet Highlight Elements
    • Applet Style Elements
    • List Applet Elements
    • Tree Applet Elements
  • Banner Elements
  • Calendar Elements
    • Calendar Elements
    • Service Calendar Elements
  • Control Elements
  • Customer Application Elements
  • Dashboard Elements
  • Dialog Box Elements
  • Divider Elements
  • ePortal Elements
    • Add Info Section Elements
    • Company Header Elements
    • Company Search Elements
    • Profile Data Elements
    • Search Page Elements
    • Subsidiary Elements
  • External News Elements
  • Fonts and Link Color Elements
  • Form Elements
    • Single Column Form Elements
    • Multicolumn Editable Form Elements
  • Login Page Elements
  • Navigation Elements
    • Site Map Elements
    • Table of Contents Elements
    • Menu Bar Elements
    • Navigation Tab Elements
    • Threadbar Elements
    • Minibutton Elements
  • Page Header Elements
  • Rich Text Component Elements
  • Search Center Elements
  • SmartScript Player Elements
  • Status Message Elements
  • Text Elements

11 Operators and Expressions

• Operators and Expressions
• Operators
  • Operator Precedence
  • Comparison Operators
  • Logical Operators
  • Arithmetic Operators
  • LIKE and NOT LIKE Operators
    • Wildcard Characters You Can Use with the LIKE Operator
  • NULL Operator
    • IS NULL Operator
    • IfNull Function
    • Flag Fields and NULL
  • Using the EXISTS Operators with Multivalue Groups
    • Using the [NOT] EXISTS Operator with Multivalue Groups
    • Examples of Using EXISTS and NOT EXISTS
    • Using the EXISTS Operator with a Primary
• Expressions
  • Functions You Can Use in a Calculated Expression
  • Using the Division Functions
    • Using the Division Name Function to Display the Division Name
    • Searching or Sorting According to the Division
  • Using the IIf Function
  • Using Julian Functions
  • Using the Timestamp Function
    • Configuring Siebel CRM to Do Calculations with the Timestamp Function
  • Using Functions in the Predefault and Postdefault Properties
  • Using Expressions In the Calculated Field and Field Validation Properties
    • Elements You Can Use in Calculated Fields and Query By Example
  • Using the Invoke Service Method in a Calculated Field
  • Using Calculated Fields with Chart Coordinates
  • How Siebel CRM Handles Data Types During a Calculation
    • How Data Type Affects Order of Precedence
  • Guidelines for Configuring Calculated Fields