Query operations
The following query functions 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 |
Comments
Log in or register to comment.