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?
-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
