(public).sospep.events ~ view task ~ 3250-003-news-tab-deduplication-and-limitation

ID/Title: 2831,3250-003-news-tab-deduplication-and-limitation,

Description Task: UPDATE #]3250 [PG view/article TAB news] DEDUPLICATION and LIMITATION - limiting the amount of results returned and preventing duplicate articles [REPLACING]none[WHY] prevent duplication on "consolidated" list and to control the total amount of,PUBL

Calendar: prj-022-sospep/doc-projects/FEATURE-3250

Added By: View Owner ON: 2013-09-16-21:06:37

Start Date: 2012-11-24

Start Time: 02:00:00

Estimated Duration: 01:00:00

Est. Completion Time: 2012-11-24-03:00:00

Status: Completed

Priority: -5

<h2>[-previously-]</h2>
<ol>
<li><strong>]&nbsp;<a href="http://sospep.com/view/task?id=2827" target="_blank">feature idea 3250</a></strong></li>
<ol>
<li>x] overview articles describing what this feature 'news tab' is and what it does, it breifly outlines our plan on how we are going to implement it. &nbsp;</li>
</ol></ol>
<h2>[-currently-]</h2>
<ol>
<li><strong>x] this was easy, just modified our YQL&nbsp;query to return only "desired QTY" using LIMIT&nbsp;constraint</strong></li>
<ol>
<li>x] YQL basically did the rest</li>
</ol>
<li><strong>x] added UNIQUE constraint on title field to prevent duplicated articles</strong></li>
<ol>
<li>x] see notes 1</li>
</ol></ol>
<h2>[-next-]</h2>
<ol>
<li><strong>x] dedup -needs to be tested</strong></li>
<ol>
<li>] didnt see any duplicate results in the initial results set,</li>
</ol>
<li><strong>x] count limit works&nbsp;</strong></li>
<ol>
<li>( were getting max 100 results BUT dont know how it works, ie if url 1 has 100 results does it stop there or ??? )</li>
</ol>
<li>x] QRY - select * from rss where url IN ("<a href="http://news.cnet.com/8300-10805_3">http://news.cnet.com/8300-10805_3</a>-75.xml","<a href="http://rss.news.yahoo.com/rss/tech%22,%22http://news.google.com/news?pz=1&amp;cf=all&amp;ned=us&amp;hl=en&amp;topic=tc&amp;output=rss">http://rss.news.yahoo.com/rss/tech","http://news.google.com/news?pz=1&amp;cf=all&amp;ned=us&amp;hl=en&amp;topic=tc&amp;output=rss</a>") LIMIT 10 | unique(field="title")</li>
</ol>
<p>&nbsp;</p>

It appears there are no photos associated with this record

~ view task ~ TaskGroup] FEATURE-3250 FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep