SQL query to extract specific information from ATTR_XML column in WF_CUSTOM_ATTRS table

追蹤

Hansen, Laura A

• 2017年12月18日 17:04

There were a few columns that were missed in our definition of our data population to a SQL table we use for reporting.   I'd like to go back through the form data and extract that information.   

Can anyone point me in the right direction on the syntax for a SQL query to do something like the following pseudo code?

select value of pd:fieldname1, pd:fieldname2  in ATTR_XML

from WF_CUSTOM_ATTRS

where custom_ID = WorkObjectID

1

• 

  Hansen, Laura A

  • 2018年01月02日 17:31
  • 編輯於

  Thank you for the response. 

  I got the sample functions via an email but they are not posted here in the comments?

  0

  評論操作 永久連結
• 

  Mario Oenning

  • 2018年01月03日 07:56

  Seems they have removed my comment :) Now it is pending for approval.

  0

  評論操作 永久連結
• 

  MikeM

  • 2018年11月08日 15:15

  Out of curiosity,  would someone still have those sample functions the could post again?

   

  Thanks.

  0

  評論操作 永久連結

請登入寫評論。