# DataService query persons in group?

**URL:** <https://forum.litium.com/t/dataservice-query-persons-in-group/1412>\
**Category:** Questions\
**Created:** [March 30, 2020, 4:39pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412 "2020-03-30T16:39:53Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![hans](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/hans/32/31_2.png) [@hans](https://forum.litium.com/u/hans)\
**Post date:** [March 30, 2020, 4:39pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/1 "2020-03-30T16:39:53Z")

</div>

How can I use the DataService to fetch all persons belonging to a specific group?

Litium version: 7.4

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [March 31, 2020, 9:20am UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/2 "2020-03-31T09:20:46Z")

</div>

You need to use Dapper instead of DataService because with DataService you will be forced to fetch all customers as a list first and do your selection after and that would be dangerous on large numbers of customers to look up from DB directly.

---

<div class="post-metadata">

**Author:** ![hans](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/hans/32/31_2.png) [@hans](https://forum.litium.com/u/hans)\
**Post date:** [March 31, 2020, 2:39pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/3 "2020-03-31T14:39:42Z")

</div>

I had no idea Litium used Dapper. Or do you mean we should implement our own custom orm/data access layer?

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [March 31, 2020, 3:06pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/4 "2020-03-31T15:06:20Z")

</div>

Dapper is included in Accelerator.

---

<div class="post-metadata">

**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\
**Post date:** [March 31, 2020, 4:00pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/5 "2020-03-31T16:00:16Z")

</div>

I suggest to use the DataService directly

```auto
using (var q = _dataService.CreateQuery<Person>())
{
    return q.Filter(x => x.ContainsInGroup(GroupSystemId)).ToList();
}

```

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [March 31, 2020, 4:10pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/6 "2020-03-31T16:10:59Z")

</div>

Great didn’t find that extension method 🙂

---

<div class="post-metadata">

**Author:** ![hans](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/hans/32/31_2.png) [@hans](https://forum.litium.com/u/hans)\
**Post date:** [March 31, 2020, 4:27pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/7 "2020-03-31T16:27:56Z")

</div>

Neither did I… thank’s Patric.  
And now that I do know, searching yields this page: [https://docs.litium.com/api-reference/api?product=Litium&version=7.4&xref=Litium.Customers.Queryable.PersonFilterDescriptorExtensions](https://docs.litium.com/api-reference/api?product=Litium&version=7.4&xref=Litium.Customers.Queryable.PersonFilterDescriptorExtensions)  
Hopefully you’ll find time to improve the documentation on these things so we get to know about them and can use them.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/12eddac3b8b661de1db86af10ac8151b571e6fb9.png) [@system](https://forum.litium.com/u/system)\
**Post date:** [April 28, 2020, 4:28pm UTC](https://forum.litium.com/t/dataservice-query-persons-in-group/1412/8 "2020-04-28T16:28:02Z")

</div>

Closed on April 28, 2020, 4:28pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.