Is it possible to use a JOIN clause?
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
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
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.