[mapserver-users] RE Dynamically extent and layer filter

[Dedy Fuadi]

Wow! Thank you very much Steven!

Finally I can display custom data from postgis with your links before.
I set like this for the mapfile :
VALIDATION

'tid' '^[0-9]{1}\,'

END
FILTER (id in (%tid%))

And this is nicely work for me. :D

Thank you,
regards.


On Sat, May 31, 2014 at 12:30 AM, <Steve.Toutant at inspq.qc.ca> wrote:

>
> Begin with a simple validation until it works.  Is it working if you set
> VALIDATION
>         id '.*'
> END
>
> If yes then the problem is in your regex. Make sure that ',' are accepted.
> If not the problem is the FILTER or the parameter you pass.
>
> Also Is your ID an integer or text in postgis? I think it matters.
> ('%id%') this would send a string to pg. In this case try FILTER  "id" in
> ('%id%'), otherwise try
> FILTER  id in (%id%)
>
> It is not an easy task (in my opinion) in mapserv to use expresion and
> filter
> But have a look at this. there are several examples
>
> http://mapserver.org/fr/mapfile/expressions.html#string-expressions-that-return-a-logical-value
>
> Also in you MAPFILE set  debug 5 in the MAP block, and also in your layer
> block. You will have more info in your mapserver log.
> steve
>
>
>
>
>  *Dedy Fuadi <sampahe.fb3 at gmail.com <sampahe.fb3 at gmail.com>>*
>
> 2014-05-30 12:17
>   A
> Steve.Toutant at inspq.qc.ca
> cc
> mapserver-users at lists.osgeo.org
> Objet
> Re: RE [mapserver-users] Dynamically extent and layer filter
>
>
>
>
>
>
> This is my mapfile part :
> VALIDATION
> 'id' '^[0-9]{1}$'
> END
> FILTER  (id in ('%id%'))
>
> and as your advice I set URL parameter like &id=1,4,8 but the map is not
> appears there.
>
> When I opened debug, I found :
> [Sat May 31 00:10:34 2014].758000 msEvalRegex(): Regular expression
> error. String failed expression test.
> [Sat May 31 00:10:34 2014].758000 loadForm(): Web application error.
> Parameter 'id' value fails to validate.
>
>
> On Fri, May 30, 2014 at 11:42 PM, <*Steve.Toutant at inspq.qc.ca*
> <Steve.Toutant at inspq.qc.ca>> wrote:
>
> In your mapfile you could set FILTER "id in (%ID%)" .
> And in the url pass a string as parameter such as &id=1,4,8
> That would be a simple way
>
> Please post further question on mapserver list, so others can answer you,
> and the answers can help other people later
> thanks
> steve
>
>
>
>   *Dedy Fuadi <**sampahe.fb3 at gmail.com* <sampahe.fb3 at gmail.com>*>*
>
> 2014-05-30 11:28
>
>   A
> *Steve.Toutant at inspq.qc.ca* <Steve.Toutant at inspq.qc.ca>
> cc
>   Objet
> Re: RE [mapserver-users] Dynamically extent and layer filter
>
>
>
>
>
>
>
>
> Hi Steve,
>
> Your advice is nicely work for me! :D
>
> But how to select more than one data from postgis by VALIDATION block? For
> example, I have a postgis table that have 20 data, then I wanto to select
> data 1,4,8, or else to display by customizing URL parameter. I set '%id%'
> as my variable at mapfile, I just can display one data like &id=1.
>
> Please for your help.
> Thank you.
>
>
> On Fri, May 30, 2014 at 8:30 PM, <*Steve.Toutant at inspq.qc.ca*
> <Steve.Toutant at inspq.qc.ca>> wrote:
>
> Hi
> What did you try and what happened? Something in the mapserver log.
> If I understand well you want to use run time substitution, if so here a
> link
> *http://mapserver.org/cgi/runsub.html*
> <http://mapserver.org/cgi/runsub.html>
>
> Make sure you have a VALIDATION block
> Steve
>
>   *Dedy Fuadi <**sampahe.fb3 at gmail.com* <sampahe.fb3 at gmail.com>*>@*
> *lists.osgeo.org* <http://lists.osgeo.org/>
> Envoyé par : *mapserver-users-bounces at lists.osgeo.org*
> <mapserver-users-bounces at lists.osgeo.org>
>
> 2014-05-30 06:52
>
>   A
> *mapserver-users at lists.osgeo.org* <mapserver-users at lists.osgeo.org>
> cc
>   Objet
> [mapserver-users] Dynamically extent and layer filter
>
>
>
>
>
>
>
>
>
>
> Hello friends,
>
> I just success applying filter data for postgis database on my mapfile,
> but I met problem when I was to try use dynamic variable for filter data
> and extent map like variable at php file.
>
> What should I do for solving this problem? Whether mapfile can be a
> dynamically file like php?
>
> Thank you,
> regards._______________________________________________
> mapserver-users mailing list
> *mapserver-users at lists.osgeo.org* <mapserver-users at lists.osgeo.org>
> *http://lists.osgeo.org/mailman/listinfo/mapserver-users*
> <http://lists.osgeo.org/mailman/listinfo/mapserver-users>
>
>
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140531/d0f89c27/attachment-0001.html>