Hi All , I have a question related to JSON sorting I have a below structure stored in cassandra and i would like to get the internal array sorted by a property when i select it , Please let me know if there is way to do that .
I need to sort the rules Array by property ruleOrder when i select CREATE TYPE IF NOT EXISTS Rule ( condition text, action text, ruleOrder int); INSERT INTO model.RuleSetSchedule JSON ' { ruleSetName": "RATES", "ruleSetId": "829aa84b-4bba-411f-a4fb-38167a987cda", "scheduleId":1, "effectiveStartDate": "2015-02-01 00:00:00", "effectiveEndDate": "2015-03-01 00:00:00", "rules": { "1": { "condition": "BoardStation ==''Lowell''", "action": "FareAmount=9.25", * "ruleOrder": 2* } "2": { "condition": "BoardStation ==''Lowell''", "action": "FareAmount=9.25", * "ruleOrder": 1* } } }';