Infrastructure Map Server General Discussion

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

Filtering Joined Data

304 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 (248 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: 373
Registered: ‎10-10-2003
Message 3 of 3 (172 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.

 

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