WebGIS Discussions

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Occasional Contributor
Posts: 12
Registered: ‎01-03-2018

Advanced Analysis UPPER case problem

[ Edited ]

I'm having a huge problem using the advanced Analysis.


I reproduced the error at hexagon WebGis Demo Portal, very easily:


Gone to Analysis and did a Advanced Query (Used US Cities - GS_DATA.CITIES): 


CITY_NAME = UPPER('Boston, Ma')


The result is that result data appears at DataWindow correctly, but does not appears in the map...


Analysis UPPER case.PNG


But if I repeat the Analysis Query, WITHOUT the UPPER case:


Analysis equals case.PNG


It Works perfectly! 

In our local environment, we could see an Error in the WebMap Log trying to process the request with the UPPER SQL.


If my explain does not help you to reproduce the error, please contact me.

Technical Evangelist
Posts: 535
Registered: ‎09-11-2015

Re: Advanced Analysis UPPER case problem

I have veryfied the problem. Can you please create a support ticket on this, so that we can proceed further?


Thanks, Pavel

Occasional Contributor
Posts: 12
Registered: ‎01-03-2018

Re: Advanced Analysis UPPER case problem

Sure, i will create the ticket (i'm quite newbie in Hexagon and still do not know all the process and forms)

I will ask Josep or Martí how to create this ticket on monday.


Thank you in advance.