[MapServer-users] Postgres DATA query with LIMIT 10 does not work

[Jörg Thomsen (WhereGroup)]

Hello Marcin,

sounds stupid, but are you sure the 10 datasets have geometries within 
the requested bbox? I don't see any other problem/mistakes.

Jörg



Am 19.10.23 um 11:39 schrieb Marcin Niemyjski via MapServer-users:
> Hello,
> 
> 
> I encountered a problem, specifically:
> 
> This query works:
> 
> |DATA 'geometry from (select * from mrc order by maxcc desc) as subquery 
> using unique unique_id' |
> 
> However, this query doesn't work:
> 
> |DATA 'geometry from (select * from mrc order by maxcc desc limit 10) as 
> subquery using unique unique_id' |
> 
> Here's the full tileindex definition:
> 
> |LAYER  DEBUG 5  STATUS OFF  NAME "time_idx"  TYPE POLYGON 
>   CONNECTIONTYPE postgis  CONNECTION "***"  DATA 'geometry from (select 
> * from mrc order by maxcc desc limit 10) as subquery using unique 
> unique_id'  PROJECTION    "init=epsg:3857"  END  VALIDATION     'maxCC' 
> '^[0-9]{1,3}$'     'default_maxCC' '100'  END  METADATA    "wms_title" 
> "tile-index-cloud"    "wms_timeextent" "2022-02-01/2023-10-10/P1D"   
>   "wms_timeitem" "timestamp"    "wms_timedefault" "2023-10-10"   
>   "wms_enable_request" "!*"  END END |
> 
> My MapServer version is 7.6.4.
> 
> The query results (but returns data in Postgres
> ) in an empty window. I'm following the guidelines provided at 
> https://mapserver.org/input/vector/postgis.html#data-access-connection-method <https://mapserver.org/input/vector/postgis.html#data-access-connection-method>.
> 
> 
> Best,
> marcin
> 
> <https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&ep=signature> 		Book time to meet with me <https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&ep=signature> 	
> 
> 
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users


-- 
Viele Grüße,
Jörg Thomsen
---------------------------------------------
Aufwind durch Wissen!
Web-Seminare und Online-Schulungen
bei der www.foss-academy.com
---------------------------------------------


Jörg Thomsen
WhereGroup GmbH
Bundesallee 23
10717 Berlin
Germany

Tel: +49 (0)30 / 5130 278 74
Fax: +49 (0)30 / 5130 278 11	

joerg.thomsen at wheregroup.com
www.wheregroup.com

Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885

-------------------------------
Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com