Assuming you're rendering this in e.g. an erb view: @my_users = User.all(:age.gt => 25) erb :view
... and in the view, when displaying your table and the org column... (pseudo code) @my_users.each |user| do <%= Organization.get(user.organization_id).name%> i'm not 100% this is correct, and I'm sure there's a more elegant way than calling the model directly in the view. But that's what I ted to do when elegance eludes me. On Saturday, December 1, 2012 2:26:43 AM UTC+1, Jai Kumar wrote: > > I have two tables > > users > ------- > id > name > organization_id > > > organizations > ---------- > id > org_name > org_unique_num > abc > xyz > > organization_id in users table is foreign key to organizations table's id > > class Organization > include DataMapper::Resource > property :id, Serial > property :org_name, String > property :org_unique_num, Integer > property :abc String > property :xyz String > has n, :users > end > > class User > include DataMapper::Resource > property :id, Serial > property :name, String > property :organization_id, Integer > property :age, Integer > belongs_to :organization > end > > I want to grab the user's record with joining Organization table where > user's age > 25. So the result should look like > > user_id name organization_id org_name org_unique_num age > 12 John 356 ATT 76763 > 38 > 35 Lisa 981 IBM 2376 > 28 > > So how can I achieve this? Please note I dont want column abc and xyz in > the result. > > User.all(:age.gt => 25) > > This will just give me users with age >25, but I want to grab user's org > info as well. Is it possible to do it one statement? or will have to do it > in multiple steps. Like collecting all user_id then pass to Organization > model to with org_id in().. that would be ugly. > > Any help will be appreciated. > -- You received this message because you are subscribed to the Google Groups "DataMapper" group. To view this discussion on the web visit https://groups.google.com/d/msg/datamapper/-/yHpEp--pQ1YJ. To post to this group, send email to datamapper@googlegroups.com. To unsubscribe from this group, send email to datamapper+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/datamapper?hl=en.