Thread

This question may be related to a resolved thread.

I’d like my related entries to only show entries which have a status=“Open”. This Bug Report talks about using a conditional as a workaround, but please can someone explain what code I need to use. Many thanks

Hi berkeley,

Pretty sure something like this should do it for you :

{related_entries id="my-related-field"}

{if status == "closed"}
THIS ENTRY SHOULD NOT SHOW!!
{if:else}
<h2>{title}</h2>
<p>{/if}</p>

<p>{/related_entries}

Perhaps better code to use though would be this :

{related_entries id="my-related-field"}

{if status != "closed"}
<h2>{title}</h2>
<p>{/if}</p>

<p>{/related_entries}

That should just show all entries that don’t have their status set to closed.

Hope that helps.

Best wishes,

Mark

Also be very weary that even though in the control panel the Open and Closed statuses show with a capital first letter they are actually stored in the database with a small first letter so you will need to use those in the conditional as I showed above.

Marvellous! Cheers Mark that did the trick - I knew the answer was fairly straightforward just wasn’t sure whereabout the if bit should go. And thanks too for the tip-off about the use of capital letters - I was using status=“Open” on my search form and it seemed to work, but I’ll amend to a small ‘o’
Thanks again
Ant

Hi Ant,

No problem at all. Glad that’s all working for you now.

Actually regarding the Open / open Closed / closed part I myself would like to hear from a moderator as to whether this is important or not as I know that in some cases it could be but perhaps others it isn’t? Seems like that really should be cleared up somewhere.

Best wishes,

Mark

First off, thanks for helping out, Mark.

You’re best off using lowercase.  The database stores them in lowercase and PHP comparisons are case sensitive (advanced conditionals).  In the cases where it’s used in a query it depends on the database table collation.  For a query on a case insensitive table (utf8_general_ci, for example) it won’t make a difference.  Hope that makes a bit of sense.

berkeley, please don’t hesitate to post again as needed.