Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
New Member
1 Posts
0 Kudos
Registered: ‎01-17-2011
Post 1 of 3

Filtering Joined Data

307 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
12 Posts
0 Kudos
Registered: ‎11-13-2008
Post 2 of 3

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
434 Posts
74 Kudos
Registered: ‎10-10-2003
Post 3 of 3

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