09-24-2009 02:38 PM
09-24-2009 03:34 PM
You can create the view in AA as you would any other table. However, there is an issue with resolving key fields on existing db views when creating the entity in App Architect. To workaround this, you will need to open the actual XML definition file for the entity based on the view. This can be done using any windows text editor you prefer. The following steps should correct this problem for the view "MyView":
Note that I had to remove all the greater than and less than signs from the above text to get it to post correctly here. You can use the XML file from any other entity as an example of what the syntax should look like.
09-25-2009 11:48 AM
The ID would be in the <properties> section of thexml file. Use one of those proprties to define the key value. Be sure to use the GUID from the property you wish to use. You can see an example of this in the file Account.ACCOUNT.entity.xml. Note that the key properties correspond to the IDs from the properties section.