6 Answer(s)

• 

  0

  oguzhanagir created 13 days 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.

  Save Cancel
• 

  0

  Theunis created 12 days 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
  }

  ---

  Save Cancel
• 

  0

  oguzhanagir created 12 days 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
  }
  

  Save Cancel
• 

  0

  oguzhanagir created 12 days ago

  Support Team

  Hi @Theunis

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

  Save Cancel
• 

  0

  Theunis created 9 days ago

  Yes, certainly. It is version 4.5.4

  Save Cancel
• 

  0

  oguzhanagir created 9 days ago

  Support Team

  Hi @Theunis

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

  Save Cancel