Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • S Search and Reporting - archived
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Service Desk
    • Milestones
  • Wiki
    • Wiki
  • Activity
  • Create a new issue
  • Issue Boards
Collapse sidebar
  • Development
  • Search and Reporting - archived
  • Issues
  • #31
Closed (moved) (moved)
Open
Created Mar 25, 2020 by josh@josh🏄Owner

APIv4 Query Improvements

This project will expand the query language of APIv4 to increase functionality. Implementing this will enhance the capabilities of APIv4-based Smart Groups; without this their utility will be limited to simple queries. This is also a prerequisite to the Search Builder UI project.

Tasks:

  • Implement Having, Group By parameters.
  • Enable use of SQL Functions like SUM().
  • Implement explicit joins.
  • Implement a way to add subquery expressions to an API call.

Related pull-requests:

  • #16947 - Support GROUP BY and aggregate functions (merged)
  • #17047 - Api4 Explorer: Support SQL functions and HAVING clause (merged)
Edited Apr 10, 2020 by totten
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking