Hi there, Your JSON is being treated as text as far as GeoServer is concerned. ECQL does not have a function that will parse the JSON and extract a particular property. FYI, the full grammar is documented in the the GeoTools ECQL BNF definition <https://github.com/geotools/geotools/blob/master/modules/library/cql/ECQL.md> .
That being said, you have two alternatives: 1) SIMPLE. Just extract the properties you need to filter by into separate columns. Use triggers if you need to update them dynamically. 2) HARD. Create a stored procedure in MySQL that parses the JSON and extracts a property's value by its key, then create a custom filtering function (see this post for a starting point: http://osgeo-org.1560.x6.nabble.com/Custom-filter-function-td5062121.html <http://osgeo-org.1560.x6.nabble.com/Custom-filter-function-td5062121.html> ) which calls the procedure. Best regards, Manuel -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
