2sxc Linq query for Categories

Question

I have entities: Documents, Category, DocList

Documents and DocumentList can have multiple categories selected.

I want to make filter for Documents that are in one or more categories.

// all documents
var items = AsDynamic(App.Query["DocList"]["AllDocs"]);
// categories for filter
var fcat = Content.Category;

//linq query??
items = items.Where(d=>d.Category ....????....);

Can and how I can make this kind of filter?

Content.Category is list of Categories.

So I want to show list of items if there are in any of categories, not only one

something like this: linq where list contains any in list

What is the type of `fcat`? is it a collection? – Gilad Green Apr 17 '17 at 09:25 — Gilad Green, Apr 17 '17 at 09:25
Category is DynamicEntity – Jernej Pirc Apr 17 '17 at 09:52 — Jernej Pirc, Apr 17 '17 at 09:52

iJungleBoy · Answer 1 · 2017-04-24T14:26:22.037

1

So parts of this are explained in the wiki https://github.com/2sic/2sxc/wiki/DotNet-Query-Linq

but I must admit that there is no example for exactly your question. I believe you want something like:

// filter - keep only those that have this Category
// note that the compare must run on the EntityId because of object wrapping/unwrapping
    items = items.Where(i => 
        (i.Category as List<dynamic>).Any(c => c.EntityId == fcat.EntityId))

So this should work :)

Additional solution if fcat is a list should be approx. like this

// filter - keep only those that have this Category
// note that the compare must run on the EntityId because of object wrapping/unwrapping
    items = items.Where(i => 
        (i.Category as List<dynamic>).Any(c => fcat.Any(f => c.EntityId == f.EntityId)))

If this causes an error, you'll probably need to cast fcat into something like

((List<dynamic>)fcat).Any(...)

edited Apr 24 '17 at 14:26

answered Apr 18 '17 at 14:25

iJungleBoy

5,325
1
9
21

I make mistake before and This don't work, becouse fcat = list of dynamic entities. – Jernej Pirc Apr 19 '17 at 09:56
I need something like : http://stackoverflow.com/questions/10667675/linq-where-list-contains-any-in-list – Jernej Pirc Apr 19 '17 at 10:31
I made a correction which should cover your case - did it help? – iJungleBoy Apr 26 '17 at 12:00
sorry for late response. I try your update with variations but stuck with message: Error: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: Cannot convert type 'System.Collections.Generic.List' to 'System.Collections.Generic.List – Jernej Pirc Apr 28 '17 at 15:42
Did you use List or List – iJungleBoy May 01 '17 at 07:12
BTW: if that is the whole problem, just replace List with List – iJungleBoy May 10 '17 at 06:56
I change code like you said and now is OK, I also posted answer with new full code.. – Jernej Pirc Feb 12 '18 at 14:49

score 1 · Accepted Answer · answered Feb 12 '18 at 14:47

Tested on: dnn 9.1.1 / 2sxc 9.14.0

My final code:

@using System
@using ToSic.SexyContent
@using System.Collections.Generic
@using System.Linq
@{
    var items = AsDynamic(App.Data["Document"]);
    var tags = Content.Tags;
    items = items.Where(i => (i.Tags as List<DynamicEntity>).Any(c => ((List<DynamicEntity>)tags).Any(f => c.EntityId == f.EntityId)));
}
<div class="sc-element">
    <h1>@Content.Title</h1>
    @Edit.Toolbar(Content)
</div>
@foreach(var t in items)
{
    <div>@t.Title</div>
}

Document has field : Title (string) and Tags (Tag Entity / multiple)

Content is "Document List" with field "Tags" (type of Tag / multiple)

That way my code work.

Perfect. BTW: You probably just need the first `as List<...>`, the second one `c => ((List...)` is probably not necessary — iJungleBoy, Feb 13 '18 at 15:46

2sxc Linq query for Categories

2 Answers2