activerecord - Rails using 'where' to search association -


i want select notices belong character via has_one association have nil supernotice. how code this?

notice.rb:

belongs_to :character  has_one  :active_comment_relationship, class_name: "commentrelationship",                                        foreign_key: "commenter_id",                                        dependent: :destroy has_one  :supernotice, through: :active_comment_relationship,                        class_name: "notice",                        source: :commentee accepts_nested_attributes_for :active_comment_relationship  has_many :passive_comment_relationships, class_name: "commentrelationship",                                          foreign_key: "commentee_id",                                          dependent: :destroy has_many :comments, through: :passive_comment_relationships,                     class_name: "notice",                     source: :commenter

character.rb:

has_many :notices  def topnotices   self.notices.where(supernotice: nil)  # doesn't work end

logs:

: select "notices".* "notices" "notices"."character_id" = $1 , "notices"."commentee_id" null  order "notices"."created_at" desc completed 500 internal server error in 316ms (activerecord: 12.0ms)  activerecord::statementinvalid (pg::undefinedcolumn: error:  column notices.commentee_id not exist line 1: ..."notices" "notices"."character_id" = $1 , "notices"....

the logs show error notices.commentee_id not exist, i've stated in notice.rb notice has_one :supernotice through: :active_comment_relationship. going wrong?

you need add:

has_many :notices

in character model.


-

Comments

Post a Comment

Popular posts from this blog

dns - Dokku server hosts two sites with TLD's, both domains are landing on only one app -

i have 2 simple dokku sites on 1 server. first static html site, , second simple rails app. each app has own tld. sake of argument give them domains: static.com , rails.com. ive used dokku domains plugin set both naked , 'www' domains each site. domain names purchased , setup through namecheap the namecheap domains each have 2 entries: @ | http://www.static.com | url redirect www | static.server.com | cname(alias) @ | http://www.rails.com | url redirect www | rails.server.com | cname(alias) i encountered this issue on dokku github page indicate can overcome using naked domain app name when creating original git remote. git remote add dokku dokku@server.com:static.com however, issue closed 2 years ago, , same result seems accomplished domains plugin. im wondering if should restart point both apps? so far above steps has resulted in traffic both domains being sent static.com. has encountered before? t...
Read more

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more