Using Perch Custom to pull only unique items from list?

bj.lewis221 · Nov 4th 2019

Is there a way to pull only unique items once?
I have a list of properties and each has a "brand" and I want to list those brands without having duplicates show up in the "brand" list that is separate from the properties list/

Example I have a list

A

A

B

C

D

D

But I want to output A, B, C, D

How would I do that?

Thanks in advance!

Byron Fitzgerald · Nov 4th 2019

You could perhaps you the perch if tag, with the different attribute.

Code

<perch:if different="brand">
<h2><perch:content id="brand" type="text"></h2>
</perch:if>

bj.lewis221 · Nov 4th 2019

Quote from Byron Fitzgerald

You could perhaps you the perch if tag, with the different attribute.

Code

<perch:if different="brand">

<h2><perch:content id="brand" type="text"></h2>

</perch:if>

This works! Thank you so much!

bj.lewis221 · Nov 4th 2019

Well it worked for one template but not the other. I did the exact same template just swapped out the ID

bj.lewis221 · Nov 5th 2019

Ok, so it worked on one and I got it to work on another but now its duplicating them again.

Here is my main template

PHP

<perch:content type="text" id="propertybrand" label="Property Brand" required suppress>
<div class="card [ is-collapsed ] box brand-filter location-filter <perch:content id="propbrandfilter" type="composite" for="propertybrand" format="C:3"> <perch:content id="statefilter" type="composite" for="state" format="C:3" >">
<div class="card__inner [ js-expander ]">
<div class="overlay">
<div class="otext"><perch:content id="propname" type="text" label="Property Name" title="true" required></div>
</div>
<img src="<perch:content id="proppic" type="image" label="Property Image" crop="true" width="640" height="480">" width="100%">
</div>
<div class="card__expander">
<i class="fa fa-close [ js-collapser ]" aria-hidden="true"></i>
<div class="innercard"><img src="<perch:content id="proppic" type="image" label="Property Image" crop="true" width="960" height="640" order="1">" width="100%"></div>
<div class="innercard intext">
<div class="intexthead"><h3><perch:content id="propname" type="text" label="Property Name" title="true" required></h3></div>
<perch:if exists="propaddress"><p><perch:content id="propaddress" type="text" label="Property Address" help="Example: 123 Main St."></perch:if><perch:if exists="propcity">, <perch:content id="propcity" type="text" label="Property City"></perch:if><perch:if exists="state">, <perch:content id="state" type="select" label="State" options="Alabama, Alaska, American Samoa, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Guam, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Minor Outlying Islands, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Northern Mariana Islands, Ohio, Oklahoma, Oregon, Pennsylvania, Puerto Rico, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, U.S. Virgin Islands, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming" allowempty="false" required></perch:if><perch:if exists="propzip"> <perch:content id="propzip" type="text" label="Zip Code"></perch:if><perch:if exists="propphone"><br><perch:content id="propphone" type="text" label="Property Phone Number" help="Example: (555) 555-5555"></p></perch:if>
<perch:if exists="propinfo"><perch:content id="propinfo" type="textarea" label="Property Information" html="true" markdown editor="redactor"></perch:if>
<perch:if exists="propurl"><div class="intexthead"><a class="button button-primary2" href="<perch:content id="propurl" type="text" label="Property Website URL" >" target="_blank">Visit Website</a></div></perch:if>
</div>
</div>
</div>
<perch:showall>

Display More

here are my templates where it includes the different

PHP

<perch:if different="propertybrand"><button class="btn button button-secondary" id="<perch:content id="propbrandfilter" type="composite" for="propertybrand" format="C:3">"><perch:content type="text" id="propertybrand" label="Property Brand" required></button> </perch:if>

PHP

<perch:if different="state"><button class="btn button button-secondary" id="<perch:content id="statefilter" type="composite" for="state" format="C:3" >"><perch:content id="state"></button>
</perch:if>

This is my .php page

PHP

<div class="section white p100">
<div class="row">
<div class="twelve columns center ptb30">
<button class="btn button button-primary" id="brand-filter">Search by Brand</button>
<button class="btn button button-primary" id="location-filter">Search by Location</button>
<div class="brands hidden">
<?php perch_collection('Portfolio', ['template' => 'brand_filter.html', ]);?>
</div>
<div class="locations hidden" >
<?php perch_collection('Portfolio', ['template' => 'state_filter.html', ]);?>
</div>
</div>
</div>
<div class="row">
<div class="twelve columns">
<div id="cards" class="cards">
<?php perch_collection('Portfolio'); ?>
</div>
</div>
</div>
</div>

Display More

bj.lewis221 · Nov 5th 2019

ah nope its duplicating them on both now

hus_hmd · Nov 5th 2019

Byron's solution should work well if you alphabetically sort by the field:

PHP

perch_collection('Portfolio', [
'sort' => 'brand',
'sort-order' => 'ASC',
'template' => 'brand_filter.html',
]);

bj.lewis221 · Nov 5th 2019

Quote from hus_hmd

Byron's solution should work well if you alphabetically sort by the field:

PHP

perch_collection('Portfolio', [

'sort' => 'brand',

'sort-order' => 'ASC',

'template' => 'brand_filter.html',

]);

Nothing shows up if I add this

bj.lewis221 · Nov 5th 2019

nvm! got it!