Thank you Erik,
After some further research another solution would be to customize the
content ftl/template to show only desired columns.I will try to implement
this solution
https://gis.stackexchange.com/questions/6009/how-to-select-
fields-returned-by-geoserver-wms-getfeatureinfo-request
On Thu, Jun 28, 2018 at 12:58 AM, Valley GIS Limited <
[email protected]> wrote:
> Hello Amelia,
>
>
>
> The only thing I would suggest is maybe experiment with building your
> view on the database end of things. I prefer, whenever possible, to
> publish layers that are provided by Materialized Views (virtually a table)
> and harness the strengths of the database engine. Instead of performing
> n-many complex calculations on demand, x-many times per session, these
> calculations are made when the m_view is refreshed. I can run cron jobs /
> scheduled tasks to perform this as often as necessary. New indices can be
> made which are unique to the contents of this specific view which may
> further improve performance.
>
> If you are publishing a layer from a materialized view, you’re avoiding
> the possibility of Geoserver discarding your finely-tuned configuration.
> That fine-tuning occurs outside its scope, within the database engine.
>
>
>
> I hope this helps,
>
> Erik
>
>
>
> *From:* Nauwanga Nauwanga [mailto:[email protected]]
> *Sent:* Wednesday, June 27, 2018 12:21 PM
> *To:* GeoServer Mailing List List <[email protected]>
> *Subject:* [Geoserver-users] SQL view lost after restarting Tomcat
>
>
>
> Hello list
>
>
>
> I have successfully created the SQL view in Geoserver, I then copied my
> code for the template into the workspace and previewed my layer in
> Geoserver and Openlayers which works fine. Displays the filtered attribute
> accordingly.
>
>
>
> The issue is that after I stop Tomcat and restart it, it throws away the
> SQL view definition and brings a whole list of attribute information for
> the layer.
>
>
>
> I am suspecting this has to do with the code in the content ftl.
>
>
>
> Do I need to define the column headings to be displayed on the client side
> in the content ftl after creating the SQL view? Is there a tutorial that I
> can follow.
>
>
>
> My other Question is one of my layer has photos as attribute. The default
> window is thus small and would like to find out on how to expand it? (I
> would like to do this for now due to limited time and improve on the code
> by implementing the popup afterwards).
>
>
>
> I am running Geoserver 2.13
>
>
>
> Thank you all for your help.
>
>
>
> Kind Regards
>
> Amelia
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
