GetLinksBySQLCond [Connectivity Automation Reference: CAR]

GetLinksBySQLCond Method


Gets a Links collection based on link template, SQL condition, and (optionally) link type.

See Also

Signature

RetVal = object.GetLinksBySQLCond(LinkTemplate, Condition [, LinkTypes] [, Document])

Object

DbConnect
The object or objects this method applies to.

LinkTemplate

LinkTemplate object, or a string identifying a link template; input-only
Specifies the link template whose links are returned.

Condition

String; input-only
The WHERE clause of the SQL statement, identifying the conditions to be met.

LinkTypes

Integer; input-only; optional
Specifies the type of links to return. You can specify any combination of the following link types:

kEntityLinkType: Entity links

kFSLabelType: Freestanding labels

kAttachedLabelType: Attached labels

If no value is specified, only entity links are returned.

Document

Document object; input-only; optional
This argument is ignored if a LinkTemplate object is passed as the first argument. If this argument is not specified, the document object is identified as follows:

RetVal

Links collection;
The Links collection meeting the specified conditions.

Remarks

You must connect to the data source identified by LinkTemplate before issuing GetLinksBySQLCond.

The SQL conditions are applied to every linked row in the database, and the corresponding link object is returned if the conditions are met.