# Rails: uno scope per query complesse

**URL:** <https://www.ruby-forum.com/t/rails-uno-scope-per-query-complesse/154841>\
**Category:** IT\
**Created:** [December 4, 2008, 11:32am UTC](https://www.ruby-forum.com/t/rails-uno-scope-per-query-complesse/154841 "2008-12-04T11:32:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![giorgian](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/2acd7d/32.png) [@giorgian](https://www.ruby-forum.com/u/giorgian)\
**Post date:** [December 4, 2008, 11:32am UTC](https://www.ruby-forum.com/t/rails-uno-scope-per-query-complesse/154841/1 "2008-12-04T11:32:13Z")

</div>

salve a tutt,

dato che sto sviluppando su MS SQL, ho deciso per varie ragioni di  
usare il servizio di indicizzazione fulltext del server, invece di  
affidarmi a tool esterni.

ora: ho delle query come questa:

Contact.find\_by\_sql “SELECT contacts.\*, ft.RANK FROM contacts INNER  
JOIN CONTAINSTABLE(contacts, _, '"p_”’) as ft on ft.[KEY] =  
contacts.id"}

c’è modo di piazzare questa roba in un named scope o simili, in modo  
da non riscriverla tutte le volte e da poter poi raffinarla  
combinandola con altri named scope, associazioni, etc.?