(public).sospep.events ~ view task ~ FEATURE-REQUEST-index-articles

<h1 style="text-align: center;">index</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[2013-11-04] index_help -</strong></li>
<ol>
<li>x] PRB generated links that were not accessible, getting ERROR(S) on site crawl report for each page it generated</li>
</ol>
<li><strong>x] NEW PG index_articles</strong></li>
<ol>
<li>] replaces index for 1 book with index for any book, *] currently only accessed via the "main help menu" for BK sospep-help</li>
<li>] ARGS library id</li>
<li>] RETURNS - page with listing of passed in index strings, alpha letters, +&nbsp;</li>
</ol>
<li><strong>] CS sospepHelper - NEW method -&nbsp;</strong></li>
<ol>
<li>] sospepHelper.generateIndex([]index strings, list style, &nbsp;) - &nbsp;</li>
</ol>
<li><strong>] CS Article - NEW method&nbsp;</strong></li>
<ol>
<li>] ArticlesIndex - take the library id,&nbsp;</li>
<li>] ARGS id of library, string search</li>
<li>] RETURNS - result of search for index&nbsp;</li>
</ol>
<li><strong>] PG view_articles - EDIT "index" block in qry switch</strong></li>
<ol>
<li>] call new method that assigns results of index search to Page.articles</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li><strong>&gt; i] PG index_help</strong></li>
<ol>
<li>] replacing with PG index_articles, can now index any BK, can create custom index(insert terms)</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li>]</li>
</ol>
<div><hr /></div>
<div>
<div>] mysql create transaction</div>
<div>] PG view/articles?&nbsp;</div>
<div>] select all from articles where name_article LIKE @0'</div>
<div>] select SQL_CALC_FOUND_ROWS * from sospep.articles where id_article BETWEEN 100 AND 200 LIMIT 10;</div>
<div>] select FOUND_ROWS();</div>
<div>] library id = 27&nbsp;</div>
<div>] select * from articles where name_article LIKE UPPER('S%');</div>
<div>] select * from sospep.articles where name_article LIKE 'A%' &amp;&amp; parent_id IN (Select id_chapter FROM chapters WHERE parent_id IN (SELECT id_book from books where parent_id = 27));</div>
</div>

~ view task ~ TaskGroup] FEATURES-REQUESTED FROM [ Plan] plan-projects IN [ calendars] prj-022-sospep