SQL query to extract specific information from ATTR_XML column in WF_CUSTOM_ATTRS table
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
Please sign in to leave a comment.
Comments
3 comments