Hexagon Geospatial
MENU

M.App Enterprise

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Staff
Posts: 101
Registered: ‎01-15-2016

SQL Queries and Results

Dears,

 

I'm trying to explore all functionalities in M.App Enterprise and I confess that I'm having a little problem :-(   But, it's ok! I would like to share these points.

 

Anybody have test SQL Queries?

 

 

Question #1:

 

I'm trying to construct the example:

 

SELECT id, cod_distri, sigla_dist, nome_distr FROM districts_sp WHERE nome_distr LIKE {ENTITY.%Name_District%}.

 

The above select is the same that I've using in SmartClient. But in M.App Enterprise don't Accept % %. The message that appears is "The given key was not present in the dictionary".

 

Anybody knows what's the problem?

 

Question #2:

 

If I use a simple Select (SELECT id, cod_distri, sigla_dist, nome_distr FROM districts_sp WHERE nome_distr = {ENTITY.Name_District}) it's ok! But, something strange is happening to present the DataGrid.

 

If the select return some registers, it's ok. But if is necessary to return many registers I can't see the DataGrid. Please see the images below.

 

DataGrid_1.png

 

DataGrid_2.png

Regular Contributor
Posts: 246
Registered: ‎10-26-2015

Re: SQL Queries and Results

I am also experiencing the same issue raised by Wolmar under question 1 for a query I'm copying across from GMSC 2016.

Regular Contributor
Posts: 247
Registered: ‎03-10-2016

Re: SQL Queries and Results

Hi Wolmar,

 

do you have any updates to your question #1?

 

Regards

Stefan

GAUSS Ingenieurtechnik GmbH | Germany
Technical Evangelist
Posts: 178
Registered: ‎03-03-2016

Re: SQL Queries and Results

Ad question 1:

Can you confirm that you only get the error in Studio by testing the query? The acutal query in the Desktop Client should work fine. Is that correct?

Regular Contributor
Posts: 247
Registered: ‎03-10-2016

Re: SQL Queries and Results

OK, I tried it in desktop client and it worked fine!

 

Thanks!

GAUSS Ingenieurtechnik GmbH | Germany
Technical Evangelist
Posts: 178
Registered: ‎03-03-2016

Re: SQL Queries and Results

The test query issue seems to be a bug ... I'll add it to our backlog.

Staff
Posts: 101
Registered: ‎01-15-2016

Re: SQL Queries and Results

Thanks for your answer and if it's possible, please, keep us informed about it.

 

Regards,

Wolmar

 

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Development Ticket through our Development Ticket Portal.