Skip to Content (Press Enter)
2016-03-03 15-03-17
Sumo
127Views
1Comments
Join results of an Aggregate with results from an Action
Question
SQL
Forge
Logic
In my application, I have an entity that performs a mapping.  This application also has an Action that returns a list of values that can match a field in the entity.  I want to be able to join these to result sets together like a SQL join, but have been unable to do so.  In typical C# code, I can join two lists using LINQ.

To visualize my contrived example.  Each below can return many items, but the list returned from Action can have matching Groups.  The output of this "join" would be similar to an inner join.  I only want to return Roles from the Entity that have matching Groups.  I can think of a way to do this with a ForEach, but that seems slow if these lists get large.

Entity:
  • Group
  • Role
Action:
  • Group
0
0
10 May 2016
Copy Link
2016-04-21 18-13-58
Nuno Rolo
 
MVP
Hi,

You have the ListAppendAll to save the ForEach, but you need to have both lists with the same structure (same entities).

Hope that helps.
0
0
11 May 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.