OQL Left Joins of three entities

0
Hello all! Are these joins correct? I want to retrieve the attributes from Albaran, associated with the Ticket. And the Albaran is associated with the Facturable.
asked
2 answers
2

Hi Helga,

 

Not quite. You first need to specify the attributes you want to retrieve in a select statement. 

Afterward you join the tables on certain attributes. Something like this:

 

SELECT

Albaran/attribute,

Ticket/attribute
FROM YourModule.Albaran AS Albaran
    LEFT JOIN Albaran/Ticket AS Ticket
    LEFT JOIN Albaran/Facturable AS Facturable

 

In this example:

  • YourModule should be replaced with the actual name of your Mendix module.
  • Albaran is the entity you want to retrieve attributes from, and attributes is the placeholder for the specific attributes you want to retrieve.
  • Ticket and Facturable are associations in the Albaran entity to the Ticket and Facturable entities, respectively.

Please replace the entity and association names with the actual names used in your Mendix domain model. Also, be sure to consult Mendix documentation or resources specific to the version you're using to ensure the accuracy of the OQL query syntax.

answered
0

problem here: two entities are in one module and the other in another module

answered