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

2009-11-23 Thread Rahkonen Jukka 
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
  Jump-pilot-devel@lists.sourceforge.net
  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
  Jump-pilot-devel@lists.sourceforge.net
  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
  Jump-pilot-devel@lists.sourceforge.net
  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
 Jump-pilot-devel@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

2009-11-23 Thread Michaël Michaud 
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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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

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

2009-11-22 Thread Michaël Michaud 
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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

2009-11-22 Thread Stefan Steiniger 
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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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.

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

2009-11-11 Thread Michaël Michaud 
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
 Jump-pilot-devel@lists.sourceforge.net
 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
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

2009-11-11 Thread Paolo Rizzi 
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
 Jump-pilot-devel@lists.sourceforge.net
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

2009-11-11 Thread Rahkonen Jukka 
Hi,

I was thinking about the basic fill the screen query. This is the minimum 
bbox query which works for me:

SELECT AsBinary(way) FROM osm_line WHERE way  SetSRID('BOX3D(3602438.0 
7016321.0,3604342.0 7017928.0)'::box3d,2393)

User should build the main query
SELECT AsBinary(way) FROM osm_line

OpenJUMP should add BBOX filtering part:
WHERE way  SetSRID('BOX3D(3602438.0 7016321.0,3604342.0 
7017928.0)'::box3d,2393)

If query contains WHERE set by user it should be naturally
AND way  SetSRID('BOX3D(3602438.0 7016321.0,3604342.0 7017928.0)'::box3d,2393)

-  SetSRID('BOX3D()'::box3d,) is always the same
- BOX3D values should come from map window.  
- Name of the geometry column (here way is harder; would it be reliable to 
believe that it is the column name used in AsBinary(), or should the user give 
it through user interface?
- Same with the projection (here 2393); OJ has a function Change projection 
code under the Layers menu, it could be taken from there, or user could give 
it.

Of course the query could be made better, for example by adding AND 
intersects if it is important to avoid extra features which may be returned by 
bounding box comparison.  Another idea fascinating me would be to use the 
geometry of one selected feature for building the query
SELECT ID, NAME FROM ROADS_GEOM WHERE GEOM 
GeomFromText('POLYGON((191232 243117,191232 243119,191234
243117,191232 243117))',-1);

User would select or draw a polygon with OJ and ask database to fill the area 
with intersecting features.

-Jukka Rahkonen-






-Alkuperäinen viesti-
Lähettäjä: Michaël Michaud [mailto:michael.mich...@free.fr]
Lähetetty: ke 11.11.2009 13:50
Vastaanottaja: OpenJump develop and use
Aihe: Re: [JPP-Devel] Enhancement to Run datatore query
 
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
 Jump-pilot-devel@lists.sourceforge.net
 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
Jump-pilot-devel@lists.sourceforge.net
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
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] Enhancement to Run datatore query

2009-11-10 Thread Rahkonen Jukka 
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
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

2009-11-10 Thread Stefan Steiniger 
Hei Jukka,

what would that checkbox exacty do?

stefan

Rahkonen Jukka schrieb:
 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
 Jump-pilot-devel@lists.sourceforge.net
 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
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel