Skip to content

erp5
erp5
An error occurred fetching the project authors.
Switch branch/tag
  1. 07 Oct, 2015 1 commit
    • Kazuhiko Shiozaki's avatar
      Revert "Add auto_extend_select_list argument in buildSQLQuery() and use alias... · 05efe1ba
      Kazuhiko Shiozaki authored 
      Revert "Add auto_extend_select_list argument in buildSQLQuery() and use alias in group_by_expression and order_by_expression."
Revert "Support group_by_list and order_by_list in WebSection_getDocumentValueList."
Revert "Support order_by_list in Resource_zGetMovementHistoryList."

No need to extend SQLCatalog parameter to support group_by_list and order_by_list in sub-queries.
      05efe1ba
  3. 04 Oct, 2015 1 commit
    • Kazuhiko Shiozaki's avatar
      Add auto_extend_select_list argument in buildSQLQuery() and use alias in... · bdcdaca8
      Kazuhiko Shiozaki authored 
      Add auto_extend_select_list argument in buildSQLQuery() and use alias in group_by_expression and order_by_expression.

If True, select_list is automatically extended to have columns used in
group_by_list and order_by_list. It is useful when use
select_expression in inner query and use group_by_expression or
order_by_expression in outer query.
      bdcdaca8
  5. 19 Nov, 2014 1 commit
  7. 08 Nov, 2014 1 commit
    • Kazuhiko Shiozaki's avatar
      use fulltext search in title and description. · d47df833
      Kazuhiko Shiozaki authored 
      * to quickly setup catalog_full_text table, you can use the following SQL.

  REPLACE INTO catalog_full_text SELECT uid, title, description FROM catalog;

* non fulltext queries like '=abc', '>abc', '%abc%' are supported.

* now erp5_full_text_mroonga_catalog is used for unit tests thus I recommend using it instead of erp5_full_text_myisam_catalog.

* to migrate existing MyISAM full_text table into Mroonga, you can use the following SQL.

  ALTER TABLE full_text DROP KEY SearchableText,
    ENGINE = mroonga,
    ADD FULLTEXT KEY SearchableText (`SearchableText`) COMMENT 'parser "TokenBigramSplitSymbolAlpha"';

* fulltext search score is no longer provided as (column_name) but now provided as (column_name)__score__.

* (category)_title, like source_title, related keys are automatically generated. (category)_description keys as well.
      d47df833
  9. 16 Oct, 2014 1 commit
  11. 04 Sep, 2014 1 commit
  13. 08 Jul, 2014 1 commit
  15. 17 Oct, 2011 1 commit
  17. 21 Jan, 2011 1 commit
  19. 20 Jan, 2011 1 commit
  21. 13 Jan, 2011 1 commit
  23. 03 Jan, 2011 1 commit
  25. 14 Oct, 2010 1 commit
  27. 28 Jul, 2010 1 commit
  29. 12 Mar, 2010 1 commit
  31. 11 Mar, 2010 1 commit
    • Vincent Pelletier's avatar
      Fix regression introduced in r33653. · 450b448a
      Vincent Pelletier authored 
      As the generated order-by expressions now (rightly) differ based on data, the
exception generated when detecting the difference must be postponed to when
expression is actualy used, as it might not be used.
Also, test that postponing effectively works, and demonstrate another way to
express the same condition, but which allows sorting.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@33660 20353a03-c40f-0410-a6d1-a30d3c3de9de
      450b448a
  33. 23 Nov, 2009 1 commit
  35. 20 Nov, 2009 1 commit
  37. 07 Oct, 2009 1 commit
  39. 01 Jun, 2009 1 commit
  41. 27 Mar, 2009 1 commit
  43. 24 Mar, 2009 2 commits
  45. 11 Mar, 2009 2 commits
  47. 25 Feb, 2009 1 commit
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7