Displaying a single entry by status but having a fallback order in place

Question

Hopefully this will just be a quick one and it maybe staring me in the face but what I want to be able to display a related testimonial of an entry.

If the testimonial has a custom status of Featured, then this will be displayed. If no testimonials have this status set, then it will revert to the latest testimonial added, presumably with a status of Open.

Can anyone help me out on how I can do this. Below is what I thought may do the trick

{if page_related_testimonials}

{page_related_testimonials 
 channel="testimonials" 
 status="Featured" 
 orderby="date" 
 sort="desc" 
 limit="2"}


    {if status=="Featured"}
    {title} 
    {if:elseif status=="open"}
    {title}
    {/if}   

{/page_related_testimonials}

 {/if}

Answer 1

If you are only trying to display a single featured entry and if no featured then a single entry with the status of open. I'd do the this. Order your results by status and allow featured and open status entries and then sort it to to look for featured first then open. I think that might be sort="asc"

So heres what your code will look like.

{if page_related_testimonials}

  {page_related_testimonials 
      channel="testimonials" 
      status="Featured|open" 
      orderby="status|date" 
      sort="asc|desc" 
      limit="1"
   }

      {title}

   {/page_related_testimonials}

{/if}

This will return 1 entry and if an entry related to that channel has the status of Featured it will be the first entry in the data returned if there isn't an entry with Featured it will fall back to an entry related with the status of Open. I hope this helps!

Answer 2

I've been done this sometimes, but not using relationships. I believe the process is the same.

Try to order the entries by both date and status. Each one in one direction.

status="featured|open" orderby="status|date" sort="asc|desc" limit="1"