My Current Model Does Not Allow Me to Retrieve All the Desired Elements Between Entities with Relationships.
F
Fathia Jama
started a topic
over 2 years ago
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 ?
Fathia Jama
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 ?
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
Fathia Jama
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
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics