I need to extract two columns from the ZX_CONDITIONS table. The first column is condition_group_code and the second is the <value> which is stored in the <FLEX_FILTER_VALUE> column.
Now I have no problem regarding the condition_group_Code, but am battling to find a method to extract <value>
See snapshot of xml, It is the yellow highlighted field I am tring to extract. How do I write my query to obtain that. There are many reiterations within one condition_group_code
