I think the geom column name can be anything, but something ala
"Apache ant" parameter substitution could be a good idea, like:
select * from (userquery)
where <whatever_the_geom_is> && {OJ.view.current.geom}
and intersects(<whatever_the_geom_is>,{OJ.view.current.geom})
OpenJump should substitute the string "{OJ.view.current.geom}" with the
current bbox.geometry of the view.
Other well-known parameters may be useful, like...??? Can't think of
anyone right now!!!
Another improvement would be for Layers coming from a "Run datastore
query" to have the "Refresh" menu' command like "Add datastore" Layers have.
Also "Run Datastore" Layers should be saved inside OJ Task/Project, so
you don't have to manually reenter them each time.
Bye
Paolo Rizzi
> 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
------------------------------------------------------------------------------
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
