Geoserver SQL views do not support citext column fields.
Has been tested with same data when citext sql view does not see column, when converted to text column, sql view sees column.
Symptom was noticed where a layer was styled by citext attribute, after adding to sql view layer does not display as style depends on the column citext
I notice that citext support was added to geotools in GeoToolsGEOT-4713
but it seems hasnt made it to SQL views yet
Thanks guys for the hard work.
Windows server 2012
oracle java 8
Closing all non bug report tickets that has seen no activity in the last year. If you are interested in this ticket we encourage you to re-open it only after securing the necessary development resources.
Please to read this guide to learn how to best deal with this type of requests: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer