This documentation supports the 19.02 version of Change Management.

To view the latest version, select the version from the Product version menu.

Query operations

You can use the following query functions that are specific to web services.

  • QueryTaskPlusRelationshipsAndWorkInfo
  • QueryTaskOnly
  • QueryTaskPlusWorkInfo
  • QueryTaskPlusRelationships

To perform a search outside of web services, do it directly from the TMS:TaskInterface form.

The following table lists the input values from the TMS:TaskInterface form:

Input values

DB field on interface form

Web service field

Notes

TaskID

TaskID

Supply Task ID as the input parameter

The following table lists the output values from the TMS:TaskInterface form:

Output values

DB field on interface form

Web service field

TaskID

TaskID

InstanceId

TaskInstanceID

Status

TaskStatus

StatusReasonSelection

TaskStatusReason Selection

RootRequestID

RequestID

RootRequestInstanceID

RequestInstanceID

RootRequestName

RequestName

TaskType

TaskType

TaskName

TaskName

Summary

TaskSummary

Notes

TaskNotes

Priority

Priority

RootRequestLevel

RequestLevel

Assignee Company

AssignedCompany

Assignee Organization

AssignedOrganization

Assignee Group

AssignedGroup

Assignee

Assignee

Scheduled Start Date

ScheduledStartDate

Scheduled End Date

ScheduledEndDate

Actual Start Date

ActualStartDate

Actual End Date

ActualEndDate

EffortTrackingStartTime

EffortTrackingStartTime

EffortTrackingEndTime

EffortTrackingEndTime

BudgetEstimatedTotalTime

BudgetEstimatedTotal Time

ActualEstimatedTotalTime

ActualEstimatedTotal Time

AutoCostCalculationUnitType

AutoCostCalculation UnitType

Activate Time

ActivateTime

Assign Time

AssignTime

EndTime

EndTime

Location Company

LocationCompany

Region

Region

Site Group

SiteGroup

Site

Site

Company

RequesterCompany

First Name

RequesterFirstName

Middle Name

RequesterMiddleName

Last Name

RequesterLastName

Phone Number

RequesterPhoneNumber

Organization

RequesterOrganization

Department

RequesterDepartment

Support Organization

SupportOrganization

Support Group Name

SupportGroupName

Customer Company

CustomerCompany

Customer First Name

CustomerFirstName

Customer Middle Name

CustomerMiddleName

Customer Last Name

CustomerLastName

Customer Phone Number

CustomerPhoneNumber

Customer Organization

CustomerOrganization

Customer Department

CustomerDepartment

Product Cat Tier 1

ProductCategorization Tier1

Product Cat Tier 2

ProductCategorization Tier2

Product Cat Tier 3

ProductCategorization Tier3

Product Name

ProductName

Product Model/Version

ProductModelVersion

Manufacturer

Manufacturer

Operational Cat Tier 1

Operational CategorizationTier1

Operational Cat Tier 2

Operational CategorizationTier2

Operational Cat Tier 3

Operational CategorizationTier3

attachmentName
(z2af_Attachment1 field)

Attachment1Name

attachmentData
(z2af_Attachment1 field)

Attachment1Data

attachmentOrigSize
(z2af_Attachment1 field)

Attachment1OrigSize

attachmentName
(z2af_Attachment2 field)

Attachment2Name

attachmentData
(z2af_Attachment2 field)

Attachment2Data

attachmentOrigSize
(z2af_Attachment2 field)

Attachment2OrigSize

attachmentName
(z2af_Attachment3 field)

Attachment3Name

attachmentData
(z2af_Attachment3 field)

Attachment3Data

attachmentOrigSize
(z2af_Attachment3 field)

Attachment3OrigSize

Character 01

Character01

Character 02

Character02

Character 03

Character03

Character 04

Character04

Character 05

Character05

Character 06

Character06

Integer 01

Integer01

Integer 02

Integer02

Integer 03

Integer03

Real 01

Real01

Real 02

Real02

Real 03

Real03

Decimal 01

Decimal01

Decimal 02

Decimal02

Date 01

Date01

DateTime 01

DateTime01

DateTime 02

DateTime02

Time 01

Time01

YesNo 01

YesNo01

YesNo 02

YesNo02

On 01

On01

On 02

On02

AutomaticCommandSelection

AutomaticCommand

ElectronicField1

ElectronicField1

ElectronicField2

ElectronicField2

ElectronicField3

ElectronicField3

ElectronicText

ElectronicText

ElectronicDecimal

ElectronicDecimal

TimeOutValue

TimeOutValue

Unit

TimeOutUnit

ExpectedTimeOut

ExpectedTimeOut

The following table lists the output values from the TMS:Relationships form:

Output values

DB field on interface form

Web service field

Relationships ID

RelationshipsID

InstanceID

RelationshipsInstanceID

Status

RelationshipsStatus

RelatedItemID

RelatedItemID

RelatedItemSource

RelatedItemSource

RelatedItemType

RelatedItemType

Description

Description

Attribute1

Attribute1

Attribute2

Attribute2

Attribute3

Attribute3

RelationshipType

RelationshipType

The following table lists the output values from the TMS:WorkInfo form:

Output values

DB field on interface form

Web service field

InstanceID

WorkInfoInstanceID

Status

WorkInfoStatus

WorkInfoType

WorkInfoType

Communication Source

WorkInfoCommSource

Summary

WorkInfoSummary

Notes

WorkInfoNotes

Secure Log

WorkInfoSecureLog

attachmentName
(z2af_Attachment1 field)

WorkInfoAttachment1Name

attachmentData
(z2af_Attachment1 field)

WorkInfoAttachment1Data

attachmentOrigSize
(z2af_Attachment1 field)

WorkInfoAttachment1OrigSize

attachmentName
(z2af_Attachment2 field)

WorkInfoAttachment2Name

attachmentData
(z2af_Attachment2 field)

WorkInfoAttachment2Data

attachmentOrigSize
(z2af_Attachment2 field)

WorkInfoAttachment2OrigSize

attachmentName
(z2af_Attachment3 field)

WorkInfoAttachment3Name

attachmentData
(z2af_Attachment3 field)

WorkInfoAttachment3Data

attachmentOrigSize
(z2af_Attachment3 field)

WorkInfoAttachment3OrigSize

Was this page helpful? Yes No Submitting... Thank you

Comments