Start a new topic
Answered

My Current Model Does Not Allow Me to Retrieve All the Desired Elements Between Entities with Relationships.

Hello, I have a current modeling (data model) that does not allow me, via the relationships between entities, to retrieve all the desired elements. I can clearly see the entities linked via a LEFT JOIN. However it would be necessary for me to be able to make RIGHT JOIN (impossible thing it seems to me in Semarchy). Question: I would therefore like to know if it is possible for me to create an SQL view (based on my Semarchy tables) in order to gather all the desired elements (green stars in the shared image) and display them in a table in Semarchy. If yes, how ?


Best Answer

I suggest you go through a Dashboard that you will then integrate into your application. In the Dashboard you can run any type of SQL query as you wish. https://www.semarchy.com/doc/xdm/5.2.10/semdb.html#creating-a-query

1 Comment

Answer

I suggest you go through a Dashboard that you will then integrate into your application. In the Dashboard you can run any type of SQL query as you wish. https://www.semarchy.com/doc/xdm/5.2.10/semdb.html#creating-a-query

Login to post a comment