Hi,

I use "Run datastore query panel " a lot and your suggestion seems very 
useful to me.

I'll try to dive into the code to see if I can add this feature, but it 
may be difficult to manage every case in a clean way (because the 
geometry column name is not fixed and because the query may be complex, 
with where conditions, joins, group by...).

I think one approach could be to identify the geometry column 
(asbinary() or asewkb()), to create an alias
ex. asbinary(geomcolumn) as GEOMETRY4OJ
then to create a new query like
select * from (userquery) where GEOMETRY4OJ && bbox.geometry and 
intersects(GEOMETRY4OJ,bbox.geometry)
not sure if it works

any idea ?

Michaël

Rahkonen Jukka a écrit :
> Hi,
>
> While playing with SkyJUMP and pdf printing which does not work with Add 
> datastore layer I soon realised that I would like to see a "Use view extents 
> as BBOX filter" check box in the Run datastore query panel.
>
> -Jukka Rahkonen-
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Jump-pilot-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
>   


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to