[prev in list] [next in list] [prev in thread] [next in thread]
List: mtos-dev
Subject: RE: [Pronet] How to Aggregate data from 4 different Entry Loops (mt:SQLEntries) and then Display the
From: "Mihai Bocsaru" <info () pro-it-service ! com>
Date: 2016-01-27 8:33:04
Message-ID: 011301d158dd$579f9d30$06ded790$ () pro-it-service ! com
[Download RAW message or body]
This is a multipart message in MIME format.
Thanks for your feedback, Jay!
I was thinking to try that as a plan B after experimenting without the use of a \
plugin.
Kind Regards,
Mihai Bocsaru
From: Jay Allen [mailto:jay@endevver.com]
Sent: Wednesday, January 27, 2016 12:10 AM
To: Six Apart Professional Network
Subject: Re: [Pronet] How to Aggregate data from 4 different Entry Loops \
(mt:SQLEntries) and then Display their output Sorted by Date
When all else fails, the Order plugin is always useful: \
https://plugins.movabletype.org/order/
Jay Allen
Principal, Endevver LLC
http://endevver.com
(415) 702-0045
On Mon, Jan 25, 2016 at 3:08 AM, Mihai Bocsaru <info@pro-it-service.com> wrote:
Hello Guys,
Another week, another question :)
I'm collecting data from 4 different mtSQL queries.
Basically, I'm looking for the current entry author ID if it is present on each and \
every of 4 custom fields.
At the end of this message I will provide the coding that I'm using the grab the \
entries data.
What I need is to aggregate all the results from the 4 mt:SQLEntries loops and then \
to sort them preferably by entrydate, otherwise by endryid.
At this time I'm not providing the date or the id in a way which could be used for \
the sorting, but I could amend the loops output to include that.
Grateful if you could point me in the right direction to how could I mix these 4 \
loops and then sort their output in the way I want.
Many thanks,
Mihai Bocsaru
The coding that I'm using at the moment is:
<h2>Extract 1st CoAuthor Field</h2>
<MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta where entry_id = \
entry_meta_entry_id and entry_meta_type = 'field.coauthors_first' and \
entry_meta_vchar_idx = '[MTAuthorID]'" unfiltered="1">
<mt:Unless tag="EntryDataArticleType" eq="Column">
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle encode_html="1">"><mt:EntryTitle></a></h3>
<div class="date"><mt:EntryDate format="%B \
%Y"></div>
</mt:Unless>
</MTSQLEntries>
<h2>Extract 2nd CoAuthor Field</h2>
<MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta where entry_id = \
entry_meta_entry_id and entry_meta_type = 'field.coauthors_second' and \
entry_meta_vchar_idx = '[MTAuthorID]'" unfiltered="1">
<mt:Unless tag="EntryDataArticleType" eq="Column">
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle encode_html="1">"><mt:EntryTitle></a></h3>
<div class="date"><mt:EntryDate format="%B \
%Y"></div>
</mt:Unless>
</MTSQLEntries>
<h2>Extract 3rd CoAuthor Field</h2>
<MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta where entry_id = \
entry_meta_entry_id and entry_meta_type = 'field.coauthors_third' and \
entry_meta_vchar_idx = '[MTAuthorID]'" unfiltered="1">
<mt:Unless tag="EntryDataArticleType" eq="Column">
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle encode_html="1">"><mt:EntryTitle></a></h3>
<div class="date"><mt:EntryDate format="%B \
%Y"></div>
</mt:Unless>
</MTSQLEntries>
<h2>Extract 4th CoAuthor Field</h2>
<MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta where entry_id = \
entry_meta_entry_id and entry_meta_type = 'field.coauthors_fourth' and \
entry_meta_vchar_idx = '[MTAuthorID]'" unfiltered="1">
<mt:Unless tag="EntryDataArticleType" eq="Column">
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle encode_html="1">"><mt:EntryTitle></a></h3>
<div class="date"><mt:EntryDate format="%B \
%Y"></div>
</mt:Unless>
</MTSQLEntries>
P.S.
The H2s above are just for explaining what follows. They won't exist on the public \
pages.
--
You received this message because you are subscribed to the Google Groups "pronet" \
group. To unsubscribe from this group and stop receiving emails from it, send an \
email to pronet+unsubscribe@ml.sixapart.com.
--
You received this message because you are subscribed to the Google Groups "pronet" \
group. To unsubscribe from this group and stop receiving emails from it, send an \
email to pronet+unsubscribe@ml.sixapart.com.
--
You received this message because you are subscribed to the Google Groups "pronet" \
group. To unsubscribe from this group and stop receiving emails from it, send an \
email to pronet+unsubscribe@ml.sixapart.com.
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=RO link=blue vlink=purple><div \
class=WordSection1><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks for \
your feedback, Jay!<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I was \
thinking to try that as a plan B after experimenting without the use of a \
plugin.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Kind \
Regards,<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Mihai \
Bocsaru<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><b><span lang=EN-US \
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span \
lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Jay Allen \
[mailto:jay@endevver.com] <br><b>Sent:</b> Wednesday, January 27, 2016 12:10 \
AM<br><b>To:</b> Six Apart Professional Network<br><b>Subject:</b> Re: [Pronet] How \
to Aggregate data from 4 different Entry Loops (mt:SQLEntries) and then Display their \
output Sorted by Date<o:p></o:p></span></p><p \
class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>When all else fails, the \
Order plugin is always useful: <a \
href="https://plugins.movabletype.org/order/">https://plugins.movabletype.org/order/</a><o:p></o:p></p></div><div><p \
class=MsoNormal><br clear=all><o:p></o:p></p><div><div><div><div><div><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Jay \
Allen<o:p></o:p></span></p></div><div><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Principal, Endevver \
LLC<o:p></o:p></span></p></div><div><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial","sans-serif"'><a \
href="http://endevver.com" \
target="_blank">http://endevver.com</a><o:p></o:p></span></p></div><div><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>(415) \
702-0045<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p></div></div></div></div><p \
class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Mon, Jan 25, 2016 at \
3:08 AM, Mihai Bocsaru <<a href="mailto:info@pro-it-service.com" \
target="_blank">info@pro-it-service.com</a>> wrote:<o:p></o:p></p><div><div><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US>Hello Guys,</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Another \
week, another question :)</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>I'm \
collecting data from 4 different mtSQL queries.</span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US>Basically, I'm looking for the current entry author ID if it is present on \
each and every of 4 custom fields.</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>At the \
end of this message I will provide the coding that I'm using the grab the entries \
data.</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>What I \
need is to aggregate all the results from the 4 mt:SQLEntries loops and then to sort \
them preferably by entrydate, otherwise by endryid.</span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>At this \
time I'm not providing the date or the id in a way which could be used for the \
sorting, but I could amend the loops output to include that.</span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Grateful \
if you could point me in the right direction to how could I mix these 4 loops and \
then sort their output in the way I want.</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Many \
thanks,</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Mihai \
Bocsaru</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>The \
coding that I'm using at the moment is:</span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><h2>Extract 1st CoAuthor Field</h2></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta \
where entry_id = entry_meta_entry_id and entry_meta_type = 'field.coauthors_first' \
and entry_meta_vchar_idx = '[MTAuthorID]'" \
unfiltered="1"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><mt:Unless tag="EntryDataArticleType" \
eq="Column"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle \
encode_html="1">"><mt:EntryTitle></a></h3></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<div class="date"><mt:EntryDate format="%B \
%Y"></div></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US></mt:Unless></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US></MTSQLEntries></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><h2>Extract 2nd CoAuthor Field</h2></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta \
where entry_id = entry_meta_entry_id and entry_meta_type = 'field.coauthors_second' \
and entry_meta_vchar_idx = '[MTAuthorID]'" \
unfiltered="1"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><mt:Unless tag="EntryDataArticleType" \
eq="Column"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle \
encode_html="1">"><mt:EntryTitle></a></h3></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<div class="date"><mt:EntryDate format="%B \
%Y"></div></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US></mt:Unless></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US></MTSQLEntries></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><h2>Extract 3rd CoAuthor Field</h2></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta \
where entry_id = entry_meta_entry_id and entry_meta_type = 'field.coauthors_third' \
and entry_meta_vchar_idx = '[MTAuthorID]'" \
unfiltered="1"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><mt:Unless tag="EntryDataArticleType" \
eq="Column"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle \
encode_html="1">"><mt:EntryTitle></a></h3></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<div class="date"><mt:EntryDate format="%B \
%Y"></div></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US></mt:Unless></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US></MTSQLEntries></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><h2>Extract 4th CoAuthor Field</h2></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><MTSQLEntries query="select entry_id from mt_entry,mt_entry_meta \
where entry_id = entry_meta_entry_id and entry_meta_type = 'field.coauthors_fourth' \
and entry_meta_vchar_idx = '[MTAuthorID]'" \
unfiltered="1"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US><mt:Unless tag="EntryDataArticleType" \
eq="Column"></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<h3><a href="<mt:EntryPermalink>" \
title="<mt:EntryTitle \
encode_html="1">"><mt:EntryTitle></a></h3></span><o:p></o:p></p><p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
lang=EN-US> &nb \
sp; \
<div class="date"><mt:EntryDate format="%B \
%Y"></div></span><o:p></o:p></p><p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span \
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups \
"pronet" group.<br /> To unsubscribe from this group and stop receiving \
emails from it, send an email to <a \
href="mailto:pronet+unsubscribe@ml.sixapart.com">pronet+unsubscribe@ml.sixapart.com</a>.<br \
/>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic