Re: [JPP-Devel] Enhancement to Run datatore query

[Stefan S. <ss...@ge...>]

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
>>>> Jum...@li...
>>>> 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
>>> Jum...@li...
>>> 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
>> Jum...@li...
>> 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
> Jum...@li...
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 
>