• State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 93 subscribers
  • Views 5641 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Select with Distinct in API

Robert Byrne
over 6 years ago

Hi,

How would I add a 'Distinct' to the following code, as in 'Select Distinct LastName from Person'.

Dim aQuery As Query = Query.From(Table.Person).Select("Lastname")
Dim iPersons = Session.Source.GetCollection(aQuery)

thanks,

Rob.

Parents
  • 0 over 6 years ago
    Hi Tim,

    I don't see that method as being available on the Select().

    There is a .Distinct() on the IEntityCollection, but that doesn't return Distinct on Firstname.
    There are various possibilities to add Query Parameters...but not sure if that's the way.

    Rob.
Reply
  • 0 over 6 years ago
    Hi Tim,

    I don't see that method as being available on the Select().

    There is a .Distinct() on the IEntityCollection, but that doesn't return Distinct on Firstname.
    There are various possibilities to add Query Parameters...but not sure if that's the way.

    Rob.
Children
No Data