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
https://aka.ms/ContentUserFeedback.
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, consultezEnvoyer et afficher des commentaires pour