Database migration issue
Hey @charles
I have a question regarding our metadata database, specifically about the objectMetadata table, which contains two fields: labelidentifierfieldmetadataid and imageidentifierfieldmetadataid. How are we storing data in these fields, and what is their relationship with the fieldMetadata table? In version 0.4, these fields default to NULL, whereas in version 0.23, they contain some values as shown in the screenshot. I would like to understand how to migrate the data from version 0.4 to 0.23.
4 Replies
Hi @anjali,
Those are only for presentation logic.
As you can see here in the screenshot it can be used when we need to display a record of an object and we need to know which field can be used to identify the record via a text or an image.
In the example, people can be identified by their names and their avatar so on the person objectMetadata we have the 'name' field as labelIdentifierFieldMetadataId and 'avatarUrl' as the imageIdentifierFieldMetadataId.
Hey @Weiko I’m looking to migrate from version 0.4 to 0.23 and would like some guidance on how to handle the variability in identifiers returned by the labelIdentifierFieldMetadataId.
In our current setup, the select * from metadata."fieldMetadata" where id in (select "labelIdentifierFieldMetadataId" from metadata."objectMetadata" )query sometimes returns different fields (like name, id, or title) based on that identifier. How can we best manage this during the migration process? Are there specific adjustments we should make to the query or application logic to ensure consistency?
I appreciate any insights you can provide!
Hey @Weiko @charles is there any insights on above question?
Hi @anjali, migrating from 0.4 to the latest version (0.32) will be very challenging. Do you have a lot of data in your CRM? it might be easier to spin a new instance on 0.32 and re-import your data using SQL direclty