Produce a list of entries that have no relationship parents

Question

I've got an EE 2.6 site that has pages (no duh) as entries, and some of those pages have children (i.e. via a relationship field).

Now, what I'd like to do is generate a list of the pages that do not have parents. But I don't see any way to do this. I would prefer native related entries, but would be fine with using Playa... but it doesn't seem to offer this functionality either. Am I stuck with using a query?

Thanks!

Answer 1

You can use query module also like:

{exp:query sql="SELECT exp_channel_titles.entry_id, exp_channel_titles.title FROM exp_channel_titles LEFT JOIN exp_relationships ON exp_channel_titles.entry_id=exp_relationships.rel_child_id WHERE exp_relationships.rel_child_id IS NULL AND exp_channel_titles.channel_id=1 AND exp_channel_titles.status='open'"}

{entry_id} :: {title}

{/exp:query}

Check the WHERE condition having "channel_id" and "status", you can change according to your preference.

Answer 2

Travis -

Throw this into a blank template, replace the field name of course:

    <h2>pt_playa="IS_EMPTY"</h2>

{exp:channel:entries search:pt_playa="IS_EMPTY"}

{title}<br />

{/exp:channel:entries}

<hr />

<h2>pt_playa="not IS_EMPTY"</h2>

{exp:channel:entries search:pt_playa="not IS_EMPTY"}

{title}

{/exp:channel:entries}

You'll see that search can help you here, at least if I am understanding correctly :) But I think I may be reversed from what you want.

My testing was done with a Playa relationship field....

-Lisa P&T