Infrastructure Map Server General Discussion

Reply
Valued Contributor
pg002a
Posts: 58
Registered: ‎08-03-2010
Message 1 of 3 (241 Views)

What Expression function to use?

241 Views, 2 Replies
04-20-2012 07:48 AM

HI

I messing around how to create expression filter for address search. I want to create address search for data which come from  database column where are whole address like "Tallinn st 100" st means street.  I dont want to input "st" in search widget, only street and house number like inpu only "Tallinn 100". Does I have to make new "house nr" and "street name"columns in database or it is possible to do it with Studio, like converting text to be without some character(my case without "st"). I read Studio help for expressions but didnt figured out what kind of function to use.

 

Mentor
tjmapper
Posts: 229
Registered: ‎03-25-2008
Message 2 of 3 (231 Views)

Re: What Expression function to use?

04-23-2012 09:25 AM in reply to: pg002a

If your address had the house number first it would make things less complicated because they could just search for "100 Tree" and get back "100 Tree St, 100 Tree Rd, 100 Tree Dr, etc" if you used the expression:

 

"ADDRESS LIKE '%$USER_VARIABLE%'"

 

but you can also have the user enter the % into the search and it will do the same. So they could enter "Tallinn % 100" and it should work.

Valued Contributor
pg002a
Posts: 58
Registered: ‎08-03-2010
Message 3 of 3 (226 Views)

Re: What Expression function to use?

04-23-2012 11:47 AM in reply to: tjmapper

Adding % character before and after user variable I already know, I just thought that there is other way to do it using some conversion function. I want to create user friendly search function so user dont need to use any %.

 

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community