task

FEATURE-3670-010 - PAGINATION Search results

[previously]

  1. [reference] FEATURE-3670
    1. x] overview and description
  2. [2015-08-14] NEW task
    1. ] find byName -
    2. ] ADD -
    3. ] PRB - not getting pagination links to display 
  3. [2015-08-17] NEW task
    1. x] MOVE - call to Articles.RecordCount INTO qry code block
  4. [00:00] NEW task
    1. i] # 5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2
  5. [00:00] NEW task
    1. i] # 5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2
    1. x] ADD NEW - recordCount(string qry) method, takes string(qry) as arg
    2. x] EDIT - recordCount(string qry, string param)  - add param as well, concat in page doesnt work
    3. > x] MOVE - pagination code block(calculate pages) into qry code block
    4. *] PRB - now getting all records
    5. x] ADD NEW - qry2 is get count of records in query NOT get records in query
    6. x] MODIFY - orig. "calculate pages" pagination block, init vars to 0
    7. x] MOVE "calculate pages" code block (same block) into seperate blocks for ] getArticlesInChapter and ] getArticlesByQry
    8. x] PRB - not getting pagination links to display
    9. x] MODIFY CS recordCount() - prefix and append wildard character("%") to the parameter
    10. x] PRB - link is non functional, uses parent_id which is 0
    11. ] MODIFY - code block, given arg = 'start page', alter qry LIMIT clause 
    12. x] MODIFY - pagination link to use orig link + append startPage param, this calculates start record value
    13. x] PRB works for query records NOT for regular records
    14. ] NEW sospepHelper - generatePageLinks(qry,parent_id) -method to generate either/or
  6. [2015-08-18] NEW task
    1. x] push .org - x] article, x] view/articles, x] sospepHelper
  7. [00:00] NEW task
    1. ] # # - find description .... || find items
  8. > [00:00] NEW task - ] find description
    1. i] # 5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2
    2. ] # # - TRY using sql_calc_rows method,
    3. ] RESULT = WORKS but somewhat inconsistent in results,
    4. ] maybe its my implementation? ALSO for example test qry="interview" get 220 results (11 pages) then click on page 5 and now i only have 2 pages results
  9. [2015-08-19][00:00] NEW task
    1. x] push to production with FIX-PRB-5498 - not ready
    2. x] PAGE links on view/article by browse(parent_id) are showing with
  10. [00:00] NEW task IN
    1. x] sospepHelper function - ] ADD 2nd condition to test qry if ( qry=qry and parent_id=0 )
  11. [00:00] NEW task - findBy Content - REVERT 2* query method, count(total_records) and results(qry, limit)
    1. x] CS - ADD NEW qstring for count records
    2. x] CS verify method has wildcard param append/prepend to param, verify param is upper
    3. x] PG findByContent - case statement - includes ...]
    4. **
    5. x] TEST.local qry(result)= vancouver(54), interview(272), javascript(218), asp.net(45), asp.net MVC(22), don sagrott(22) 
    6. x] PUSH .com
    7. x] TEST.remote =  PASS
    8. x] PUSH .org
    9. *] qry - blackberry z30(11) <> blackberry(299)
  12. [2015-08-19][00:00] NEW task - findBy - Library
    1. x] CS - ADD NEW qstring for count records
    2. x] CS - NEW METHOD recordCount( string qry, int param parent_id)
    3. x] PG findByLibrary - case statement - includes ... ] getArticles args (startRecord, qty), ] calculate totalRecords, totalPages
    4. x] TEST.local qry(result)= ] test_book(84), ]
  13. [00:00] NEW task - findBy - Book
    1. x] CS - ADD NEW qstring for count records
    2. x] PG findBy Book - case statement - includes ... ] getArticles args (startRecord, qty), ] calculate totalRecords, totalPages
    3. x] TEST ] book git(21), book javascript(172)
  14. [00:00] NEW task - findBy - Chapter]
    1. *] CS - no new qry, orig recordCount method which takers parent_id, returns count
    2. x] PG - findByChapter - use sospepFunction.totalPages()
    3. ] TEST book.git ch=#(#), book=javascript, ch=2-learning (9), book=test, ch=001 (37)
  15. [00:00] NEW task
    1. x] # # - NEW method - sospepFunction.totalPages(int totalRecords, resultsPerPage)
    2. x] test on findBy Book
    3. x] findBy Book, findByChapter
  16. [00:00] NEW task - findBy - status]
    1. x] CS - add qry
    2. x] EDIT - recordCount(string qry, string param) - was adding wildcard in method, dont want appended wildcards here, will have to go back to adding on calling page
    3. x] USE sospepFunction.totalPages()
    4. x] TEST writing(37), written(447), write(lots)
  17. [00:00] NEW task - findBy - created]
    1. x] CS - add qry
    2. x] USE sospepFunction.totalPages()
  18. [00:00] NEW task - findBy - owner]
    1. x] CS - add qry
    2. x] USE sospepFunction.totalPages()

[currently]

  1. ]

[next]

  1. [00:00] NEW task - findBy - index]
    1. ]
  2. [REFERENCE]
    1. ] TRY mysql Get total number of rows when using LIMIT - use SQL_CALC_FOUND_ROWS
    2. ] http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2890708 
    3. ]  count (*) VS count(id_article) - https://www.percona.com/blog/2007/04/10/count-vs-countcol/
Details Photos Edit more

Details

ID: 5490

NAME: FEATURE-3670-010

DESCRIPTION: PAGINATION - on SEARCH page -

START DATE TIME: 2015-08-17 11:42:41

EST DURATION: 01:00:00

END DATE TIME: 2015-08-17 12:42:41

STATUS:

PRIORITY: -5

OWNER ID: 1

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities