# Problema con named scope

**URL:** <https://www.ruby-forum.com/t/problema-con-named-scope/209980>\
**Category:** IT\
**Created:** [July 27, 2011, 3:48pm UTC](https://www.ruby-forum.com/t/problema-con-named-scope/209980 "2011-07-27T15:48:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dubstep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/cdc98d/32.png) [@dubstep](https://www.ruby-forum.com/u/dubstep)\
**Post date:** [July 27, 2011, 3:48pm UTC](https://www.ruby-forum.com/t/problema-con-named-scope/209980/1 "2011-07-27T15:48:09Z")

</div>

Ciao a tutti, sto provando a fare una cosa con i named scope ho il  
segente  
model:

class Customer \< ActiveRecord::Base  
validates :name, :presence =\> true  
validates\_numericality\_of :box, :greater\_than\_or\_equal\_to =\> 0  
validates\_uniqueness\_of :box

has\_many :subscriptions  
has\_many :titles, :through =\> :subscriptions

scope :unsubscribed, Title.all - self.titles

def self.search(search)  
if search  
where(‘name LIKE ?’, “%#{search}%”)  
else  
all  
end  
end  
end

Praticamente vorrei definire uno scope che mi permetta di avere l’elenco  
dei  
titoli non sottoscritti, possibile? Sto sbagliando qualche cosa?

Al momento sto usando un’altra soluzione, attraverso una funzione nel  
modello, ma volevo provare a tradurla in un pi elegante e coinciso named  
scope.

–  
Mentre noi dormiamo, il dolore che sempre presente in noi cade goccia  
a goccia sul nostro cuore, finch contro la nostra stessa volont, la  
maestosa grazia di Dio non converte in saggezza la nostra disperazione  
(ESCHILO)

L’esperienza quello che ottieni quando, non ottieni quello che  
desideri.

---

<div class="post-metadata">

**Author:** ![riccardo\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/90ced4/32.png) [@riccardo\_l](https://www.ruby-forum.com/u/riccardo_l)\
**Post date:** [July 28, 2011, 8:01am UTC](https://www.ruby-forum.com/t/problema-con-named-scope/209980/2 "2011-07-28T08:01:18Z")

</div>

Mi sa’ che quel named scope deve fare una JOIN sulla  
customers\_subscriptions table.  
Prova a guardare la risposta a questo:  
[http://stackoverflow.com/questions/166217/rails-named-scopes-with-joins](http://stackoverflow.com/questions/166217/rails-named-scopes-with-joins)

ceo

2011/7/27 Duncan [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

> a goccia sul nostro cuore, finch contro la nostra stessa volont, la  
> maestosa grazia di Dio non converte in saggezza la nostra disperazione  
> (ESCHILO)
> 
> L’esperienza quello che ottieni quando, non ottieni quello che desideri.
> 
> * * *
> 
> Ml mailing list  
> [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> [http://lists.ruby-it.org/mailman/listinfo/ml](http://lists.ruby-it.org/mailman/listinfo/ml)

–  
Enrico T.  
IT consultant, accessible web sites and web applications  
currently working @ [http://www.redant.com.au](http://www.redant.com.au)  
Sydney, NSW, Australia  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
mobile (AU) +00610416748450

> **[Enrico Teotti | Technical & Product Consultant](https://teotti.com)**
>
> Technical coach and product management consultant with 20+ years bridging software development and product management across the US, Europe, and Australia. I help teams through strategy, facilitation, and hands-on guidance.

---

<div class="post-metadata">

**Author:** ![riccardo\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/90ced4/32.png) [@riccardo\_l](https://www.ruby-forum.com/u/riccardo_l)\
**Post date:** [July 28, 2011, 9:05am UTC](https://www.ruby-forum.com/t/problema-con-named-scope/209980/3 "2011-07-28T09:05:02Z")

</div>

On Thu, Jul 28, 2011 at 8:00 AM, Enrico T.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)wrote:

> Mi sa’ che quel named scope deve fare una JOIN sulla  
> customers\_subscriptions table.  
> Prova a guardare la risposta a questo:  
> [http://stackoverflow.com/questions/166217/rails-named-scopes-with-joins](http://stackoverflow.com/questions/166217/rails-named-scopes-with-joins)
> 
> ceo

Grazie, appena posso provo. 😃