issue with fixed_order and embed query

Question

I’m having some issues with the fixed_order parameter.

I’m running a query to order by a matrix col

{embed="_includes/_ajax_results" 
    entry_ids="{exp:query sql="SELECT entry_id FROM exp_channel_titles 
        INNER JOIN exp_matrix_data using(entry_id) 
        WHERE channel_id ='4' 
        AND field_id ='13'
        AND status ='open'
        ORDER BY col_id_21 DESC "}{entry_id}|{/exp:query}"} 

If I head to my embed template… and print {embed:entry_ids} I get my list of entry_ids in the correct order I need them

90|94|89|91|95|93|86|92|87|88|79| 

However as soon as I use this in a channel tag, it gets ignored and the order reverts to the default date order.

{exp:channel:entries 
 channel="strand" 
 dynamic="no" 
 disable="member_data|pagination" 
 cache="no" 
 fixed_order="{embed:entry_ids}"}

   {strand-overview}

{/exp:channel:entries} 

If i hard code my entry_id embed into the param, the order works…

{exp:channel:entries 
 channel="strand" 
 dynamic="no" 
 disable="member_data|pagination" 
 cache="no" 
 fixed_order="90|94|89|91|95|93|86|92|87|88|79|"}
   {strand-overview}
{/exp:channel:entries} 

so for some reason my {embed:entry_ids} isn’t working… Any ideas?

EE 2.5.3

Answer 1

I suspect it has something to do with the parse order of the tags. Could you try adding parse='inward' to your {exp:channel:entries} tag.

You can check if it is embedding the values or the entire {exp:query} tag if you turn on template debugging and look at how the entries tag is parsed.

– Wouter

Answer 2

First check to make sure your query is printing correctly outside of the embed code.

If it is returning results correctly, next look at your quotes. Try removing the quotes for the entry_ids parameter, so entry_ids="QUERY" becomes entry_ids=QUERY.