I have mssql datastore and named layer Compressor generated based on SQL view query that I want to filter from Openlayer wms request based on Property EntityUser that contains JSON object with a key.
Sample JSON that contains EntityUser Column/Property is: { "4742ed9e-384c-41fe-9240-8ced1da67759": { "242b5425-2abb-45f1-8f6f-e962ef0861e0": ["746c8188-0125-41f5-aa61-e42c753a77ac"] }, "fff4f98e-cddd-4c7e-aa3e-57e20ec682e9": { "242b5425-2abb-45f1-8f6f-e962ef0861e0": ["746c8188-0125-41f5-aa61-e42c753a77ac"] } } So how I apply cql or ogc filter on Property that having JSONObject? Layer Preview Image: <http://osgeo-org.1560.x6.nabble.com/file/t381824/cql_filter_on_EntityUser_Property.png> And also suggest what are all the way possible to filter layer. Thanks in advance. -- 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