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

Follow

Hansen, Laura A

• December 18, 2017 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

  • January 02, 2018 17:31
  • Edited

  Thank you for the response. 

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

  0

  Permalink
• 

  Mario Oenning

  • January 03, 2018 07:56

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

  0

  Permalink
• 

  MikeM

  • November 08, 2018 15:15

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

   

  Thanks.

  0

  Permalink

Please sign in to leave a comment.