Hello Fernando
Try This Module: https://marketplace.mendix.com/link/component/160
It’s Working Fine All join concepts are also possible.
I don't think it is possible to do this, since the database connector only allows 1 return object. Try to return all selected values in 1 non persistant object and then process that list into your persisted / associated entities within Mendix.
GL!
Ruud is right, if you want data of both the Rule and Notification object returned, you need to run the query and after the query returns a resulting dataset use this data to instantiate this new non persistent entity with all needed attributes combined. This can, to my knowlegde, only be done by adding a simle Java action for the SQL + creation of the object and this new object in your domain model. See for instance:
https://github.com/ako/QueryApiBlogPost/blob/master/javasource/hr/actions/RetrieveAdvancedSql.java
Also, why don't you use the association table? I would write the query like:
SELECT n.Notification_ID
,r.Triggering
,r.Value
,r.Variable,
,r.Severity
,r.Device_Type
,n.Num_Samples
,n.TimeStamp_Creation
,n.TimeStamp_last_update
FROM MyDomainModel$Notification n
INNER JOIN MyDomainModel$Notification_Rule n_r on n_r.MyDomainModel$Notificiationid = n.id
INNER JOIN MyDomainModel$Rule r ON r.id = n_r.MyDomainModel$Ruleid
WHERE n.Notification_Status = "ACTIVE"
ORDER BY n.TimeStamp_Creation ASC
Should work!
Hola Fernando!
Como resolviste este problema?
Tengo un caso parecido