Search code examples
sqlormllblgenpro

LLblgen: Select distinct?

I can't seem to figure out how I can select only distinct entries in Llblgen 2.6 self-service model

I essentially want this query.

select distinct City
from peopleTable
where *predicates*

I've got my PeopleCollection and I'm not sure if there's a distinct method I can call or argument I can pass to GetMulti().

Solution

  • Entities by definition cannot be distinct - even if they have the same value they are different rows in the same table.

    You could use a TypedList or DynamicList to get a distinct list of city values - one of the parameters on the Fetch call is to get distinct items.

    Or if you are using LINQ you could do 

    List<string> cities = PeopleCollection.Select(x=>x.City).Distinct();