[mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Julien Cigar
Hello, I'm using Mapserver 6.0.1 with the following PostGIS layer: http://pastie.org/private/84042k84vmljbontls5xvq The user has the possibility to select quite a lot of filters, which implies that the SQL query should, in theory ,be generated dynamically. As this is not possible with

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Rahkonen Jukka
Hi, So you have tried to define variables %SEX% and %BOD_ID%, used them inside your DATA and then fired WMS GetMaps by adding SEX=your_valueBOD_ID=your_id? Does in not work or why it is not powerful enough? -Jukka Rahkonen- Julien Cigar wrote: Hello, I'm using Mapserver 6.0.1 with the

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Smith, Michael ERDC-RDE-CRREL-NH
At the SQL level, you can do some fancy work with CASE and setting some default values The CASE function allows you to set all kind of logical comparisons. You can do conditional joins that way, setting the join condition to a non matching value when you don't want the join, etc. SQL is more

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Rahkonen Jukka
And perhaps, if you would like to do something very tricky, you could create a function or stored procedure into your database and call that from DATA with the dynamic variables? The compute_style thing in this thread suggests that it might work

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Julien Cigar
On 09/21/2012 13:30, Rahkonen Jukka wrote: And perhaps, if you would like to do something very tricky, you could create a function or stored procedure into your database and call that from DATA with the dynamic variables? The compute_style thing in this thread suggests that it might work

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Julien Cigar
On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote: At the SQL level, you can do some fancy work with CASE and setting some default values The CASE function allows you to set all kind of logical comparisons. You can do conditional joins that way, setting the join condition to a non

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Julien Cigar
On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote: At the SQL level, you can do some fancy work with CASE and setting some default values The CASE function allows you to set all kind of logical comparisons. You can do conditional joins that way, setting the join condition to a non

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Smith, Michael ERDC-RDE-CRREL-NH
I think that¹s correct for ansi syntax Mike On 9/21/12 8:13 AM, Julien Cigar jci...@ulb.ac.be wrote: On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote: At the SQL level, you can do some fancy work with CASE and setting some default values The CASE function allows you to set all

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Julien Cigar
On 09/21/2012 14:22, Smith, Michael ERDC-RDE-CRREL-NH wrote: What I've done is have the join in the sql but either join it to the correct join column or join it to a null match (and make it an outer join). I typically use oracle syntax and not ansi syntax but the trick is to have all the table