Q re: nested conditional with grid rows

Question

I've got a Grid field (EE2.11) where one of the columns is called "Open?" with a checkbox for "Closed" so I can turn a row off and on. I'm using a nested conditional to first filter out anything that's marked closed, then a simple conditional within that, like this simplified version:

    {exp:channel:entries channel="samples"}
        {sample_grid}
            {if sample_grid:open <> "Closed"}
                {if sample_grid:videolink == ""}
                    {sample_grid:description}
                {if:else}
                    {sample_grid:videolink}
            {/if}
        {/sample_grid}
    {/exp:channel:entries}

So two questions: (1) is there a better way to turn Grid rows off and on (I was wishing for something I could put in the channel entries tag to do the filtering)? and (2) is there a better way to filter out the closed rows than with a nested conditional?

It's all working fine, I'm just wondering if there is some performance issue with this, or if this all seems like a good way to do this.

Answer 1

To do the searching you can simply replace the outer conditional with a search tag (which has the same syntax as the channel entries search tag). The {if} tag is pretty efficient in 2.11 so not an unreasonable method for the either / or switch. Something like:

{exp:channel:entries channel="samples"}
    {sample_grid search:open="not Closed"}
        {if sample_grid:videolink == ""}
            {sample_grid:description}
        {if:else}
            {sample_grid:videolink}
        {/if}
    {/sample_grid}
{/exp:channel:entries}

HTH