[Dynamic LINQ] JOIN clause

Forge Component
(6)
Published on 28 Sep (3 weeks ago) by Wei Zhu
6 votes
Published on 28 Sep (3 weeks ago) by Wei Zhu

Is it possible to use a JOIN clause?

Solution

I had implemented INNER JOIN, and add a new Action that can specify multiple Source List.

You can query with JOIN as following

FROM t1
JOIN t2 ON {Employee}.[Gender] = {Gender}.[Id]
SELECT t1.{Employee}.[Id], t1.{Employee}.[EmployeeName], t2.{Gender}.[Label]


Regards

Wei


Solution

Hi,

How to write query for dynamic linq i have given local list as a srclist  for DynamicLINQ_Query


Thanks,

Ronan T.

Hi

 

You need pass the query as Text.

Please check sample eSpace, there are examples on how to select / filter / sort / join.

Also you can check try page

https://orion.outsystemscloud.com/DynamicLINQSample/DynamicLINQ.aspx


Regards

Wei





Is it possible to use a LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN clause?

LINQ can not specify LEFT / RIGHT / FULL OUTER join

So currently this component can not handle it.


But it seems there are alternative way to do LEFT JOIN with LINQ.

https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/join-clause

So maybe we can implement LEFT JOIN, but i need some time.