Include Child Record Count in json Rails

Question

I'm trying to include a item_count field in a json response on Rails. I have a list of Categories and each of those records has one or more Items.

Here is my current index.json.jbuilder file:

json.array! @categories, partial: 'categories/category', as: :category

And the _category.json.jbuilder partial

json.extract! category, :id, :name, :created_at, :updated_at
json.url category_url(category, format: :json)

I want to include category.item_count in the response but I'm not exactly sure how to do this. Thanks in advance.

MrShemek · Accepted Answer · 2018-03-27 07:01:47Z

1

You can add item_count to the partial like this:

json.item_count category.items.count

However, for each category, it will execute an additional query (to get the number of items):

SELECT COUNT(*) FROM `items` WHERE `items`.`category_id` = ID

answered Mar 27, 2018 at 7:01

MrShemek

2,4831 gold badge18 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Include Child Record Count in json Rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related