Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
New Member
jtorrsc
Posts: 1
Registered: ‎01-17-2011
Message 1 of 3 (306 Views)

Filtering Joined Data

306 Views, 2 Replies
01-17-2011 01:36 PM

I am trying to theme a layer based on a join between a SQL table via DSN and an sdf. I only want to return results where a uniqe ID field is equal to 9 as the SQL table consists of thousands of records that are irrelevant to this particular thematic. However when I try to apply a filter to the property which is an int32, i get an error message saying, "An exception occured in FDO component. Property 'CommunityID' is not found. I can't seem to get the filter to work for any of the fields in the SQL table. Any help?

 

Thanks,

 

Jaime

Contributor
SethStark
Posts: 12
Registered: ‎11-13-2008
Message 2 of 3 (250 Views)

Re: Filtering Joined Data

02-11-2011 11:19 AM in reply to: jtorrsc

Don't know if you found a solution to this yet, we are experiencing a similar issue.

 

please let me know if you found a solution or if anyone knows. thank you!

Valued Mentor
gluckett
Posts: 414
Registered: ‎10-10-2003
Message 3 of 3 (174 Views)

Re: Filtering Joined Data

03-11-2011 07:09 AM in reply to: SethStark

I have had similar issues, I usually have to create a view in SQL Server to remove the offending Fields that are causing the issue and join my data to that new view to work around it.

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!