0
 Followers
21
 Likes

SimpleQuery: multiple join conditions and still set the join type

Aggregates & Queries
Implemented
on 24 Sep 2014
OutSystems 9
The simple query widget only allows to set the join type when the condition just have 2 attributes.
The simple query should have the same options if the condition has more than 2 attributes or variables.

Example:

SELECT *
FROM TABLE1
LEFT OUTER JOIN TABLE2 ON (TABLE2.ReferenceId = TABLE1.Id AND TABLE2.Something = @SomeVariable)

This is not the same as:

SELECT *
FROM TABLE1
LEFT OUTER JOIN TABLE2 ON (TABLE2.ReferenceId = TABLE1.Id)
WHERE TABLE2.Something = @SomeVariable


I can't do this with the simple query, and I'm forced to use the Advanced Query just to say that the condition is a Left Join and not a normal Join.
Created on 24 May 2012
Comments (5)
Merged this idea with 'More than one field in simple query joins' (created on 2011-08-31 20:02:49 by Carlos Freitas)
Should be possible to define more than one field in the join condition. This will avoid writing a couple of  advanced queries, taking advantage of the performance tunning of the simple queries.

Merged from 'More than one field in simple query joins' (idea created on 2011-08-31 20:02:49 by Carlos Freitas), on 2014-01-24 13:24:47 by Gonçalo Borrêga
A must feature

Merged from 'More than one field in simple query joins' (idea created on 2011-08-31 20:02:49 by Carlos Freitas), on 2014-01-24 13:24:47 by Gonçalo Borrêga
which version of outsystems is this implemented in? I am using outsystems 8 and i dont find it.
Hi Thirupathi,

This feature is only available in version 9 (with the new "Aggregates").

Best,
Hélio
views
189
Followers
0