Sorry for the delay in replying to this.
There are a few things to note:
* sphinx_scopes should return a hash. In your example, you're defining
one hash, and then returning another - so the :include condition won't
be used.
* Also, you're using a table name in or order statement, which won't
mean anything to Sphinx. Try the following:
sphinx_scope(:ordenado_por_fecharecepcion) {
{
:include => :movimientos,
:order => 'fecharecepcion DESC'
}
}
* You can't use arrays in :conditions (['numero = ?', numero]). That
is for SQL syntax, and Sphinx will not understand it.
Hope this is helpful.
--
Pat
On 24/08/2009, at 3:56 PM, movihus wrote:
>
> Hello everybody, I'm having troubles trying to user sphinx_scope.
> I need to order the results of a query by a column of an associated
> table y I think sphinx_scope may help, Let's me explain the situation:
>
> I got two objects called Expedientes and Movimientos.
>
> Expedientes:
> id integer
> numero integer
> fechaentrada date
> ...
>
> Movimientos
> id integer
> expediente_id integer
> fecharecepcion date
> horarecepcion time
> ...
>
> I need to query an Expediente and order by the column
> Movimiento.fecharecepcion and Movimiento.horarecepcion in DESC order.
>
> I create a sphinx_scope in Expediente's model:
>
> sphinx_scope(:ordenado_por_fecharecepcion) {
> {:include => :movimientos}
> {:order => 'movimientos.fecharecepcion DESC'}
> }
>
> In the Controller, where I perform the query:
>
> @expedientes = Expediente.ordenado_por_fecharecepcion.search(buscar,
> :include => :expediente,
> :conditions => {:numero
> => "#{anyo_busq}*", :estado_id => estado, :oficinaactual_id =>
> oficina_id },#['numero = ?, expeentradas.estado:id = ?,
> oficinaactual_id = ?', "#{anyo_busq}*", estado, oficina_id],
> :page => params[:page],
> :per_page => 10)
>
> How you can see I using some conditions to perform the query, I tryeid
> on console with Expediente.search('something') and returned me
> results, but when I try like this
> Expediente.ordenado_por_fecharecepcion.search('something') didn't
> return nothing.
>
> If there another way to do what I'm trying please make know.
>
> Thanks any help in advance.
>
> P.D.: Sorry my bad english.
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
