Calling QueryAttributes With Aggregate Count On One-To-Many Relationship #284

New Issue

adam · 2025-12-29T15:28:11+01:00

adam commented

2025-12-29 15:28:11 +01:00

Originally created by @damianstrain on GitHub (Aug 1, 2019).

Hi John,

I'm executing the following (where "boards" is a one-to-many relationship on Project):

try CoreStore.queryAttributes(
    From<Project>(),
    Select("id", "key", "name", "createdOn", "updatedOn", .count("boards", as: "boardCount"))
)

Only the following attributes seem to be returned: "id", "key", "name", "createdOn", "updatedOn" and there are no exceptions or errors present.

I know that Project has 2 Boards, so I was expecting "boardCount" to be 2.
Is what I'm doing valid? Can you call .count on a one-to-many relationship?

Many Thanks

Originally created by @damianstrain on GitHub (Aug 1, 2019). Hi John, I'm executing the following (where `"boards"` is a one-to-many relationship on `Project`): ```swift try CoreStore.queryAttributes( From<Project>(), Select("id", "key", "name", "createdOn", "updatedOn", .count("boards", as: "boardCount")) ) ``` Only the following attributes seem to be returned: `"id", "key", "name", "createdOn", "updatedOn"` and there are no exceptions or errors present. I know that Project has 2 Boards, so I was expecting `"boardCount"` to be 2. Is what I'm doing valid? Can you call `.count` on a one-to-many relationship? Many Thanks

adam added the question label 2025-12-29 15:28:11 +01:00

adam closed this issue

2025-12-29 15:28:11 +01:00

adam commented

2025-12-29 15:28:11 +01:00

@JohnEstropia commented on GitHub (Sep 22, 2019):

@damianstrain Sorry for the long wait. The count operator here is a collection operator, which means it will count a value for a property if you use the GroupBy clause as well. Instead, can you try

Select("id", "key", "name", "createdOn", "updatedOn", .attribute("boards.@count", as: "boardCount")))

@JohnEstropia commented on GitHub (Sep 22, 2019): @damianstrain Sorry for the long wait. The count operator here is a collection operator, which means it will count a value for a property if you use the `GroupBy` clause as well. Instead, can you try ```swift Select("id", "key", "name", "createdOn", "updatedOn", .attribute("boards.@count", as: "boardCount"))) ```

adam commented

2025-12-29 15:28:11 +01:00

@damianstrain commented on GitHub (Sep 25, 2019):

Excellent! Thanks @JohnEstropia

@damianstrain commented on GitHub (Sep 25, 2019): Excellent! Thanks @JohnEstropia

Sign in to join this conversation.

Branches Tags

develop

master

prototype/concurrency

minIOS13

prototype/containers

transactionSourceTracking

prototype/swiftui

minIOS11

swift5_3

prototype/propertyWrapperFields

prototype/propertyWrappers

prototype/propertyWrapper

Swift5

throwables

prototype/Swift_4_1

prototype/Swift_4_0

prototype/Swift_3_2

prototype/queryBuilders

temp/develop

corestore4_develop

prototype/mainContextToPSC

master_ios_7_to_9

swift_2_3

gh-pages

_corespotlight-test

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/CoreStore#284