Skip to content
GitLab
    • GitLab: the DevOps platform
    • Explore GitLab
    • Install GitLab
    • How GitLab compares
    • Get started
    • GitLab docs
    • GitLab Learn
  • Pricing
  • Talk to an expert
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
    • Switch to GitLab Next
    Projects Groups Topics Snippets
  • Register
  • Sign in
  • baserow baserow
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
    • Locked files
  • Issues 554
    • Issues 554
    • List
    • Boards
    • Service Desk
    • Milestones
    • Requirements
  • Merge requests 14
    • Merge requests 14
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Artifacts
    • Schedules
    • Test cases
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Container Registry
    • Terraform modules
    • Model experiments
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Code review
    • Insights
    • Issue
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Baserow
  • baserowbaserow
  • Issues
  • #1271
Closed
Open
Issue created Oct 24, 2022 by Olga Trykush@olgatrykushReporter

Condition groups: advanced filtering combining AND & OR

Designs ready for the development (v1.0): https://www.figma.com/file/7BLCLdgS2zoZ0bIUw4Ua4r/Advanced-filtering?node-id=101%3A600&t=uoOlV97NbrIW6MlY-1

Introduce condition groups to deeply customize how rows are filtered. Allow joining multiple conditions together using logical conjunctions “And” & “Or”.

The biggest glaring omission here is “greater than or equal” (>=) and “less than or equal” (<=). While I know that “show me values 18 and up” can be done with “show me greater than 17”, its just that little bit of extra annoyance and mental energy. The formula language doesn’t have this awkward limitation on operators, so I wish the filter options didn’t either.

Additionally, it would be really nice to be able to specify number ranges for a filter. (e.g. “18-65”, or “from 18 through 65” Could even go as fancy as “16-65,84-89, 102,106”) A good analogy for this would be the way a print dialog lets you specify the pages of a document to print. However, there are many ways this could be approached. (and many ways to determine whether a range is inclusive or exclusive)

Community request: https://community.baserow.io/t/better-numeric-filtering/1583

Edited Mar 03, 2023 by Michał Roszyk
Assignee
Assign to
Time tracking