Selectable Fields for Connections

This section lists the selectable fields for connections.

Selectable Fields for Connections
Field Description Output

altowner1

Alternate owner 1

Returns the altowner1 for the connection

altowner2

Alternate owner 2

Returns the altowner2 for the connection

attribute[].*

Attribute values on the connection

If an attribute is specified default is attribute value. If nothing is specified in [ ], returns attributes on the relationship type.

businessobject.*

End objects of the connection.

Returns type, name, and revision of objects on both ends of the relationship.

context.*

Context identifier

Returns current context user.

from.*

from object or relationship

Returns type, name, and revision of objects on from end.

If the from end is a business object, returns the business object.

If the from end is a relationship, returns null.

Previously, this field always returned a business object.

To retrieve the from end regardless of its type, use the fromall field.

fromall.*

From side of the connection

Returns the ID of the from side

If it is a business object, returns the business object ID prefixed with a B.

If it is a relationship, returns the connection ID prefixed with R.

It is not necessary to strip off the prefix when passing these ids back into the system for subsequent operations.

frommid.*

The connections pointing from this connection.

List of connections.

Supports optional relationship type pattern, for example frommid[EBOM].

fromrel.*

The connection at the from end.

If it is a connection, returns the connection

If it is a business object, returns null

history.*

Connection history log file

If history [n] = returns the nth history entry. If nothing is specified in [ ], returns log of all entries. The first entry is identified as "0".

id

Connection identifier

Value

interface

Name

Name of the interface

isfrozen

Has the connection been Frozen?

True/False

logicalid

A connection identifier. A logical id is a global identifier shared by all members of a revision sequence.

This selectable is only available if your database has been upgraded to use physical and logical IDs.

Value

method.*

Unused

modified

Modification time and date

Value

modified.generic

Modification time and date in generic format (independent of the MX_NORMAL_DATETIME_FORMAT and MX_DECIMAL_SYMBOL settings chosen by an Administrator)

Value

name

Relationship type or connection name

Value

object[ ]

a corresponding business object

Returns a business object where the type matches the string in [ ] and the name is the same as the connection's name. If no string is given, the object type is connection, with case ignored. In a case sensitive environment if more than 1 type meets that criteria (such as both a Person type and a PERSON type), OR if there are more than 1 object with the same type and name that are not in the same revision chain, the object with the latest originated date is returned. When objects with same type and name are in the same revision chain, the latest revision is returned.

originated

Creation time and date

Value

originated.generic

Creation time and date in generic format (independent of the MX_NORMAL_DATETIME_FORMAT and MX_DECIMAL_SYMBOL settings chosen by an Administrator)

Value

owner.*

?

Value (see Selectable Fields for User)

physicalid

A connection identifier. A physical id is a global identifier that is unique to each conenction.

This selectable is only available if your database has been upgraded to use physical and logical IDs.

Value

propagatemodifyfrom

Is propagatemodify enabled on from businessobject.

True/False

propagatemodifyto

Is propagatemodify enabled on to businessobject.

True/False

reserved

Boolean indicator of a reserved status for a connection

True/False

reservedby

Non-empty string or the context user

Name of the person who reserved the connection.

reservedstart

The date or timestamp of when the connection was reserved

Returns the date and time of when that connection was reserved.

reservedstart.generic

The date or timestamp in generic format (independent of the MX_NORMAL_DATETIME_FORMAT and MX_DECIMAL_SYMBOL settings chosen by an Administrator) of when the connection was reserved

Returns the date and time of when that connection was reserved.

reservedcomment

Optional comment not exceeding 254 characters from the person reserving the object

Any comments entered.

rule[].*

Rule values on connections

If rule name [] is specified, list accesses allowed by current context user. If no rule name[] is specified, list associated rules

to.*

to object or relationship

Returns type, name, and revision of objects on to end.

If the to end is a business object, returns the business object.

If the to end of the connection is a connection, returns null.

Previously, this field always returned a business object.

To retrieve the to end regardless of its type, use the toall field.

toall

To side of the connection

Returns the ID of the to side

If it is a business object, returns the business object ID prefixed with a B.

If it is a relationship, returns the connection ID prefixed with R.

It is not necessary to strip off the prefix when passing these ids back into the system for subsequent operations.

tomid.*

The connections pointing to this connection

List of connections

Supports optional relationship type patterns, for example, tomid[EBOM].

torel.*

The connection at the to end

If it is a connection, returns the connection

If it is a business object, returns null

type.*

Object types that may be connected by the relationship type

Value