Autodesk MapGuide Enterprise
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Filter case sensitive
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
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
Re: Filter case sensitive
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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.
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.
Re: Filter case sensitive
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
The problem was my upper synthax. Now it' work great.
Can you tell me in wich language are the expression builder?
Thanks again
Re: Filter case sensitive
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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.
Dave

Dave Wilson
SQA Analyst
AEC IM
Autodesk, Inc.
