article_custom from both categories (AND)

Bloke · 2018-11-10 13:14:41

Forgive me for being dim, but I’m having a moment. How can I use <txp:article_custom> to output articles that match BOTH categories when I supply two:

<txp:article_custom section="stock" limit="999" category='location, type'>
   ...
</txp:article_custom>

I’m setting category1 = ‘location’ and category2=‘type’ in the articles and I’m trying to output a series of tables that contain articles from each location (h2) and type (h3)- it’s a stocklist. I tried to do it in one giant article_custom call sorted by category2,category1 and then use if_different to show the headings but things fall apart when constructing the end table/tbody in the loop.

So far the closest I can get is this:

<txp:category_list parent="location" sort="title desc" exclude="location">
    <txp:variable name="n_location"><txp:category /></txp:variable>
    <h2><txp:category title /></h2>
    <txp:category_list parent="type" sort="title desc" exclude="type">
        <txp:variable name="n_type"><txp:category /></txp:variable>
        <h3><txp:category title /></h3>
        <table>
            <thead>
                <tr>
                <th>Serial number</th>
                <th>Year</th>
                <th>Condition</th>
                <th>Price</th>
                </tr>
            </thead>
            <tbody>
            <txp:article_custom section="stock" limit="999" category='<txp:variable name="n_location" />, <txp:variable name="n_type" />'>
            <tr>
                <td><txp:custom_field name="Serial number" /></td>
                <td><txp:custom_field name="Year" /></td>
                <td><txp:custom_field name="Condition" /></td>
                <td><txp:custom_field name="Price" /></td>
            </tr>
            </txp:article_custom>
            </tbody>
        </table>
    </txp:category_list>
  </txp:category_list>

But that’s outputting the same stuff in each group because it’s matching category1 OR category2. Anyone any ideas how I can approach this? I don’t mind any solution but I’d rather not have to revert to PHP unless I have to.

It’d also be great to output the custom field names instead of hard-coding the headings but I can live with it for now.

Thank you in advance.

(Txp 4.7.1, btw)

etc · 2018-11-10 13:21:49

Dunno if it helps here, but you can set match="Category1" in <txp:article_custom /> to match only… suspense… Category1.

Bloke · 2018-11-10 13:28:16

Thanks, yeah. Not sure it does actually help here because I don’t really want to nest article_custom calls. But I guess I could.

Another addendum to this is that I’d like to pull out only articles where custom_3 (price) does NOT match the word SOLD. So this stocklist only shows for-sale items in the shop, but if you visit the section it can still show the products sold as well.

I can’t figure out how to say ‘custom_3 not SOLD’. I’ve tried the usual suspects but NOT seems to negate everything including the section and category attributes in the tag!

Ideas welcome.

etc · 2018-11-10 13:32:03

Have you tried

<txp:article_custom price="SOLD" exclude="price" />

Bloke · 2018-11-10 13:43:45

etc wrote #315148:

<txp:article_custom custom3="SOLD" exclude="custom3" />...

Good idea. Never thought of trying that. Sadly it didn’t seem to work as I still get SOLD articles in the list:

<txp:article_custom section="stock" limit="999" category='<txp:variable name="n_location" />, <txp:variable name="n_type" />' sort="custom_2 asc" custom3="SOLD" exclude="custom3">
   ...
</txp:article_custom>

Hmmm…

etc · 2018-11-10 13:49:41

Bloke wrote #315147:

I don’t really want to nest article_custom calls.

You wouldn’t nest but duplicate, though it’s not ideal:

<txp:variable name="ids">
    <txp:article_custom section="stock" limit="999" category='<txp:variable name="n_location" />' match="Category1" break=",">
        <txp:article_id />
    </txp:article_custom>
</txp:variable>

<txp:article_custom id='<txp:variable name="ids" />' section="stock" limit="999" category='<txp:variable name="n_type" />' match="Category2">
    <tr>
        <td><txp:custom_field name="Serial number" /></td>
        <td><txp:custom_field name="Year" /></td>
        <td><txp:custom_field name="Condition" /></td>
        <td><txp:custom_field name="Price" /></td>
    </tr>
</txp:article_custom>

The variable definition must be outside the second category_list, of course.

etc · 2018-11-10 13:50:47

Bloke wrote #315149:

Good idea. Never thought of trying that. Sadly it didn’t seem to work as I still get SOLD articles in the list:

Sorry, it must be the custom field name, e.g. price if you have named it so:

<txp:article_custom price="SOLD" exclude="price" />

Bloke · 2018-11-10 13:54:09

etc wrote #315151:

Sorry, it must be the custom field name

D’oh, of course. Genius. That’s one issue solved. I’ll remember that trick, thank you.

Now just the dual category somehow.

etc · 2018-11-10 13:56:21

Independently, it would be easy to replace OR with AND when needed, we just need a syntax:

match="Category1 Category2", match="Category1+Category2", match="Category1&Category2", ...?

etc · 2018-11-10 13:58:50

Bloke wrote #315152:

Now just the dual category somehow.

I think this could work. It adds one db query per location, but the query inside the second category_list should use ID index and be fast.

Textpattern CMS

Textpattern CMS support forum

#1 2018-11-10 13:14:41