Simple Querylet

The Simple Querylet activity defines a simple querylet for use in a Query or Join-Query activity.

General

The General tab has the following fields:

Simple Querylet Configuration Fields

Field

Module Property?

Description

Name

No

The name of the activity within the process. The default value is simple.

Description

Provide a short description for the Simple Querylet activity.

Input

The Input tab has the following fields:

Simple Querylet Input Fields

Input Item

Description

QueryString

The text to be searched for.

Field

The table fields to be searched. If no fields are specified, all fields are searched. This is optional and can be repeated.

Field/Name

Name of the table field.

Field/Weight

The weight of the field. The default is 1.0.

EmptyScore

The score to use if there is no data to compare. Either querystring or field-value is empty

InvalidScore

The score assigned if invalid data is encountered. As text data is never invalid, this value has no effect for a Simple querylet.

MatchEmpty

If set to true(), empty values in both the record and the query produces a 1.0 querylet score.

ScoreType

The type of score to perform. The following are the possible types: Normal, Symmetric, Reverse, Max, or Min. The default is Normal. This is optional.

ThesaurusName

Name of an existing thesaurus to apply. This is optional.

ThesaurusWeight

Weight of the thesaurus. The default is 1.0. This is optional.

TemporaryThesaurus

A temporary thesaurus to apply. At most, specify one of the temporary and named thesauruses. This is optional.

TemporaryThesaurus/Name

Ignored.

TemporaryThesaurus/Type

The thesaurus type. The following are the possible types: Substitution, WeightedTerm, or Combined.

TemporaryThesaurus/CharacterMapName

The character map applied to thesaurus terms and lookup values. This is optional.

TemporaryThesaurus/ExactMode

Set to true() if this thesaurus matches terms exactly. This is optional.

TemporaryThesaurus/Equivalence

Each equivalence is a set of two or more interchangeable terms. This can be repeated.

TemporaryThesaurus/Equivalence/Term

The equivalence term.

TemporaryThesaurus/Equivalence/Weight

This only applies to WeightedTerm and Combined thesauri. The default is 1.0.

TemporaryThesaurus/Equivalence/Penalty

This only applies to Combined thesauri. The default is 1.0.

ExpertParameter

Only use this under the direction of TIBCO Support.

Output

The output of a simple querylet must be used as a unit by dragging it to the AnyQueryOutlet element of a Query Activity input or Combiner Querylet input.