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

New Issue

Closed

opened 2025-12-29 15:28:11 +01:00 by adam · 2 comments

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

Owner

Copy Link

Copy Source

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

Author

Owner

Copy Link

Copy Source

@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

Author

Owner

Copy Link

Copy Source

@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.

No Branch/Tag Specified

Branches Tags

develop

prototype/swift6

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

9.3.0

9.2.0

9.1.0

9.0.0

8.1.0

8.0.1

8.0.0

7.3.1

7.3.0

7.2.0

7.1.0

7.0.4

7.0.3

7.0.2

7.0.1

7.0.0

6.3.2

6.3.1

6.3.0

6.2.1

6.2.0

6.1.0

6.0.0

5.3.1

5.3.0

5.2.0

5.1.1

5.1.0

5.0.0

4.2.4

4.2.3

4.2.2

4.2.1

4.2.0

4.1.4

4.1.3

4.1.1

4.1.0

4.0.5

4.0.4

4.0.3

4.0.2

4.0.1

4.0.0

4.0.0-beta3

4.0.0-beta2

4.0.0-beta

3.1.1

3.1.0

3.0.3

3.0.2

3.0.1

3.0.0

2.1.3

2.1.2

2.1.1

2.1.0

2.0.6

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

1.6.10

1.6.9

1.6.8

1.6.7

1.6.6

1.6.5

1.6.4

1.6.3

1.6.2

1.6.1

1.6.0

1.5.4

1.5.3

1.5.2

1.5.1

1.5.0

1.4.4

1.4.3

1.4.2

1.4.1

1.4.0

1.3.6

1.3.5

1.3.4

1.3.3

1.3.2

1.3.1

1.3.0

1.2.1

1.2.0

1.0.2

1.0.1

1.0.0

0.2.1

0.2.0

0.1.2

0.1.1

0.1.0

Labels

Clear labels

abandoned

corestore bug

discussion

duplicate

enhancement

fixed

fixed

help wanted

in progress

investigating

ios/compiler bug

irreproducible

looking for workarounds

not a bug

pending

pending docs update

pull-request

Mirrored from GitHub Pull Request

question

regression

user bug

wontfix

No labels question

Milestone

No items

No Milestone

Projects

Clear projects

No projects

Assignees

Clear assignees

adam (Adam Melkus)

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/CoreStore#284