[mapguide-users] Case insensitive filter with search

[Kenneth, GEOGRAF A/S]

One way of dealing with it would be to apply the lower() function in PHP 
to the $USER_VARIABLE, and use that as the "Left operand".

Regards, Kenneth, GEOGRAF A/S



Ismael Cams skrev:
> Hello,
>
> is there any way to make the search tool (and in global the FDO filter) case
> insensitive. I have tried with Lower("ZONE") LIKE Lower('$USER_VARIABLE%')
> but it throws an MgUnclassified error and when using Studio to build the
> expression it says it is not allowed to have expressions in the left
> operand. But I do not see any other possibility to make the filter case
> insensitive ...
>
> Could someone help me with this issue (remark: I encountered this issue on
> MapGuide Enterprise 2008, maybe this in meanwhile has been solved in the
> latest MGOS ?).
>
> Kind regards,
> Ismaël
>