• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Autodesk MapGuide Enterprise

    Reply
    Contributor
    Posts: 14
    Registered: ‎10-04-2006

    Filter case sensitive

    47 Views, 3 Replies
    10-02-2007 07:59 AM
    Hi,
    I'm trying to create a search tool in the studio on a shapefile and sdf where all the content are uppercase. I was thinking that the operator LIKE was supposed to do the job, but it seems that no!

    Is somebody know was is exactly the function to do that. I've tried Upper() but not working.
    Thanks
    Please use plain text.
    Employee
    Posts: 727
    Registered: ‎09-14-2006

    Re: Filter case sensitive

    10-09-2007 09:13 AM in reply to: pmarseil
    Upper should be the correct function.

    The expression in the advanced expression builder should look something like:

    "PropertyName" LIKE Upper('%$USER_VARIABLE%')

    Note I added wildcards to both sides of the expression. There is also a bug such that this doesn't appear to work with Extended characters such as é found in non-english languages.

    Regards,
    Dave


    Dave Wilson
    SQA Analyst
    AEC IM
    Autodesk, Inc.

    Please use plain text.
    Contributor
    Posts: 14
    Registered: ‎10-04-2006

    Re: Filter case sensitive

    10-09-2007 01:43 PM in reply to: pmarseil
    Thanks Dave,
    The problem was my upper synthax. Now it' work great.
    Can you tell me in wich language are the expression builder?

    Thanks again
    Please use plain text.
    Employee
    Posts: 727
    Registered: ‎09-14-2006

    Re: Filter case sensitive

    10-09-2007 02:02 PM in reply to: pmarseil
    I don't think the expression is in any formal language syntax. It's FDO syntax as far as I know.

    Dave


    Dave Wilson
    SQA Analyst
    AEC IM
    Autodesk, Inc.

    Please use plain text.