Référence d’entité/de table makerfewshot
Notes
Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.
This fewshot is updated by maker for testing the queries and by the NL2SQ with the results
Ajouté par : solution msdyn_RelevanceSearch
Messages
| Message | Opération de l'API web | Classe ou méthode SDK |
|---|---|---|
| BulkRetain | BulkRetain Action | <xref:Microsoft.Crm.Sdk.Messages.BulkRetainRequest> |
| Create | POST [org URI]/api/data/v9.0/makerfewshots Voir Créer |
CreateRequest ou Create |
| CreateMultiple | CreateMultiple Action | CreateMultipleRequest |
| Delete | DELETE [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Voir Supprimer |
DeleteRequest ou Delete |
| IsValidStateTransition | IsValidStateTransition Function | IsValidStateTransitionRequest |
| PurgeRetainedContent | PurgeRetainedContent Action | <xref:Microsoft.Crm.Sdk.Messages.PurgeRetainedContentRequest> |
| Restore | Restore Action | <xref:Microsoft.Crm.Sdk.Messages.RestoreRequest> |
| Retain | Retain Action | <xref:Microsoft.Crm.Sdk.Messages.RetainRequest> |
| Retrieve | GET [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Voir Récupérer |
RetrieveRequest ou Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/makerfewshots Voir Rechercher des données |
RetrieveMultipleRequest ou RetrieveMultiple |
| RollbackRetain | RollbackRetain Action | <xref:Microsoft.Crm.Sdk.Messages.RollbackRetainRequest> |
| SetState | PATCH [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Mettre à jour les propriétés statecode et statuscode. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Voir Mettre à jour |
UpdateRequest ou Update |
| UpdateMultiple | UpdateMultiple Action | UpdateMultipleRequest |
| ValidateRetentionConfig | ValidateRetentionConfig Action | <xref:Microsoft.Crm.Sdk.Messages.ValidateRetentionConfigRequest> |
Propriétés
| Propriété | Valeur |
|---|---|
| CollectionSchemaName | makerfewshots |
| DisplayCollectionName | MakerFewShot |
| DisplayName | MakerFewShot |
| EntitySetName | makerfewshots |
| IsBPFEntity | False |
| LogicalCollectionName | makerfewshots |
| LogicalName | makerfewshot |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | makerfewshotid |
| PrimaryNameAttribute | query |
| SchemaName | makerfewshot |
Colonnes/Attributs inscriptibles
Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.
- Comment
- EntityScope
- EntityScopeColumn
- ImportSequenceNumber
- makerfewshotId
- OverriddenCreatedOn
- Query
- Rephrase
- SQLCorrectness
- StandardSQL
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
Comment
| Propriété | Valeur |
|---|---|
| Description | Explanation of the query. |
| DisplayName | Comment |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | comment |
| MaxLength | 20000 |
| RequiredLevel | ApplicationRequired |
| Type | Memo |
EntityScope
| Propriété | Valeur |
|---|---|
| Description | EntityScope that can be used to extract results. Format: [entityscopeA], [entityscopeB] |
| DisplayName | EntityScope |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | entityscope |
| MaxLength | 20000 |
| RequiredLevel | ApplicationRequired |
| Type | Memo |
EntityScopeColumn
| Propriété | Valeur |
|---|---|
| Description | EntityScopeColumn within the EntityScope specified above.Format: [EntityScopeA].[EntityScopeColumnA1], [EntityScopeB].[EntityScopeColumnB2] |
| DisplayName | EntityScopeColumn |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | entityscopecolumn |
| MaxLength | 20000 |
| RequiredLevel | None |
| Type | Memo |
ImportSequenceNumber
| Propriété | Valeur |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
makerfewshotId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier for entity instances |
| DisplayName | MakerFewShotId |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | makerfewshotid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
OverriddenCreatedOn
| Propriété | Valeur |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
Query
| Propriété | Valeur |
|---|---|
| Description | Natural language question. |
| DisplayName | Query |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | query |
| MaxLength | 4000 |
| RequiredLevel | ApplicationRequired |
| Type | String |
Rephrase
| Propriété | Valeur |
|---|---|
| Description | Rephrase generated by NL2SQ. |
| DisplayName | Rephrase |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | rephrase |
| MaxLength | 20000 |
| RequiredLevel | None |
| Type | Memo |
SQLCorrectness
| Propriété | Valeur |
|---|---|
| Description | Feedback by the maker after they validate the standard sql. |
| DisplayName | SQL Correctness |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sqlcorrectness |
| RequiredLevel | SystemRequired |
| Type | Picklist |
Choix/Options SQLCorrectness
| Valeur | Étiquette | Description |
|---|---|---|
| 0 | Pending Validation | |
| 1 | Valid | |
| 2 | Invalid | |
| 3 | NotSure |
StandardSQL
| Propriété | Valeur |
|---|---|
| Description | SQL generated by NL2SQ based on the query and fewshots of maker. |
| DisplayName | Standard SQL |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | standardsql |
| MaxLength | 20000 |
| RequiredLevel | None |
| Type | Memo |
statecode
| Propriété | Valeur |
|---|---|
| Description | Status of the makerfewshot |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
Choix/Options statecode
| Valeur | Étiquette | Statut par défaut | Nom invariant |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
statuscode
| Propriété | Valeur |
|---|---|
| Description | Reason for the status of the makerfewshot |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
Choix/Options statuscode
| Valeur | Étiquette | État |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
TimeZoneRuleVersionNumber
| Propriété | Valeur |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
UTCConversionTimeZoneCode
| Propriété | Valeur |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
Colonnes/Attributs en lecture seule
Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- VersionNumber
CreatedBy
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the user who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
CreatedOn
| Propriété | Valeur |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the delegate user who created the record. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedBy
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the user who modified the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedOn
| Propriété | Valeur |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the delegate user who modified the record. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OrganizationId
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | Unique identifier for the organization |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | None |
| Targets | organization |
| Type | Lookup |
OrganizationIdName
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
VersionNumber
Ajouté par : solution Active Solution
| Propriété | Valeur |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relations un-à-plusieurs
Répertorié par SchemaName.
- makerfewshot_SyncErrors
- makerfewshot_AsyncOperations
- makerfewshot_MailboxTrackingFolders
- makerfewshot_ProcessSession
- makerfewshot_BulkDeleteFailures
- makerfewshot_PrincipalObjectAttributeAccesses
makerfewshot_SyncErrors
Ajouté par : solution System Solution
Identique à la relation plusieurs à un makerfewshot_SyncErrors pour la table/entité syncerror.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | makerfewshot_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
makerfewshot_AsyncOperations
Ajouté par : solution System Solution
Identique à la relation plusieurs à un makerfewshot_AsyncOperations pour la table/entité asyncoperation.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | makerfewshot_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
makerfewshot_MailboxTrackingFolders
Ajouté par : solution System Solution
Identique à la relation plusieurs à un makerfewshot_MailboxTrackingFolders pour la table/entité mailboxtrackingfolder.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | makerfewshot_MailboxTrackingFolders |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
makerfewshot_ProcessSession
Ajouté par : solution System Solution
Identique à la relation plusieurs à un makerfewshot_ProcessSession pour la table/entité processsession.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | makerfewshot_ProcessSession |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
makerfewshot_BulkDeleteFailures
Ajouté par : solution System Solution
Identique à la relation plusieurs à un makerfewshot_BulkDeleteFailures pour la table/entité bulkdeletefailure.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | makerfewshot_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
makerfewshot_PrincipalObjectAttributeAccesses
Ajouté par : solution System Solution
Identique à la relation plusieurs à un makerfewshot_PrincipalObjectAttributeAccesses pour la table/entité principalobjectattributeaccess.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | makerfewshot_PrincipalObjectAttributeAccesses |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Relations plusieurs-à-un
Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.
- lk_makerfewshot_createdby
- lk_makerfewshot_createdonbehalfby
- lk_makerfewshot_modifiedby
- lk_makerfewshot_modifiedonbehalfby
- organization_makerfewshot
lk_makerfewshot_createdby
Ajouté par : solution System Solution
Voir la relation un à plusieurs lk_makerfewshot_createdby pour la table/entité systemuser.
lk_makerfewshot_createdonbehalfby
Ajouté par : solution System Solution
Voir la relation un à plusieurs lk_makerfewshot_createdonbehalfby pour la table/entité systemuser.
lk_makerfewshot_modifiedby
Ajouté par : solution System Solution
Voir la relation un à plusieurs lk_makerfewshot_modifiedby pour la table/entité systemuser.
lk_makerfewshot_modifiedonbehalfby
Ajouté par : solution System Solution
Voir la relation un à plusieurs lk_makerfewshot_modifiedonbehalfby pour la table/entité systemuser.
organization_makerfewshot
Ajouté par : solution System Solution
Voir la relation un à plusieurs organization_makerfewshot pour la table/entité organization.
Voir aussi
Référence d’entité/de table Dataverse Référence d’API web makerfewshot EntityType
Commentaires
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultez https://aka.ms/ContentUserFeedback.
Envoyer et afficher des commentaires pour