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

Reply via email to