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