I am really struggling with this and must get this somehow. Can anyone please help me.
I have a column in this table called "PropertyBagxml" and it contains XML data. There is one field and value in this XML file that I need to query on.
My query is going to say something like IF xml field value = True then "yes" else "no"
So here is the sample of the XML file:
- <v:ConditionDelegate i:nil="true" />*
- <v:CreatedBy>O'Neal, Charlton</v:CreatedBy>*
- <v:CreatedWhenUTC xmlns:d1p1="... http link here...">*
- d1p1:DateTime2022-07-15T15:51:52.07Z</d1p1:DateTime>*
- d1p1:OffsetMinutes-240</d1p1:OffsetMinutes>*
- </v:CreatedWhenUTC>*
- <v:Height>79.5</v:Height>*
- <v:IsConditional>false</v:IsConditional>*
The statement I need to query against is the one that states: <v:IsConditional>false</v:IsConditional>
Can someone help me with this, PLEASE!!
Thanks. First time posting on here so be nice