benatspo
commented
4 years ago Here is a complete example.
1) Source model before the creation of a new relation (relation name: "user", relation cardinality: "one", relation source entity: "Address"): see "source.log" attached file.
2) Uploaded model (containing the relation in the ML model) before the creation of a new relation: see "target.log" attached file.
3) QL queries to add the corresponding relation to the corresponding entity (add "user" relation to "Address" entity):
create Address.user -> User[1..1]
-> This last query returns an error. Speaking with Davy, two problems:
- Impossible to create a relation dynamically without "resetdatabases" web service call
- Impossible to create a relation between two relational database entities, as the create relation query does not create the join table dynamically. Such an operation is actually working between two document database entities, or from a document database entity to a relational database entity.
Thank you for your help
DavyLandman
tvdstorm
Hi,
It is actually impossible to create a relation between two entities, except if those entities are both in a document database, or if the source entity is in a document database. Actually, the only solution to create a physical relation between two entities in a relational database, is to add the relation in the ML schema, and reset the databases.
Thank you for the correction