Remove/merge duplicate results

[taotoo]

I have three types of content, with two page reference fields linking them.

                          work

                    /                  \

work_exhibition      work_artist

           /                                   \

exhibition                            artist

On the Exhibition template, I want to show all artists that appear in an exhibition, and beneath each artist all works that are both by them and in the exhibition.

I have the following code:

<?php foreach ($pages->find("template=work, work_exhibition=$page->path") as $workIds):?>

	<?php foreach ($pages->find("template=artist, title={$workIds->work_artist->title}") as $artist):?>

		<strong><?= $artist->title; ?></strong><br>

		<?= $workIds->title; ?><br><br>

	<?php endforeach; ?>

<?php endforeach; ?>

Which is giving me (e.g.):

Artist 1
Work

Artist 1
Work

Artist 2
Work

I'd like it to instead show:

Artist 1
Work
Work

Artist 2
Work

I've tried using "->unique()" but wasn't sure where to put it. Or maybe I need to go about this some other way. Any pointers appreciated.

[Robin S]

I read your post a few times but wasn't able to grasp exactly how you have this set up.

In case it helps, here is how I would tend to approach this...

Work template: has Page Reference field for Artist

Exhibition template: has Page Reference field for Works

Then in your Exhibition template file:

$artist = '';
foreach($page->works->sort('artist') as $work) {
    if($work->artist->title !== $artist) {
        $artist = $work->artist->title;
        echo "<h3>$artist</h3>";
    }
    echo "<p>$work->title</p>";
}

 

[taotoo]

Thank you Robin - I could have been clearer, both page reference fields are on the Work template:

work
- work_exhibition
- work_artist

[Robin S]

In that case:

$artist = '';
foreach($pages->find("template=work, work_exhibition=$page, sort=work_artist.title") as $work) {
    if($work->work_artist->title !== $artist) {
        $artist = $work->work_artist->title;
        echo "<h3>$artist</h3>";
    }
    echo "<p>$work->title</p>";
}

 

[taotoo]

That works great - I'll now go through your code and attempt to understand what it's doing - thank you!

[Robin S]

9 minutes ago, taotoo said:

I'll now go through your code and attempt to understand what it's doing

// Initialise artist name variable
$artist = '';
// Find "work" pages that have this exhibition selected in their "work_exhibition" field
// and sort them according to the title (i.e. name) of the artist
// Iterate over those works...
foreach($pages->find("template=work, work_exhibition=$page, sort=work_artist.title") as $work) {
    // If the name of this work's artist is different to $artist
    if($work->work_artist->title !== $artist) {
        // Then store the artist's name in $artist
        $artist = $work->work_artist->title;
        // And output a heading
        echo "<h3>$artist</h3>";
    }
    // Output the title of the work
    echo "<p>$work->title</p>";
}

 

[taotoo]

10 hours ago, Robin S said:

// Initialise artist name variable
$artist = '';
// Find "work" pages that have this exhibition selected in their "work_exhibition" field
// and sort them according to the title (i.e. name) of the artist
// Iterate over those works...
foreach($pages->find("template=work, work_exhibition=$page, sort=work_artist.title") as $work) {
    // If the name of this work's artist is different to $artist
    if($work->work_artist->title !== $artist) {
        // Then store the artist's name in $artist
        $artist = $work->work_artist->title;
        // And output a heading
        echo "<h3>$artist</h3>";
    }
    // Output the title of the work
    echo "<p>$work->title</p>";
}

 

I've been staring at this for a while and finally figured out why it works - very clever!