22033 0 true 2009-06-16T17:38:32-04:00 41518 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 37045 16601 resolved 2.0.0 2009-07-14T03:22:05-04:00 1368 Georg Ledermann etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 This is a duplicate of the ticket on github (maybe the wrong place to post tickeds ?) : http://github.com/binarylogic/searchlogic/issues#issue/2 Giving those models : User has_many :classifieds Classified User has the column "classifieds_count". The following search throws an error, because Searchlogic seems to ignore User.classifieds_count column and try to search on the associated Classified model : User.classifieds_count_greater_than(5) undefined method `count_greater_than' for #<Class:0x3db9234> Thanks Emilien This is a duplicate of the ticket on github (maybe the wrong place to post tickeds ?) : http://github.com/binarylogic/searchlogic/issues#issue/2 Giving those models : User has_many :classifieds Classified User has the column "classifieds_count". The following search throws an error, because Searchlogic seems to ignore User.classifieds_count column and try to search on the associated Classified model : User.classifieds_count_greater_than(5) undefined method `count_greater_than' for #<Class:0x3db9234> Thanks Emilien <div><p>This is a duplicate of the ticket on github (maybe the wrong place to post tickeds ?) : <a href="http://github.com/binarylogic/searchlogic/issues#issue">http://github.com/binarylogic/se...</a>/2</p> <p>Giving those models : User has_many :classifieds Classified</p> <p>User has the column "classifieds_count".</p> <p>The following search throws an error, because Searchlogic seems to ignore User.classifieds_count column and try to search on the associated Classified model : User.classifieds_count_greater_than(5)</p> <p>undefined method <code>count_greater_than' for #</code></p> <p>Thanks Emilien</p></div> 22033 0 This is a duplicate of the ticket on github (maybe the wrong place to post tickeds ?) : http://github.com/binarylogic/searchlogic/issues#issue/2 Giving those models : User has_many :classifieds Classified User has the column "classifieds_count". The following search throws an error, because Searchlogic seems to ignore User.classifieds_count column and try to search on the associated Classified model : User.classifieds_count_greater_than(5) undefined method `count_greater_than' for #<Class:0x3db9234> Thanks Emilien <div><p>This is a duplicate of the ticket on github (maybe the wrong place to post tickeds ?) :<br> <a href= "http://github.com/binarylogic/searchlogic/issues#issue/2">http://github.com/binarylogic/searchlogic/issues#issue/2</a></p> <p>Giving those models :<br> User has_many :classifieds<br> Classified</p> <p>User has the column "classifieds_count".</p> <p>The following search throws an error, because Searchlogic seems to ignore User.classifieds_count column and try to search on the associated Classified model :<br> User.classifieds_count_greater_than(5)</p> <p>undefined method <code>count_greater_than' for #&lt;Class:0x3db9234&gt;</code></p> <p>Thanks<br> Emilien</p></div> false 2009-06-16T17:38:32-04:00 41518 --- {} 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 new 2.0.0 2009-06-16T17:38:35-04:00 41518 etaque (at gmail) etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 22033 0 Good find, for this I feel like "xxx_count" is obviously a standard, so making a exception for columns like that wouldn't be a huge deal. Also, my regex checks should check the column first anyways. I'll look into this though. <div><p>Good find, for this I feel like "xxx_count" is obviously a standard, so making a exception for columns like that wouldn't be a huge deal. Also, my regex checks should check the column first anyways. I'll look into this though.</p></div> false 2009-06-20T04:58:51-04:00 41518 --- :state: new 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 open 2.0.0 2009-06-20T04:58:52-04:00 22033 Ben Johnson etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 22033 0 Simimilar problem here: @@@ ruby class Debt < ActiveRecord::Base belongs_to :creditor, :class_name => 'Contact', :foreign_key => 'creditor_contact_id' belongs_to :creditor_ledger, :class_name => 'Ledger', :foreign_key => 'creditor_ledger_id' end Debt.search(:creditor_ledger_id => 123) # => NoMethodError: undefined method `ledger_id_equals' for #<Class:0x268a720> @@@ ruby <div><p>Simimilar problem here:</p> <pre> <code class="ruby">class Debt &lt; ActiveRecord::Base belongs_to :creditor, :class_name =&gt; 'Contact', :foreign_key =&gt; 'creditor_contact_id' belongs_to :creditor_ledger, :class_name =&gt; 'Ledger', :foreign_key =&gt; 'creditor_ledger_id' end Debt.search(:creditor_ledger_id =&gt; 123) # =&gt; NoMethodError: undefined method `ledger_id_equals' for #&lt;Class:0x268a720&gt;</code> </pre></div> false 2009-07-06T12:48:30-04:00 41518 --- {} 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 open 2.0.0 2009-07-06T12:48:31-04:00 1368 Georg Ledermann etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 22033 0 Did anyone come up with a quick fix for this bug? I would love to have it! Please let me know! <div><p>Did anyone come up with a quick fix for this bug? I would love to have it! Please let me know!</p></div> false 2009-07-07T10:42:11-04:00 41518 --- {} 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 open 2.0.0 2009-07-07T10:42:12-04:00 49070 Joost etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 22033 0 To fix this change line 83 of named_scopes/associatiions.rb to: @@@ruby {:order_as => $1, :association => $2, :column => $3} unless column_names.include?("#{$2}_#{$3}") @@@ <div><p>To fix this change line 83 of named_scopes/associatiions.rb to:</p> <p>@@@ruby {:order_as =&gt; $1, :association =&gt; $2, :column =&gt; $3} unless column_names.include?("#{$2}_#{$3}")</p> <pre> </pre></div> false 2009-07-13T04:53:15-04:00 41518 --- {} 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 open 2.0.0 2009-07-13T04:53:20-04:00 49070 Joost etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 22033 0 This has been fixed. Thanks! <div><p>This has been fixed. Thanks!</p></div> true 2009-07-13T16:54:10-04:00 41518 --- :state: open 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 resolved 2.0.0 2009-07-13T16:54:11-04:00 22033 Ben Johnson etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92 22033 0 Works fine, thank you! <div><p>Works fine, thank you!</p></div> true 2009-07-14T03:22:04-04:00 41518 --- {} 92 conflict-with-a-scope-on-a-column-beginning-with-the-name-of-an-association 0 16601 resolved 2.0.0 2009-07-14T03:22:05-04:00 1368 Georg Ledermann etaque (at gmail) Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/92