InformationLinkParameter Class

Spotfire 14.3 API Reference
Defines a runtime parameter in an information link execution.
Inheritance Hierarchy

SystemObject
  Spotfire.Dxp.Data.ImportInformationLinkParameter

Namespace:  Spotfire.Dxp.Data.Import
Assembly:  Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 65.0.19510.3242 (65.0.19510.3242)
Syntax

C#
[SerializableAttribute]
[PersistenceVersionAttribute(6, 0)]
public sealed class InformationLinkParameter : ISerializable

The InformationLinkParameter type exposes the following members.

Properties

  NameDescription
Public propertyDataType Obsolete.
Gets the parameter data type.
Public propertyElementId Obsolete.
Gets the identifier for the element (column or procedure) in the information link that this parameter applies to.
Public propertyElementIdentifier
Gets the identifier for the element (column or procedure) in the information link that this parameter applies to.
Public propertyExpression
Gets the expression for a filter parameter.
Public propertyExternalDataType
Gets the parameter data type.
Public propertyParameterId
Gets a parameter identifier local for the current element (see ElementIdentifier).
Public propertyValues
Gets the parameter values.
Top
Methods

  NameDescription
Public methodStatic memberCreateFilterParameter(Guid, String, Object)
Creates a new InformationLinkParameter representing a filter parameter.
Public methodStatic memberCreateFilterParameter(String, String, Object) Obsolete.
Creates a new InformationLinkParameter representing a filter parameter.
Public methodStatic memberCreateFilterParameter(Guid, String, Object, ExternalDataType)
Creates a new InformationLinkParameter representing a filter parameter.
Public methodStatic memberCreateFilterParameter(String, String, Object, String) Obsolete.
Creates a new InformationLinkParameter representing a filter parameter.
Public methodStatic memberCreateNamedParameter
Creates a new InformationLinkParameter that represents a named parameter defined in the information model.
Public methodStatic memberCreateReferencedParameter(Guid, String, Object)
Creates a new InformationLinkParameter that represents a local parameter defined in the specified procedure element.
Public methodStatic memberCreateReferencedParameter(String, String, Object) Obsolete.
Creates a new InformationLinkParameter that represents a local parameter defined in the specified procedure element.
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Explicit Interface Implementations

  NameDescription
Explicit interface implementationPrivate methodISerializableGetObjectData
Populates a SerializationInfo with the data needed to serialize the target object.
Top
Remarks

There are three kinds of parameters that may be defined by this class; named parameters, filter parameters and referenced (procedure) parameters.

A named parameter points to a predefined named parameter in an information link. The parameter name is identified by the ParameterId property. Named parameters may also be passed in a configuration block when opening an analysis. Including a named parameter in the InformationLinkDataSource constructor will override any parameter with the same name passed in a configuration block. For information on how to set up named parameters in an information link see the 'Parameterized Information Link' topic in Spotfire - User's Manual.

A filter parameter adds a filter to a column in an information link. The column is identified by the ElementId property. The filter is defined by the Expression property, which is essentially a SQL expression with placeholders for the column identifier and parameter values:

  • %Column% - Placeholder for a source column identifier. The placeholder may occur one or several times in the expression, for example "%Column% in ... or %Column% = ...".
  • %Values% - Placeholder for the parameter values as a list, for example "%Column% in (%Values%)".
  • %Value[n]%, where n=0,1,.. - Placeholder for one of the parameter values, for example "%Column% between %Values[0]% and %Values[1]%".
  • %Value% - Short for %Value[0]%. Placeholder for a single parameter value, for example "%Column% <= %Value%".

A referenced parameter represents a procedure parameter. The procedure is identified by the ElementId property and the parameter name is identified by the ParameterId property.



The following data types are supported:
  • String - Representation type: System.String
  • Integer - Representation type: System.Int32
  • Real - Representation type: System.Double
  • Date - Representation type: System.DateTime
  • Time - Representation type: System.DateTime
  • DateTime - Representation type: System.DateTime
  • Clob - Representation type: System.String
  • Blob - Representation type: System.byte[]
Version Information

Supported in: 14.3, 14.2, 14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.8
See Also

Reference