Sequel pro sql insert export4/10/2023 You can add a numeric integer field as well and fill with the Order Number so you can sort correctly in the application based on the integer value vs a text field.Ģ. This will be a text field in Dataverse that would contain your Order Numbers. Utilize the Primary Name column on the Order table to be the OrderNumber. You should be able to relate the tables in the following way:ġ. I believe the cause of my problems is that the relationship is using the GUID primary key which causes an error as OrderNumber is an Integer field.ĭoes anyone have any guidance on how I can access / import existing SQL data into the Dataverse and get relationships created on the existing OrderNumber field? The problem is that the created Dataverse tables have an auto generated Primary Key and I cannot work out a way of creating the relationship between the two tables on the existing OrderNumber field. I have tested the relationships with dummy (non virtual) tables and the Views and Table Permissions work fine so I assume my issues are due to constraints with the Virtual Connector.Ģ. ![]() The problem is that related fields in Views and Table Permissions that use this relationship do not work correctly. This works and I can create the virtual tables, access data and even create relationships between the two tables on field OrderNumber. I have tried two methods to get the data available in the Dataverse:ġ. ![]() OrderLineDetail that relates to OrderHeader via field OrderNumber OrderHeader with Primary Key OrderNumber (integer)Ģ. This data would be regularly refreshed into the Dataverse.ġ. I am new to the Dataverse and model driven apps and am looking at building a simple portal application that needs to reference existing data from an external system hosted on a SQL server (on premise).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |