First time trying this list so please be gentile ;) I am running into an issue when I try to limit a relationship to a specific set of records. Our system appears to recognize the limit in the query and then proceeds to ignore it and pull everything in.
Here is the setup. Relationship source is CI Class Restricted to Dataset LAND.Import Primary Class is BMC_ComputerSystem Secondary Class is BMC_LANEndpoint Relationship Keys: BMC_ComputerSystem.HostName = BMC_LANEndpoint.INL_Hostname Primary Class Query where $TagNumber$ = $function|null()$ Based on a SQL statement I created to see how many records I should get, AIE should only create 250 records. When I run the Data Exchange I end up with over 75,000 relationships. Based on the results it is creating the relationships based solely on the relationship keys and ignoring the primary class query. No errors in any logs either. Any thoughs out there? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
