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

2009-11-23 Thread Rahkonen Jukka
Michaël Michaud wrote: > 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 thi

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 ?

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 pa

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

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

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

2009-11-11 Thread Rahkonen Jukka
mFromText('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:m

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 && {OJ.view.current.geom} and intersects(,{OJ.view.current.geom}) OpenJump should substitute the string "{OJ.view.current.geom}" with th

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 com

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 quer

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