• State Verified Answer
  • Replies 3 replies
  • Subscribers 92 subscribers
  • Views 138 views
  • Users 0 members are here
Options
Related

How Can I use GroupBy and OrdeBy in my Queries?

Nicholas Matos
15 days ago

 I would like to use GroupBy or OrderBy with the following script, I searched about this but didn't find anything.

Dim jobQr = Query.From(Table.Person).Select("PersonalTitle").Where("IsInActive = 0 and IsExternal = 0 and IdentityType = 'Primary'")
Dim jobR = Session.Source.GetCollection(jobQr, EntityCollectionLoadType.Slim)

Can you help me?

  • +1 15 days ago

    For grouping you find a code snippet in the snippet library of the code editor in Designer or Object Browser. Just press F2 (or choose the snippet icon from the toolbar) and select Object layer | Collections | Group collections by column

    For sorting a collection you can use the .OrderBy method in your fluent query definition.

    For example:

    Dim jobQr = Query.From(Table.Person).Select("PersonalTitle").Where("IsInActive = 0 and IsExternal = 0 and IdentityType = 'Primary'").OrderBy("PersonalTitle")
    Dim jobR = Session.Source.GetCollection(jobQr, EntityCollectionLoadType.Slim)

  • 0 15 days ago in reply to Markus Weiss-Ehlers

    Hello Markus,
    I tried this before, but I received the following error message:

    Overload resolution failed because no accessible GetCollection can be called with these arguments

    Expression is of type '?', which is not a collection type.

    Do you have any idea how to resolve this?

  • 0 12 days ago in reply to Nicholas Matos

    Sorry, my bad. The Select part of the query object should be the last one.

    Dim jobQr = Query.From(Table.Person).Where("IsInActive = 0 and IsExternal = 0 and IdentityType = 'Primary'").OrderBy("PersonalTitle").Select("PersonalTitle")