Rails 3: Rendering certain attributes of an array of objects in JSON

Question

I'm trying to pass some data to javascript in my view. I only want certain attributes of the objects in the array.

The json gem doesn't appear to support the :only option. I tried to use ActiveSupport::JSON

<script>
test1=<%=raw ActiveSupport::JSON.encode(@sectionDatas.values, :only => [ :left, :width ])%>;
</script>

but that ignores the :only and prints the whole object.

Then I thought I would be clever and take the render method from the controller:

test2=<%=raw render :json => @sections.as_json(:only => [:left, :width])%>

but I get Nil:Nilclass errors.

I also tried to put this in my model and run to_json:

include ActiveModel::Serialization::JSON

def attributes
  @attributes ||= {'left' => 0, 'width'=>0}
end

Again, this ignores the attributes method and serializes the whole object.

Surely this must be simple. What am I missing?

score 3 · Answer 1 · answered Mar 21 '11 at 23:11

3

Assuming the objects in the array are instances of ActiveRecord::Base or include ActiveModel::Serialization::JSON:

test2=<%=raw @sections.to_json(:only => [:left, :width]) %>

answered Mar 21 '11 at 23:11

John

score 2 · Accepted Answer · edited May 23 '17 at 12:23

2

You can filter out the columns you don't need when you get objects from the db with select.

Item.find( :all, :select => 'DISTINCT fieldname' )

Of course, this is not the Rails3 way. Here that is:

Model.select(attribute)

Update

If you want to have the original array of objects and json but the json with filtered attributes you will need to override to_json:

This post explains how to do that:

edited May 23 '17 at 12:23

Community

answered Mar 21 '11 at 22:27

thenengah

Won't that cause an extra query to the database for data I already have? – bcoughlan Mar 21 '11 at 22:32
I was assuming that you would replace the it with the code I suggested. – thenengah Mar 21 '11 at 22:35
Yep but I need the full object too, don't see the use in doing an extra query for data I already have. Also I can't find any docs on .select, is it part of ActiveRecord? – bcoughlan Mar 21 '11 at 22:40
you need to override to_json in your model then. Check the update. – thenengah Mar 21 '11 at 22:46