Hi,
> Thanks Michaël, those buttons are helping a lot when doing queries against
> multimillion row tables. But where is the place to insert SRID into the
> queries?
>
Right,
Forgive this omission (I don't use SRID with our Postgis database).
What do you think if I add the following syntaxes ?
${view}
${view:EPSG}
${fence}
${fence:EPSG}
Michaël
> -Jukka Rahkonen-
>
> Michaël Michaud wrote:
>
>
>> 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
>
>
>
------------------------------------------------------------------------------
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
