nice!
thanks for putting in the effort
cheers from C
stefan
Michaël Michaud schrieb:
> 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
>
>
------------------------------------------------------------------------------
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
