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

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

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

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

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