Support full outer joins

[gaboelnuevo]

I created this extension in JS for adding this feature.
If it is of interest I can adapt to TS and do a pull request

Please check: https://gist.github.com/gaboelnuevo/51117a3124cb730c1c8650b50bf201a0

Example:

fullOuterJoin(query: RealmQuery): RealmQuery
Join queries like a full outer join

let query1 = RealmQuery
  .where(realm.objects('Person'))
  .in('id', [1001, 1002])
let query2 = RealmQuery
  .where(realm.objects('Person'))
  .greaterThan('age', 25);
query1.fullOuterJoin(query2);

query1.toString = (id == 1001 OR id == 1002) OR (age > 25)

[mrphu3074]

@gaboelnuevo I think your idea is similar to api join
Can you take a look at https://github.com/mrphu3074/realm-query#joinquery-realmquery-realmquery ?

[gaboelnuevo]

Yes is similar but the two queries are wrapped with a OR .

The join function maybe can receive the type of join. What do you think?

[mrphu3074]

@gaboelnuevo I can update this api to support logic operator (OR|AND) and default is AND

function join(query, logicOp = 'AND') {
//
}

What do you think?

[gaboelnuevo]

@mrphu3074 Sounds good to me.