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 | Attachment1Name |
attachmentData | Attachment1Data |
attachmentOrigSize | Attachment1OrigSize |
attachmentName | Attachment2Name |
attachmentData | Attachment2Data |
attachmentOrigSize | Attachment2OrigSize |
attachmentName | Attachment3Name |
attachmentData | Attachment3Data |
attachmentOrigSize | 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 | WorkInfoAttachment1Name |
attachmentData | WorkInfoAttachment1Data |
attachmentOrigSize | WorkInfoAttachment1OrigSize |
attachmentName | WorkInfoAttachment2Name |
attachmentData | WorkInfoAttachment2Data |
attachmentOrigSize | WorkInfoAttachment2OrigSize |
attachmentName | WorkInfoAttachment3Name |
attachmentData | WorkInfoAttachment3Data |
attachmentOrigSize | WorkInfoAttachment3OrigSize |