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
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:
{
