Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#231 2015-07-18 10:20:49

etc
Developer
Registered: 2010-11-11
Posts: 3,939
Website

Re: etc_query: all things Textpattern

The download server is currently offline, you can grab it on .org.

Offline

#232 2015-09-11 09:15:01

NicolasGraph
Plugin Author
From: France
Registered: 2008-07-24
Posts: 860
Website

Re: etc_query: all things Textpattern

Hi, I’m using the following code in an article form to pull the first quote from articles body :
(I know smd_pullquotes but I want to use etc_query which I already use on the project.)

<txp:etc_query data="{?body}" query="(//blockquote)[1]" wraptag="blockquote">
{p}{cite}
</txp:etc_query>

However, I would like to display only articles which contain blockquotes;

Help welcome, I’m not good with etc_query already…
Thanks!

Last edited by NicolasGraph (2015-09-11 09:23:21)


Nicolas
Follow me on Twitter and GitHub!
Multiple edits are usually to correct my frenglish…

Offline

#233 2015-09-11 09:40:46

etc
Developer
Registered: 2010-11-11
Posts: 3,939
Website

Re: etc_query: all things Textpattern

NicolasGraph wrote #294722:

Help welcome, I’m not good with etc_query already…

Hi Nicolas, me too, I’m afraid! :) Your code should already not display anything for articles without blockquotes, so I guess you want to retrieve from db only the articles containing blockquotes. I’m not sure you can do it with <txp:article(_custom) />, but with etc_query v.1.3 this should work:

<txp:etc_query data="Body_html LIKE '%</blockquote>%'" markup="db" populate="article">
	<txp:etc_query data='<txp:body />' specials="" query="//blockquote[1]" limit="1" wraptag="blockquote">
		{{p}}{{cite}}
	</txp:etc_query>
</txp:etc_query>

As you see, I have added limit="1" attribute, otherwise it could output multiple blockquotes if they had different parents. Note also double {{}} braces, to tell the external etc_query that they belong to the internal one.

Tell me if it helps (quickly tested). You can add AND Section='some_section' ORDER BY Posted DESC LIMIT 10 and so on to data attribute if needed.

Last edited by etc (2015-09-11 16:17:33)

Offline

#234 2015-09-11 10:01:34

NicolasGraph
Plugin Author
From: France
Registered: 2008-07-24
Posts: 860
Website

Re: etc_query: all things Textpattern

etc wrote #294723:

Tell me if it helps (quickly tested). You can add AND Section='some_section', ORDER BY Posted DESC LIMIT 10 and so on to data attribute if needed.

Thanks Oleg, you understood well what I’m trying to achieve but the limit attribute doesn’t work for me now.

Last edited by NicolasGraph (2015-09-11 10:04:03)


Nicolas
Follow me on Twitter and GitHub!
Multiple edits are usually to correct my frenglish…

Offline

#235 2015-09-11 16:24:26

etc
Developer
Registered: 2010-11-11
Posts: 3,939
Website

Re: etc_query: all things Textpattern

NicolasGraph wrote #294725:

the limit attribute doesn’t work for me now.

Which one? There is no comma in AND Section='some_section' ORDER BY Posted DESC LIMIT 10, sorry. It should work, unless some of the retrieved articles contain <txp:article_custom /> (it sticks on this article otherwise, patch in progress). And you shouldn’t put this code inside an article that contains <blockquote /> itself, or you’ll enter an infinite loop. Replacing data='<txp:body />' specials="" with data="{{?body}}" specials="data" should fix it though.

Offline

#236 2015-09-12 08:29:28

NicolasGraph
Plugin Author
From: France
Registered: 2008-07-24
Posts: 860
Website

Re: etc_query: all things Textpattern

etc wrote #294732:

Which one?

Sorry, I talked about the limit attribute above…

As you see, I have added limit=“1” attribute, otherwise it could output multiple blockquotes if they had different parents.

It outputs multiple blockquotes anyway…

Last edited by NicolasGraph (2015-09-12 08:29:51)


Nicolas
Follow me on Twitter and GitHub!
Multiple edits are usually to correct my frenglish…

Offline

#237 2015-09-12 08:54:03

etc
Developer
Registered: 2010-11-11
Posts: 3,939
Website

Re: etc_query: all things Textpattern

Ah, that’s interesting, you mean multiple blockquotes from the same article? Unless you have blockquotes within blockquotes… mind posting the html body of the concerned article?

Offline

#238 2015-09-12 09:12:04

NicolasGraph
Plugin Author
From: France
Registered: 2008-07-24
Posts: 860
Website

Re: etc_query: all things Textpattern

etc wrote #294743:

Ah, that’s interesting, you mean multiple blockquotes from the same article? Unless you have blockquotes within blockquotes… mind posting the html body of the concerned article?

No, in fact it displays only the first blockquote of the concerned articles bodies, but I can’t limit them to show only one (or whatever) blockquote like I could do with the following code if every articles would contain blockquotes…

<txp:article_custom limit="1" sort="rand()">
    <txp:etc_query data="{?body}" query="(//blockquote)[1]" wraptag="blockquote">
        {p}{cite}
    </txp:etc_query>
</txp:article_custom>

The only wrong thing with this code is that it displays nothing if the article doesn’t contain a blockquote.

Last edited by NicolasGraph (2015-09-12 09:13:48)


Nicolas
Follow me on Twitter and GitHub!
Multiple edits are usually to correct my frenglish…

Offline

#239 2015-09-12 09:16:50

etc
Developer
Registered: 2010-11-11
Posts: 3,939
Website

Re: etc_query: all things Textpattern

Ah, ok, then doesn’t this work as intended?

<txp:etc_query data="Body_html LIKE '%</blockquote>%' ORDER BY RAND() LIMIT 1" markup="db" populate="article">
	<txp:etc_query data='<txp:body />' specials="" query="//blockquote[1]" limit="1" wraptag="blockquote">
		{{p}}{{cite}}
	</txp:etc_query>
</txp:etc_query>

The external etc_query plays the role of article_custom here.

Offline

#240 2015-09-12 09:23:23

NicolasGraph
Plugin Author
From: France
Registered: 2008-07-24
Posts: 860
Website

Re: etc_query: all things Textpattern

etc wrote #294745:

Ah, ok, then doesn’t this work as intended?

It does! Thanks, I found the solution just before to read your reply… Sorry, I understand quickly but I need a lot of explanations! :-/


Nicolas
Follow me on Twitter and GitHub!
Multiple edits are usually to correct my frenglish…

Offline

Board footer

Powered by FluxBB