Hi,
Finally, I followed Paolo's advice and added two parameters ala ant
Those two parameters are
${view}
${fence}
Instead of writing them, one can use a button I added on the right of
the panel (a nice icon would be better...)
It is not as user friendly as a checkbox, but I think it will be more
flexible.
For now on, it only works with postgis (ST_GeomFromText function is used
in the substitution)
Don't know how to adapt it for other database : is ST_GeomFromText
recognized by other spatial db ?
Here is an example for a fast query inside the view :
select asbinary(the_geom) from mytable t
where t.the_geom && ${fence}
Michaël
Paolo Rizzi a écrit :
> 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
>
>
>
------------------------------------------------------------------------------
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
