Hello! You can define your own SQL function json_value to do that: https://ignite.apache.org/docs/latest/SQL/custom-sql-func
You will need to do that in Java and deploy it to your server nodes (if you're using client node as a gateway for thin clients, also to such client nodes). Regards, -- Ilya Kasnacheev чт, 17 дек. 2020 г. в 20:14, siva <[email protected]>: > Hi All, > I have .Net ClientServer Ignite Application.And Table Model annotation with > QuerySQLField. > In Tables some of column contains json string. > > How to extracts value from json string field in query? > > *for example query* > select uuid, json_value(Payload,'$.comments') as comments from > > "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".dailyjournal; > > Could you please guide me how to approach this. > > > Thanks. > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
