SI_DESCRIPTION Property

Stores a textual description of the object.

Type

String

Syntax

SELECT

    SI_DESCRIPTION

FROM

    [Categories]

WHERE

    SI_ID = ObjectID

The syntax has these parts:

Part	Type	Description
ObjectID	Long	A number that identifies the object you want to retrieve.

Used to access the property from a query result:

QueryResult.Item(Index).Description

Remarks

This property stores a textual description of the object. It has no maximum length. It can be used to provide search capabilities that will allow a user to search for an object using keywords.

The following example selects the names of all objects that have the string 'employee picture' in their description. This example is case-insensitive. To see an example of a search that is case-sensitive, see Lesson 2d: Searching for reports in the Getting Started Tutorial (JavaScript).

SELECT
    SI_NAME 
FROM
    CI_INFOOBJECTS 
WHERE
    SI_DESCRIPTION LIKE '%employee picture%'

The Like operator in this statement does a case insensitive text comparison on all reports in Crystal Enterprise, and the percentage signs act as wildcards.

To see an example of how to change the value of SI_DESCRIPTION see the example for SI_NAME Property.