Referencia de tabla o entidad makerfewshot
Nota
¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.
This fewshot is updated by maker for testing the queries and by the NL2SQ with the results
Añadido por: solución msdyn_RelevanceSearch
Mensajes
| Mensaje | Operación de API web | Método o clase de SDK |
|---|---|---|
| BulkRetain | BulkRetain Action | <xref:Microsoft.Crm.Sdk.Messages.BulkRetainRequest> |
| Create | POST [org URI]/api/data/v9.0/makerfewshots Vea Crear |
CreateRequest o Create |
| CreateMultiple | CreateMultiple Action | CreateMultipleRequest |
| Delete | DELETE [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Vea Eliminar |
DeleteRequest o 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) Vea Recuperar |
RetrieveRequest o Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/makerfewshots Vea Consultar datos |
RetrieveMultipleRequest o RetrieveMultiple |
| RollbackRetain | RollbackRetain Action | <xref:Microsoft.Crm.Sdk.Messages.RollbackRetainRequest> |
| SetState | PATCH [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Actualizar propiedades statecode y statuscode. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/makerfewshots(makerfewshotid) Vea Actualizar |
UpdateRequest o Update |
| UpdateMultiple | UpdateMultiple Action | UpdateMultipleRequest |
| ValidateRetentionConfig | ValidateRetentionConfig Action | <xref:Microsoft.Crm.Sdk.Messages.ValidateRetentionConfigRequest> |
Propiedades
| Propiedad | Valor |
|---|---|
| CollectionSchemaName | makerfewshots |
| DisplayCollectionName | MakerFewShot |
| DisplayName | MakerFewShot |
| EntitySetName | makerfewshots |
| IsBPFEntity | False |
| LogicalCollectionName | makerfewshots |
| LogicalName | makerfewshot |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | makerfewshotid |
| PrimaryNameAttribute | query |
| SchemaName | makerfewshot |
Columnas/atributos que se pueden escribir
Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.
- Comment
- EntityScope
- EntityScopeColumn
- ImportSequenceNumber
- makerfewshotId
- OverriddenCreatedOn
- Query
- Rephrase
- SQLCorrectness
- StandardSQL
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
Comment
| Propiedad | Valor |
|---|---|
| Description | Explanation of the query. |
| DisplayName | Comment |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | comment |
| MaxLength | 20000 |
| RequiredLevel | ApplicationRequired |
| Type | Memo |
EntityScope
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | Unique identifier for entity instances |
| DisplayName | MakerFewShotId |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | makerfewshotid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
OverriddenCreatedOn
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | Natural language question. |
| DisplayName | Query |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | query |
| MaxLength | 4000 |
| RequiredLevel | ApplicationRequired |
| Type | String |
Rephrase
| Propiedad | Valor |
|---|---|
| Description | Rephrase generated by NL2SQ. |
| DisplayName | Rephrase |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | rephrase |
| MaxLength | 20000 |
| RequiredLevel | None |
| Type | Memo |
SQLCorrectness
| Propiedad | Valor |
|---|---|
| Description | Feedback by the maker after they validate the standard sql. |
| DisplayName | SQL Correctness |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sqlcorrectness |
| RequiredLevel | SystemRequired |
| Type | Picklist |
Elecciones/opciones de SQLCorrectness
| Valor | Etiqueta | Descripción |
|---|---|---|
| 0 | Pending Validation | |
| 1 | Valid | |
| 2 | Invalid | |
| 3 | NotSure |
StandardSQL
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | Status of the makerfewshot |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
Elecciones/opciones de statecode
| Valor | Etiqueta | Estado predeterminado | Nombre invariable |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
statuscode
| Propiedad | Valor |
|---|---|
| Description | Reason for the status of the makerfewshot |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
Elecciones/opciones de statuscode
| Valor | Etiqueta | Estado |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
TimeZoneRuleVersionNumber
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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 |
Columnas/atributos de sólo lectura
Estas columnas o atributos devuelven false tanto para IsValidForCreate como para IsValidForUpdate. Listado por SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- VersionNumber
CreatedBy
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
CreatedOn
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedBy
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
ModifiedOn
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OrganizationId
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | Unique identifier for the organization |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | None |
| Targets | organization |
| Type | Lookup |
OrganizationIdName
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
VersionNumber
Añadido por: solución Active Solution
| Propiedad | Valor |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relaciones de uno a varios
Listado por SchemaName.
- makerfewshot_SyncErrors
- makerfewshot_AsyncOperations
- makerfewshot_MailboxTrackingFolders
- makerfewshot_ProcessSession
- makerfewshot_BulkDeleteFailures
- makerfewshot_PrincipalObjectAttributeAccesses
makerfewshot_SyncErrors
Añadido por: solución System Solution
Igual que la relación de varios a uno makerfewshot_SyncErrors de la tabla syncerror.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno makerfewshot_AsyncOperations de la tabla asyncoperation.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno makerfewshot_MailboxTrackingFolders de la tabla mailboxtrackingfolder.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno makerfewshot_ProcessSession de la tabla processsession.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno makerfewshot_BulkDeleteFailures de la tabla bulkdeletefailure.
| Propiedad | Valor |
|---|---|
| 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
Añadido por: solución System Solution
Igual que la relación de varios a uno makerfewshot_PrincipalObjectAttributeAccesses de la tabla principalobjectattributeaccess.
| Propiedad | Valor |
|---|---|
| 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 |
Relaciones de varios a uno
Cada relación de varios a uno se define mediante una relación de uno a varios correspondiente con la tabla relacionada. Listado por SchemaName.
- lk_makerfewshot_createdby
- lk_makerfewshot_createdonbehalfby
- lk_makerfewshot_modifiedby
- lk_makerfewshot_modifiedonbehalfby
- organization_makerfewshot
lk_makerfewshot_createdby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_makerfewshot_createdby de la tabla systemuser.
lk_makerfewshot_createdonbehalfby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_makerfewshot_createdonbehalfby de la tabla systemuser.
lk_makerfewshot_modifiedby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_makerfewshot_modifiedby de la tabla systemuser.
lk_makerfewshot_modifiedonbehalfby
Añadido por: solución System Solution
Consulte la relación de uno a varios lk_makerfewshot_modifiedonbehalfby de la tabla systemuser.
organization_makerfewshot
Añadido por: solución System Solution
Consulte la relación de uno a varios organization_makerfewshot de la tabla organization.
Consultar también
Referencia de tabla o entidad de Dataverse Referencia de la API web makerfewshot EntityType