Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#241 2015-09-12 09:33:41
Re: etc_query: all things Textpattern
Nothing to be sorry about, that helped me to fix few glitches.
Offline
#242 2015-09-12 09:46:27
Re: etc_query: all things Textpattern
Version 1.3.1 is out, just few minor fixes and 4.6 compatibility.
Offline
#243 2015-09-12 12:41:35
Re: etc_query: all things Textpattern
etc wrote #294749:
Version 1.3.1 is out, just few minor fixes and 4.6 compatibility.
Thanks!
Any advice about the use of regex to allow me to create excerpt from the boby tag properly? My code is:
<txp:etc_query data='<txp:body />' specials="" query="substring(//p[1], 0, 140)" limit="1" wraptag="p" />…but, of course, it does not cut properly. Cutting after the last entire word before the character 140 would be better.
Edit: it’s maybe even possible to add …?
Last edited by NicolasGraph (2015-09-12 12:43:26)
Offline
#244 2015-09-12 16:50:43
Re: etc_query: all things Textpattern
You can register any php (string) function for use with etc_query. I’m not sure this is optimal, but it should work:
<txp:etc_query data='<txp:body />' specials="" functions="preg_replace,trim" limit="1" wraptag="p"
query="preg_replace('/\w*:::/', '…', preg_replace('/^(.{140}).+/s', '$1:::', trim(string(p[1]))))" />Edit: but be careful if you use it inside another etc_query, you might need to protect the {140} part.
Last edited by etc (2015-09-12 21:20:19)
Offline
#245 2015-09-12 17:04:58
Offline
#246 2015-09-23 14:01:35
Re: etc_query: all things Textpattern
Hi,
I would like to know if there is any chance to make the following code work…
I’m looking for three comma separated image id’s in the article_image field but I can’t make REGEXP work.
Is that possible? Do I need to use the functions attribute? …
<txp:etc_query data="Image REGEXP '^((\d+,)\s*){2}\d+$'" populate="article">
<txp:article_image />
</txp:etc_query>Thanks…
Offline
#247 2015-09-23 17:40:41
Re: etc_query: all things Textpattern
No, but since you are in db mode here, you must use MySQL regexp notations, which are weird. Try (no warranty)
<txp:etc_query markup="db" populate="article"
data="Image REGEXP '^(([[:digit:]]+,)[[:space:]]*){2}[[:digit:]]+$'"
>
<txp:article_image />
</txp:etc_query>Offline
#248 2015-09-24 20:58:44
Re: etc_query: all things Textpattern
Offline
#249 2015-10-17 14:22:36
Re: etc_query: all things Textpattern
NicolasGraph wrote #295093:
Hi,
I would like to know if there is any chance to make the following code work…
I’m looking for three comma separated image id’s in the article_image field but I can’t makeREGEXPwork.
Is that possible? Do I need to use thefunctionsattribute? …
<txp:etc_query data="Image REGEXP '^((\d+,)\s*){2}\d+$'" populate="article">...Thanks…
I can’t get it work but it is not really important. Thank you for your reply.
Offline
#250 2015-10-17 15:46:21
Offline
#251 2015-11-05 22:16:21
- lazlo
- Member
- Registered: 2004-02-24
- Posts: 110
Re: etc_query: all things Textpattern
Hi Oleg (SOLVED)
I am implementing your wonderful A-Z filter / paginated A-Z article list but I am having trouble limiting the database call to specific textpattern section.
Is there a way to adjust this call to delimit textpattern sections?
I have a section called “Books” to be specific.
<txp:etc_query wraptag="nav" break=" | " name="alphalist"
data="SELECT DISTINCT UPPER(SUBSTRING(Title,1,1)) AS alpha FROM textpattern WHERE Status = 4 ORDER BY alpha"
>
<a href="?alpha={alpha?}">{alpha?}</a>
</txp:etc_query>I have tried various iterations on the call by adding AND Section = ‘books’ but with no success.
I didn’t realize there were two calls that needed to be changed so the following is the solution.
NEW Code
<!-- alpha list -->
<txp:etc_query wraptag="nav" break=" | " name="alphalist"
data="SELECT DISTINCT UPPER(SUBSTRING(Title,1,1)) AS alpha FROM textpattern WHERE Status = 4 AND Section = 'books' ORDER BY alpha"
>
<a href="?alpha={alpha?}">{alpha?}</a>
</txp:etc_query>
<!-- output alphalist and get articles ids when necessary -->
<txp:etc_query globals="_GET" data='<txp:variable name="alphalist" />'
query="//a[text() = '{?alpha|A}']"
replace="&=<span class='active'>{?alpha|A}</span>"
>
{//nav}
<txp:etc_query name="ids" break="," globals="_GET"
data="SELECT ID FROM textpattern WHERE UPPER(SUBSTRING(Title,1,1)) = '{?alpha|A}' AND Status = 4 AND Section = 'books' ORDER BY Title" />
<txp:else />
<txp:variable name="alphalist" />
</txp:etc_query>
<txp:if_variable name="ids">
<!-- Pagination bar -->
<txp:etc_query name="pages" data="{?ids|1|substr_count($|,).+1./2.ceil}" />
<txp:etc_pagination pgcounter="page" link="Page {*}" wraptag="nav" break=" | "
pages='<txp:variable name="pages" />' />
<!-- articles output -->
<txp:article_custom id='<txp:variable name="ids" />' limit="2"
offset='<txp:etc_offset pgcounter="page" pageby="2" />' />
</txp:if_variable>Last edited by lazlo (2015-11-05 23:16:55)
Offline
#252 2015-11-06 09:43:19
Re: etc_query: all things Textpattern
Hi Leslie, glad you have solved it. For multiple sections, you can add
Section IN('books', 'news')to the appropriate WHERE clauses. And if you have expired/future articles, you may need also
(NOW() <= Expires OR Expires = '0000-00-00') AND Posted <= NOW()Last edited by etc (2015-11-06 10:41:07)
Offline