Thread

I need a conditional that will look in a channel to see if any entries are status=open or not. Like this:

{if "a certain channel has any open entries"}Display this static text{/if}

I don’t know if this can be done, or how. The text I want to display is a link to a channel, and should only appear if there are open entries. But I am not displaying entry fields in there, just this static link.

I’ve done this to do something similar:

{exp:channel:entries
    channel="articles"
    status="open"
}
{if count == 1}Yes there are open entries{/if}
{/exp:channel:entries}

But it may be more efficient to use the query module, like this:

{exp:query sql="SELECT status FROM exp_channel_titles WHERE status = 'open' LIMIT 1"}
Yes there are open entries.
{/exp:query}

Oops, be sure to include the channel ID in the query if you go with the second approach.

Ah, that first approach looks like what I need. Perfect. Now my client doesn’t need to ask me to edit the nav bar template if she decides to take a channel of her site offline. Yippie! Thanks a bunch.

Glad Kevin was able to help. Feel free to start a new thread if you have any more questions.