6 Answer(s)

• 

  0

  oguzhanagir created one year ago

  Support Team

  Hi @Theunis

  Is the "Core.AlertComment.json" entity file that you associated as One to Many located in the same directory as the "Core.AlertNotification.json" file? It is giving this error because it cannot find "Core.AlertComment.json" file. If this file exists, make sure that its name and content are configured correctly.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  Theunis created one year ago

  Hi,

  Is the "Core.AlertComment.json" entity file that you associated as One to Many located in the same directory as the "Core.AlertNotification.json" file? Yes indeed that is the case.

  Here it is for reference:

  ---

  { "IsRegenerate": true, "MenuPosition": "main", "RelativeNamespace": "Core", "EntityName": "AlertComment", "EntityNamePlural": "AlertComments", "TableName": "AlertComments", "PrimaryKeyType": "int", "BaseClass": "Entity", "EntityHistory": false, "AutoMigration": true, "UpdateDatabase": true, "CreateUserInterface": true, "CreateViewOnly": true, "CreateExcelExport": false, "CreateExcelImport": true, "IsNonModalCRUDPage": false, "IsMasterDetailPage": false, "GenerateOverridableEntity": false, "GenerateUnitTest": false, "GenerateUiTest": false, "GenerateMobile": false, "PagePermission": { "Host": false, "Tenant": true }, "Properties": [ { "Name": "AlertCommentDetail", "Type": "string", "MaxLength": -1, "MinLength": -1, "Range": { "IsRangeSet": false, "MinimumValue": 0.0, "MaximumValue": 0.0 }, "Required": false, "Nullable": false, "Regex": "", "IsMultiLingual": false, "UserInterface": { "AdvancedFilter": false, "List": true, "ListMaui": false, "CreateOrUpdate": true }, "ViewType": null, "AdditionalData": {} }, { "Name": "DateLastModified", "Type": "DateTime", "MaxLength": -1, "MinLength": -1, "Range": { "IsRangeSet": false, "MinimumValue": 0.0, "MaximumValue": 0.0 }, "Required": false, "Nullable": false, "Regex": "", "IsMultiLingual": false, "UserInterface": { "AdvancedFilter": false, "List": true, "ListMaui": false, "CreateOrUpdate": true }, "ViewType": null, "AdditionalData": {} } ], "NavigationProperties": [ { "Namespace": "ITS.Core", "ForeignEntityName": "AlertNotification", "ForeignEntityNamePlural": "AlertNotifications", "IdType": "int", "IsNullable": true, "PropertyName": "AlertNotificationId", "DuplicationNumber": 0, "RelationType": "single", "ViewType": "LookupTable", "DisplayPropertyNameInfos": { "MergeFormat": null, "DisplayPropertyNames": [] } }, { "Namespace": "ITS.Authorization.Users", "ForeignEntityName": "User", "ForeignEntityNamePlural": "Users", "IdType": "long", "IsNullable": true, "PropertyName": "UserId", "DuplicationNumber": 0, "RelationType": "single", "ViewType": "LookupTable", "DisplayPropertyNameInfos": { "MergeFormat": "{,"IsGeneratedByMasterPage": true0}", "DisplayPropertyNames": [ "Name" ] } } ], "NavigationPropertyOneToManyTables": [], "EnumDefinitions": [], "DbContext": null }

  ---

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  oguzhanagir created one year ago

  Support Team

  Hi @Theunis

  In your "Core.AlertComment.json" file, the "MergeFormat" variable with the value "{,"IsGeneratedByMasterPage": true0}" in the NavigationProperties has an incorrect value and therefore gives the relevant error. To fix this in the relevant entity, you need to set the "MergeFormat" value to "{0}". The reason for this problem is that while the Child Entity is being created in the MasterDetail and the Existing Property is being updated, the new value to be added is added to the wrong line, so you have encountered this problem. I have created an issue for this. You can follow the developments here. Thank you for your feedback.

  Core.AlertComment.json file content with corrected MergeFormat value

  {
    "IsRegenerate": true,
    "MenuPosition": "main",
    "RelativeNamespace": "Core",
    "EntityName": "AlertComment",
    "EntityNamePlural": "AlertComments",
    "TableName": "AlertComments",
    "PrimaryKeyType": "int",
    "BaseClass": "Entity",
    "EntityHistory": false,
    "AutoMigration": true,
    "UpdateDatabase": true,
    "CreateUserInterface": true,
    "CreateViewOnly": true,
    "CreateExcelExport": false,
    "CreateExcelImport": true,
    "IsNonModalCRUDPage": false,
    "IsMasterDetailPage": false,
    "GenerateOverridableEntity": false,
    "GenerateUnitTest": false,
    "GenerateUiTest": false,
    "GenerateMobile": false,
    "PagePermission": {
      "Host": false,
      "Tenant": true
    },
    "Properties": [
      {
        "Name": "AlertCommentDetail",
        "Type": "string",
        "MaxLength": -1,
        "MinLength": -1,
        "Range": {
          "IsRangeSet": false,
          "MinimumValue": 0.0,
          "MaximumValue": 0.0
        },
        "Required": false,
        "Nullable": false,
        "Regex": "",
        "IsMultiLingual": false,
        "UserInterface": {
          "AdvancedFilter": false,
          "List": true,
          "ListMaui": false,
          "CreateOrUpdate": true
        },
        "ViewType": null,
        "AdditionalData": {}
      },
      {
        "Name": "DateLastModified",
        "Type": "DateTime",
        "MaxLength": -1,
        "MinLength": -1,
        "Range": {
          "IsRangeSet": false,
          "MinimumValue": 0.0,
          "MaximumValue": 0.0
        },
        "Required": false,
        "Nullable": false,
        "Regex": "",
        "IsMultiLingual": false,
        "UserInterface": {
          "AdvancedFilter": false,
          "List": true,
          "ListMaui": false,
          "CreateOrUpdate": true
        },
        "ViewType": null,
        "AdditionalData": {}
      }
    ],
    "NavigationProperties": [
      {
        "Namespace": "ITS.Core",
        "ForeignEntityName": "AlertNotification",
        "ForeignEntityNamePlural": "AlertNotifications",
        "IdType": "int",
        "IsNullable": true,
        "PropertyName": "AlertNotificationId",
        "DuplicationNumber": 0,
        "RelationType": "single",
        "ViewType": "LookupTable",
        "DisplayPropertyNameInfos": {
          "MergeFormat": null,
          "DisplayPropertyNames": []
        }
      },
      {
        "Namespace": "ITS.Authorization.Users",
        "ForeignEntityName": "User",
        "ForeignEntityNamePlural": "Users",
        "IdType": "long",
        "IsNullable": true,
        "PropertyName": "UserId",
        "DuplicationNumber": 0,
        "RelationType": "single",
        "ViewType": "LookupTable",
        "DisplayPropertyNameInfos": {
          "MergeFormat": "{0}",
          "DisplayPropertyNames": ["Name"]
        }
      }
    ],
    "NavigationPropertyOneToManyTables": [],
    "EnumDefinitions": [],
    "DbContext": null
  }
  

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  oguzhanagir created one year ago

  Support Team

  Hi @Theunis

  May I know your Power Tools version so I can reproduce the situation?

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  Theunis created one year ago

  Yes, certainly. It is version 4.5.4

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  oguzhanagir created one year ago

  Support Team

  Hi @Theunis

  Can you please tell us the steps to create the Entities to avoid this issue? Thank you

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel