filter output with a loop: if {entry_id} not in array

Question

Within a loop, I need to output different info according to whether an entry is in an array of id's or not.

I currently get the id's from a query on the matrix table.

So I need something like this:

{exp:channel:entries channel="article"}

{if entry_id not in (ids)}
    //some output
{if: else}
    //some other output
{/if}

{/exp:channel:entries}

I can't use stash, and I can't figure how to do this with PHP/embedded templates/query tag, I think the parse order is a problem.

Here is the query I use to get the entries to filter on:

SELECT entry_id FROM exp_channel_titles
WHERE entry_id in 
(SELECT `child_entry_id` FROM (`exp_playa_relationships`)
WHERE `parent_field_id` =  '{embed:parent_field_id}'
ORDER BY `rel_order`)

Answer 1

Are you using version 2.9+? Which is the separator?

Let's pretend you're and the separator is ,, giving you something like 1,2,3,4,5. Let's use the contains and the concatenation operators.

Using Query Module

{exp:query sql="SELECT GROUP_CONCAT(entry_id SEPARATOR ',') AS array_of_ids FROM exp_matrix_data WHERE [...]" parse="inward"}

    {exp:channel:entries channel="article"}

    {if ",".array_of_ids."," *= ",".entry_id.","}
        //some output
    {if: else}
        //some other output
    {/if}

    {/exp:channel:entries}

{/exp:query}

Using {exp:playa:child_ids}

{exp:channel:entries channel="article"}

{if ","."{exp:playa:child_ids entry_id='{embed:parent_field_id}' field_id='XXXX' delimiter=','}"."," *= ",".entry_id.","}
    //some output
{if: else}
    //some other output
{/if}

{/exp:channel:entries}

Answer 2

If your goal is separate these specific entries and output them differently, use categories. You can then have content editors easily select (from the entry_form) entries that should be treated as such. You could have just a single category for this channel. Say it had category_id 10:

{exp:channel:entries channel="article"}

    {categories}

        {if category_id == "10"}
            // Special output, in our special group
        {if:else}
            // Regular output, not so special
        {/if}

    {/categories}

{/exp:channel:entries}

Edit

Ok, you get this info from a matrix field. How do you fetch it? Is it via a {exp:query} tag, or do you get it from another {exp:channel:entries} loop? I possibly smell a terrible PHP answer coming your way. Please continue to expand on your question with details.