Hente poster for mange-til-mange-relationer med overlappende objekter
Udgivet: januar 2017
Gælder for: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online
I Microsoft Dynamics 365 og Microsoft Dynamics 365 (online), når der er en mange-til-mange-relation (N:N) mellem to objekter, oprettes der automatisk et overlappende objekt. Dette gælder for både systemrelationer, der er indbygget i produktet, og brugerdefinerede mange til mange-relationer. Navnet på objektet er angivet i IntersectEntityName-egenskaben i relationens metadata. Navnet på relationen er angivet i SchemaName-egenskaben i relationens metadata.
Du kan bruge de overlappende objekter til at indsnævre resultatsættet i en forespørgsel ved hjælp af IOrganizationService.RetrieveMultiple-metoden eller RetrieveMultipleRequest-meddelelsen. Dog kan du ikke hente overlappende objektposter direkte ved hjælp af QueryExpression-klassen. For at hente posterne i et overlappende objekt skal du bruge FetchExpression-klassen.
Dette emne indeholder
Overlappende objekter
Overlappende objekters metadata
Overlappende objekter
I følgende tabel vises de overlappende objekter, der bruges i N: N-relationer mellem standardobjekter.
IntersectEntity |
MtoM_SchemaName |
MtoM_Entity1 |
MtoM_Entity2 |
|---|---|---|---|
accountleads |
accountleads_association |
account |
lead |
campaignactivityitem |
campaignactivitylist_association |
campaignactivity |
list |
campaignactivityitem |
campaignactivitysalesliterature_association |
campaignactivity |
salesliterature |
campaignitem |
campaigncampaign_association |
campaign |
campaign |
campaignitem |
campaignlist_association |
campaign |
list |
campaignitem |
campaignproduct_association |
campaign |
product |
campaignitem |
campaignsalesliterature_association |
campaign |
salesliterature |
competitorproduct |
competitorproduct_association |
competitor |
product |
competitorsalesliterature |
competitorsalesliterature_association |
salesliterature |
competitor |
connectionroleassociation |
connectionroleassociation_association |
connectionrole |
connectionrole |
contactinvoices |
contactinvoices_association |
invoice |
contact |
contactleads |
contactleads_association |
contact |
lead |
contactorders |
contactorders_association |
salesorder |
contact |
contactquotes |
contactquotes_association |
quote |
contact |
entitlementcontacts |
entitlementcontacts_association |
contact |
entitlement |
entitlementproducts |
product_entitlement_association |
product |
entitlement |
entitlementtemplateproducts |
product_entitlementtemplate_association |
product |
entitlementtemplate |
leadcompetitors |
leadcompetitors_association |
lead |
competitor |
leadproduct |
leadproduct_association |
lead |
product |
listmember |
listaccount_association |
list |
account |
listmember |
listcontact_association |
list |
contact |
listmember |
listlead_association |
list |
lead |
opportunitycompetitors |
opportunitycompetitors_association |
opportunity |
competitor |
productassociation |
productassociation_association |
product |
product |
productsalesliterature |
productsalesliterature_association |
product |
salesliterature |
productsubstitute |
productsubstitute_association |
product |
product |
queuemembership |
queuemembership_association |
queue |
systemuser |
roleprivileges |
roleprivileges_association |
privilege |
role |
roletemplateprivileges |
roletemplateprivileges_association |
roletemplate |
privilege |
servicecontractcontacts |
servicecontractcontacts_association |
contact |
contract |
subscriptionmanuallytrackedobject |
contact_subscription_association |
subscription |
contact |
subscriptionmanuallytrackedobject |
task_subscription_association |
subscription |
task |
systemuserprofiles |
systemuserprofiles_association |
systemuser |
fieldsecurityprofile |
systemuserroles |
systemuserroles_association |
systemuser |
role |
teammembership |
teammembership_association |
team |
systemuser |
teamprofiles |
teamprofiles_association |
team |
fieldsecurityprofile |
teamroles |
teamroles_association |
team |
role |
Overlappende objekters metadata
De fleste overlappende objekter er enkle, der kun indeholder nogle få egenskaber, der er nødvendige for at give et link mellem to objekter i N:N-relationen. Hvis du bruger tidligt bundne typer, kan du se et eksempel på det overlappende ContactInvoices-objekt. Dette er tilfældet for alle brugerdefinerede mange til mange-relationer. Der er dog flere overlappende objekter, der har flere egenskaber, der bruges til bestemte funktioner for relationen. For at gøre det lettere at skrive forespørgsler ved hjælp af særlige overlappende objekter findes attributmetadataene i følgende emner:
Se også
Oprette forespørgsler med QueryExpression
Tilpasse metadata til objektrelationer
Hente data med forespørgsler ved hjælp af SDK-assemblyer
CampaignActivityItem intersect entity metadata
CampaignItem intersect entity metadata
ListMember intersect entity metadata
Role Privileges intersect entity metadata
Eksempel: Hente poster fra en overlappende tabel
Microsoft Dynamics 365
© 2017 Microsoft. Alle rettigheder forbeholdes. Ophavsret