OUTER JOIN in Query

Hi,

I am having trouble formulating a seemingly simple Query with an outer join in Glorp.

Let's use tables COMMAND and ERRMSG as an example where a COMMAND can have 0 to 1 associated ERMMSG.

I want to query all COMMAND objects that have the word 'DATE' in either the command itself or in its ERRMSG.

so what I have so far is this:

mySesson read: COMMAND where: [:cmd| cmd text like: '%DATE%' OR: (cmd errmsg like: '%DATE')].

This creates an INNER JOIN and therefor never returns a command that has no errormsg associated. So far, I tried:

• mySesson read: COMMAND where: [:cmd| cmd text like: '%DATE%' OR: ((cmd errmsg like: '%DATE') asOuterJoin)].
• mySesson read: COMMAND where: [:cmd| cmd text like: '%DATE%' OR: (cmd errmsg like: '%DATE') beOuterJoin].
  
  

And a few variants that use q SimpleQuery and the where: and OR: methods:

So far I had no luck at all. The web doesn't provide much information on this problem.

Any hints or ideas?

Joachim

To make a relationship use an outer join, just send #asOuterJoin. e.g. (cmd errMsg asOuterJoin). You can even put that into an expression that defines a mapping so it's always an outer join.

On Fri, Nov 2, 2018, 03:51 jtuchel <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="uK5EoCVGAwAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">jtu...@...> wrote:

Hi,

I am having trouble formulating a seemingly simple Query with an outer join in Glorp.

Let's use tables COMMAND and ERRMSG as an example where a COMMAND can have 0 to 1 associated ERMMSG.

I want to query all COMMAND objects that have the word 'DATE' in either the command itself or in its ERRMSG.

so what I have so far is this:

mySesson read: COMMAND where: [:cmd| cmd text like: '%DATE%' OR: (cmd errmsg like: '%DATE')].

This creates an INNER JOIN and therefor never returns a command that has no errormsg associated. So far, I tried:

• mySesson read: COMMAND where: [:cmd| cmd text like: '%DATE%' OR: ((cmd errmsg like: '%DATE') asOuterJoin)].
• mySesson read: COMMAND where: [:cmd| cmd text like: '%DATE%' OR: (cmd errmsg like: '%DATE') beOuterJoin].
  
  

And a few variants that use q SimpleQuery and the where: and OR: methods:

So far I had no luck at all. The web doesn't provide much information on this problem.

Any hints or ideas?

Joachim

--
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="uK5EoCVGAwAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">glorp-group...@googlegroups.com.
To post to this group, send email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="uK5EoCVGAwAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">glorp...@....
Visit this group at <a href="https://groups.google.com/group/glorp-group" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/group/glorp-group&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/group/glorp-group&#39;;return true;">https://groups.google.com/group/glorp-group.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.