Forum Stats

  • 3,769,308 Users
  • 2,252,946 Discussions
  • 7,874,982 Comments

Discussions

which table of SOAINFRA schema stores the process data object contents

User_77Q2I
User_77Q2I Member Posts: 2 Red Ribbon

Hi,

When we use TaskQuery service to fetch the results, as part of the response, along with taskAttributes we get process data objects contents also. I understand the task attributes are stored in WFTASK table, but where does the process data object contents gets stored i.e which table holds this data.

For instance, if we consider the below response, am interested to know where the payload objects get stored ?

<ns0:task>

            <ns0:payload>

               <ns0:OpportunityNumber>CRF10179</ns0:OpportunityNumber>

               <ns0:OpportunityId/>

               <ns0:BatchId/>

               <ns0:SnapshotId/>

               <ns0:QuoteId>103</ns0:QuoteId>

               <ns0:QuoteVersion>0.1</ns0:QuoteVersion>

               <ns0:CreatedBy/>

               <ns0:TaskDueDate>2019-07-22</ns0:TaskDueDate>

               <ns0:PMComments>Price and review Honeywell products for opportunity CRF10179</ns0:PMComments>

               <ns0:ApproverComments/>

               <ns0:Attribute1>ManagePricing</ns0:Attribute1>

               <ns0:Attribute2>NEW</ns0:Attribute2>

               <ns0:Attribute3></ns0:Attribute3>

               <ns0:Attribute4></ns0:Attribute4>

               <ns0:Attribute5/>

               <ns0:RoleName>s</ns0:RoleName>

               <ns0:DBRoleName/>

               <ns0:UserNames/>

               <ns0:UserFullNames/>

               <ns0:UserEmail/>

               <ns0:PMAction/>

               <ns0:AssignmentCategory/>

               <ns0:groupAssigned>e</ns0:groupAssigned>

               <ns0:Role>e</ns0:Role>

               <ns0:QuoteNo>103</ns0:QuoteNo>

               <ns0:QuoteRevision>0.1</ns0:QuoteRevision>

               <ns0:Status/>

               <ns0:TaskTitle></ns0:TaskTitle>

               <ns0:OpportunityType></ns0:OpportunityType>

               <ns0:UIAction/>

               <ns0:TaskClosureId/>

            </ns0:payload>

            <ns0:TaskAttributes>

               <ns0:title></ns0:title>

               <ns0:ownerUser/>

               <ns0:priority>3</ns0:priority>

               <ns0:identityContext/>

               <ns0:processinstanceId/>

               <ns0:processId/>

               <ns0:processName/>

               <ns0:assignedDate>2018-12-12T12:08:30-05:00</ns0:assignedDate>

               <ns0:assigneeUsersId/>

               <ns0:assigneeUsersDisplayName/>

               <ns0:assigneeUsersType>user</ns0:assigneeUsersType>

               <ns0:createdDate>2018-12-12T12:08:29-05:00</ns0:createdDate>

               <ns0:fromUserType>user</ns0:fromUserType>

               <ns0:taskId>11221a37-9743-4bbe-822e-a6f0e6b762e1</ns0:taskId>

               <ns0:taskNumber>203594</ns0:taskNumber>

               <ns0:state>ASSIGNED</ns0:state>

               <ns0:subState/>

               <ns0:acquiredBy/>

               <ns0:outcome/>

               <ns0:updatedById></ns0:updatedById>

               <ns0:updatedByDisplayName/>

               <ns0:updatedByType>user</ns0:updatedByType>

               <ns0:updatedDate>2019-07-03T11:26:36-04:00</ns0:updatedDate>

               <ns0:activityName/>

               <ns0:textAttribute1></ns0:textAttribute1>

               <ns0:textAttribute2>103</ns0:textAttribute2>

               <ns0:textAttribute3>0.1</ns0:textAttribute3>

               <ns0:textAttribute4></ns0:textAttribute4>

               <ns0:textAttribute5/>

               <ns0:textAttribute6></ns0:textAttribute6>

               <ns0:textAttribute7>NEW</ns0:textAttribute7>

               <ns0:textAttribute8/>

               <ns0:textAttribute9>10a88ec2-4f99-4c-e5a742a1db36</ns0:textAttribute9>

               <ns0:textAttribute10/>

               <ns0:textAttribute11/>

               <ns0:numberAttribute1>0.0</ns0:numberAttribute1>

               <ns0:numberAttribute2>0.0</ns0:numberAttribute2>

               <ns0:numberAttribute3>0.0</ns0:numberAttribute3>

               <ns0:ownerUserDisplayName/>

            </ns0:TaskAttributes>

         </ns0:task>

Answers