Routines for search.kb


ApplyColumnReplacements

File Name

search.kb

Syntax

ApplyColumnReplacements( VAL tbName: STRING, REF columnList: LIST OF ColumnRecord)

Parameters

tbName: name of the table for column name aliases

columnList: list of column records to be replaced

with an alias from the EACOLUMNS table

Returns

Nothing

Side Effects

None

Description

This procedure will replace the database column names with the appropriate column alias set up in the application configuration.

Dialog Forms Called

None


CreateSearchString

File Name

search.kb

Syntax

CreateSearchString( VAL parentWindow: Window, VAL controlName: STRING, VAL TBName: String, REF condition: String, REF orderBy: String): BOOLEAN

Parameters

parentWindow: handle of the parent window

controlName: name of dialog control

TBName: name of the table to search

condition: where clause condition to use in search

orderBy: order by clause containing the fields by which to

order the search.

Returns

TRUE: Success

FALSE: Failure

Side Effects

None

Description

This function allows the user to create a search string that can be used multiple times. In the Tivoli Service Desk applications this function is called where passing in record data for the "Work With" dialog boxes, so the search criteria can be maintained for the duration of the "Work With" inquiry.

Dialog Forms Called

search.dfc[searchstring]


FulcrumRecToSyntax

File Name

search.kb

Syntax

FulcrumRecToSyntax(VAL ColumnName: STRING, VAL FulcrumRec: FulcrumRecord): STRING

Parameters

ColumnName - ame of column to search.

FulcrumRec - fulcrum record containing additional search

parameters.

Returns

The appropriate search syntax used by Fulcrum or

Intelligent Miner for Text.

Side Effects

This function requires that Intelligent Miner for Text is installed and properly configured.

Description

This procedure returns the syntax needed to do a search using Intelligent Miner for Text.

Dialog Forms Called

None


GetColumnList

File Name

search.kb

Syntax

GetColumnList ( VAL tbName: STRING, REF columnList: List of STRING)

Parameters

tbName - name of the table for column name aliases

columnList - list of column names.

Returns

Nothing

Side Effects

None

Description

This procedure returns the names of the columns for a given table in the column list that is passed to this procedure.

Dialog Forms Called

None


GetTableList

File Name

search.kb

Syntax

GetTableList ( REF tableList: List of STRING)

Parameters

tableList - list of table names

Returns

Nothing

Side Effects

This procedure uses $QUAL, to limit the list to the tables that were created under the current qualifier. The qualifer is set in the Configuration Editor.

Description

This procedure will return the names of all the tables in a database that were created under the current qualifier.

Dialog Forms Called

None


QueryColumnWidth

File Name

search.kb

Syntax

QueryColumnWidth( VAL tbName: STRING, VAL columnName: STRING): INTEGER

Parameters

tbName - name of the table for column name aliases

columnName - column for which to find length.

Returns

Integer

Side Effects

None

Description

This procedure returns the length of a column given the column name, and table name.

Dialog Forms Called

None