skip to main | skip to sidebar

{object: literal}

Showing posts with label query. Show all posts
Showing posts with label query. Show all posts

Tuesday, May 4, 2010

Finding uninvoiced fees in rails


# Models

Class InvoiceItem < ActiveRecord::Base
  belongs_to :fee
end

Class Fee < ActiveRecord::Base
  has_one :invoice_item
end

# Namedcope in Fee model

namedscope :uninvoiced, {
  :conditions => "fees.id NOT IN (SELECT fee_id FROM invoice_items)"
}
Posted by JasonOng at 12:09 AM No comments:
Labels: activerecord, query, rails
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2014 (5)
    • ▼  May (1)
      • Check PostgresSQL version
    • ►  March (2)
    • ►  February (2)
  • ►  2013 (6)
    • ►  November (3)
    • ►  February (2)
    • ►  January (1)
  • ►  2012 (42)
    • ►  December (2)
    • ►  November (1)
    • ►  October (9)
    • ►  September (1)
    • ►  August (9)
    • ►  July (3)
    • ►  June (7)
    • ►  May (4)
    • ►  March (1)
    • ►  February (4)
    • ►  January (1)
  • ►  2011 (29)
    • ►  December (1)
    • ►  October (2)
    • ►  September (2)
    • ►  July (1)
    • ►  June (2)
    • ►  May (3)
    • ►  April (2)
    • ►  March (2)
    • ►  February (3)
    • ►  January (11)
  • ►  2010 (102)
    • ►  December (21)
    • ►  November (5)
    • ►  October (3)
    • ►  September (4)
    • ►  August (3)
    • ►  July (5)
    • ►  June (5)
    • ►  May (10)
    • ►  April (5)
    • ►  March (17)
    • ►  February (12)
    • ►  January (12)
  • ►  2009 (143)
    • ►  December (1)
    • ►  November (10)
    • ►  October (26)
    • ►  September (68)
    • ►  August (20)
    • ►  July (15)
    • ►  April (3)
  • ►  2008 (2)
    • ►  March (2)