select id,type, Rt_behaviour_text,created_at
from table_name;
Here value for the column 'type' is dependant on searching text from 'Rt_behaviour_text' which holds xml data.
If the specific filter value 'type=REALTIME' is available into 'Rt_behaviour_text', then 'type' column would be filled up with 'REALTIME' otherwise ''.
How can I do this in sap hana?