Re: [TYPO3-english] Complex Query in Typoscript
Thanks everyone for the assistance! We got it done! Mary -- View this message in context: http://old.nabble.com/Complex-Query-in-Typoscript-tp30998902p31002108.html Sent from the TYPO3 English mailing list archive at Nabble.com. ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Complex Query in Typoscript
Thanks, if this were any other customer than PR... I'd tell them to use the recently updated pages method. My developer is going to see if he can do it using php that we can call with a lib include, I'm mainly designer who knows enough typoscript to be dangerous. If he doesn't do it, I'll walk it out backward in the typoscript. Thanks! Peter Russ wrote: > > --- Original Nachricht --- > Absender: IAmThatSTrange > Datum: 23.02.2011 22:16: >> Hi all, I've been looking all over for information on how to do this in >> Typoscript. tsref while great doesn't go into the detail for me to >> understand where to dot the i's and cross the t's. (syntax, usage) >> >> What I'm trying to do is show the last 5 updated content element headers >> as >> links to those content elements on the home page (from several pages down >> - >> on as many subpages as necessary to get those content elements). >> So >> Home page (where the links to the content elements will be shown) >> News >>Feb 2011 >> 021811 (where the content elements are) >> 021611 (where the content elements are) >> 021411 (where the content elements are) >>Jan 2011 >> 011811 (where the content elements are) >> 011611 (where the content elements are) >> 011411 (where the content elements are) >> >> I only need the most recent 5 or 6 but if one page has only 3 content >> elements, then the top 3 content elements from the next page should show. >> >> I have a query that get's exactly what I want in a straight db query, >> I've >> just no clue how to put this into Typoscript. >> >> the Query: >> >> SELECT t.uid, t.pid, bodytext >> FROM tt_content t >> WHERE pid IN (SELECT p1.uid FROM pages p1 LEFT JOIN pages p2 ON p1.pid = >> p2.uid where p2.pid = 17523 and p1.hidden = 0 and p1.deleted=0) >> order by tstamp desc >> >> Can anyone assist? >> >> Thanks so much! >> >> M > > PS: alreday done similar thing. But you have to "reverse" the MySql > standard approach: > > 1) Query internal first > 2) With each result of first query do the external > > As you can imagine: not very fast. > Never left R&D. > > Peter. > > > > > > > -- > Fiat lux! Docendo discimus. > _ > uon GbR > > http://www.uon.li > http://www.xing.com/profile/Peter_Russ > ___ > TYPO3-english mailing list > TYPO3-english@lists.typo3.org > http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english > > -- View this message in context: http://old.nabble.com/Complex-Query-in-Typoscript-tp30998902p30999431.html Sent from the TYPO3 English mailing list archive at Nabble.com. ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
Re: [TYPO3-english] Complex Query in Typoscript
Hi, thanks for responding. I'm working with PR people who want things the way they are (if you get my drift). so it will always be on the second level below News. sorry bout the repost, I got a message that said it's not been posted yet and decided I wanted to clarify something. Sigh. What they want is the top (recently added or edited) x (probaby 5) headers (not page titles) linking down to the content elements on the pages under the month/year to show on the landing page of the New Center. So if there are 4 new content elements on one page under Feb2011 it will show the headers of those with links back to the content element it came from and it will pick up the last (the 5th) content element from the next page under Feb2011. It's very much like the recently updated pages (with beginAtLevel showing what level to start on) but with individual content elements not pages. I hope that's clear. Thanks! Tomas Mrozek wrote: > > There are probably several ways. One can be using CONTENT (1) and > "select" (2). How exactly the TypoScript set up would look like depends > on how complex it really should be. > > Looking at the SQL query, does it have to be exactly as described > (content from the 2nd sublevel of News) OR can it actually be any > content from News and its subpages? > > Tomas Mrozek > -- > [1] > http://typo3.org/documentation/document-library/references/doc_core_tsref/4.3.2/view/1/7/#id2519413 > [2] > http://typo3.org/documentation/document-library/references/doc_core_tsref/4.3.2/view/1/5/#id2506889 > ___ > TYPO3-english mailing list > TYPO3-english@lists.typo3.org > http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english > > -- View this message in context: http://old.nabble.com/Complex-Query-in-Typoscript-tp30989278p30998969.html Sent from the TYPO3 English mailing list archive at Nabble.com. ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
[TYPO3-english] Complex Query in Typoscript
Hi all, I've been looking all over for information on how to do this in Typoscript. tsref while great doesn't go into the detail for me to understand where to dot the i's and cross the t's. (syntax, usage) What I'm trying to do is show the last 5 updated content element headers as links to those content elements on the home page (from several pages down - on as many subpages as necessary to get those content elements). So Home page (where the links to the content elements will be shown) News Feb 2011 021811 (where the content elements are) 021611 (where the content elements are) 021411 (where the content elements are) Jan 2011 011811 (where the content elements are) 011611 (where the content elements are) 011411 (where the content elements are) I only need the most recent 5 or 6 but if one page has only 3 content elements, then the top 3 content elements from the next page should show. I have a query that get's exactly what I want in a straight db query, I've just no clue how to put this into Typoscript. the Query: SELECT t.uid, t.pid, bodytext FROM tt_content t WHERE pid IN (SELECT p1.uid FROM pages p1 LEFT JOIN pages p2 ON p1.pid = p2.uid where p2.pid = 17523 and p1.hidden = 0 and p1.deleted=0) order by tstamp desc Can anyone assist? Thanks so much! M -- View this message in context: http://old.nabble.com/Complex-Query-in-Typoscript-tp30989277p30989277.html Sent from the TYPO3 English mailing list archive at Nabble.com. ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
[TYPO3-english] Complex Query in Typoscript
Hi all, I've been looking all over for information on how to do this in Typoscript. tsref while great doesn't go into the detail for me to understand where to dot the i's and cross the t's. (syntax, usage) What I'm trying to do is show the last 5 updated content element headers as links to those content elements on the home page (from several pages down - on as many subpages as necessary to get those content elemetns). So Home page (where the links to the content elements will be shown) News Feb 2011 021811 (where the content elements are) 021611 (where the content elements are) 021411 (where the content elements are) I only need the most recent 5 or 6 but if one page has only 3 content elements, then the top 3 content elements from the next page should show. I have a query that get's exactly what I want in a straight db query, I've just no clue how to put this into Typoscript. the Query: SELECT t.uid, t.pid, bodytext FROM tt_content t WHERE pid IN (SELECT p1.uid FROM pages p1 LEFT JOIN pages p2 ON p1.pid = p2.uid where p2.pid = 17523 and p1.hidden = 0 and p1.deleted=0) order by tstamp desc Can anyone assist? Thanks so much! M -- View this message in context: http://old.nabble.com/Complex-Query-in-Typoscript-tp30989277p30989277.html Sent from the TYPO3 English mailing list archive at Nabble.com. ___ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english