SI_NAME Property

Stores the textual name of the object. Indexed.

Type

String

Syntax

SELECT

    SI_NAME

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).Title

Remarks

This property stores the name of an object. It can be used both to display the object's name and to search for a particular object. This is not a unique value; therefore, different objects may have the same names. To list objects by a unique value use the SI_ID property.

Searching for a report by name

This example searches for all reports whose name contains the word 'taxes'. The search is case-insensitive. To see an example of a search that is case-sensitive, see the Tutorial: Lesson 2d: Searching for reports.

Result=InfoStore.Query("Select SI_NAME From CI_INFOOBJECTS where SI_PROGID='CrystalEnterprise.Report' and SI_INSTANCE=0 Like '%taxes'")

The LIKE operator in this statement does a text comparison on all reports in Enterprise, and the percentage sign acts as wildcard.

Retrieving a plugin

Use SI_NAME to retrieve a plugin. For example:

SELECT TOP 10 * FROM CI_SYSTEMOBJECTS WHERE SI_NAME='secEnterprise' and SI_ANCESTOR=25

Note that when you use a query such as Select Top 10 * From CI_SYSTEMOBJECTS where SI_PROGID = 'CrystalEnterprise.Connection', you do not retrieve the connection plugin object; rather, you get back the connection objects that have been added to the APS.