Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Ryan Rueckl 17 posts 74 karma points
    Apr 13, 2017 @ 23:09
    Ryan Rueckl

    Changing datatype does not update dataTypeGuid in the database if alias is kept the same

    I created an editor where one of the properties was originally a dropdown list datatype. I have content in the DB using this editor. I then switched that datatype to a MNTP, but I did not change the property name or alias. When saving the content a second time (after selecting content with the MNTP), the value in the database changes but the dataTypeGuid does not.

    The reason that this is a problem is that it will not deploy properly using Courier. The deployed value gets wiped out on the receiving instance.

    Here's an example of the data stored in the DB (property is called Science Branch) when it was saved with the DDL datatype:

    "scienceBranch": { "value": "29", "dataTypeGuid": "118f8ef3-c212-4c5f-92ea-413f4fdbdeca", "editorAlias": "scienceBranch", "editorName": "Science Branch" }

    After switching to a MNTP, this is what's in the DB:

    "scienceBranch": { "value": "1085", "dataTypeGuid": "118f8ef3-c212-4c5f-92ea-413f4fdbdeca", "editorAlias": "scienceBranch", "editorName": "Science Branch" }

    But it really should be this:

    "scienceBranch": { "value": "1085", "dataTypeGuid": "f3e624bc-924c-4506-b6Ba-8d3a6eCe15ce", "editorAlias": "scienceBranch", "editorName": "Science Branch" }

    If I change the property alias, it then correctly updates the dataTypeGuid, however, it clears out the values I had previously selected. Seems like maybe it's just missing a check to see if they data type changed.

Please Sign in or register to post replies

Write your reply to: