[Dynamic LINQ] JOIN clause

Forge Component
(6)
Published on 2017-03-06 by Wei Zhu
6 votes
Published on 2017-03-06 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