Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

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

What Expression function to use?

248 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 (238 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 (233 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 %.

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.