[UXPROD-4501] Support building more complex queries Created: 13/Oct/23  Updated: 07/Feb/24

Status: In Progress
Project: UX Product
Components: None
Affects versions: None
Fix versions: Quesnelia (R1 2024)

Type: New Feature Priority: P3
Reporter: Kathleen Moore Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Cloners
is cloned by UXPROD-4667 Support building more complex queries... Open
Defines
is defined by UIPQB-75 Display grouped fields within a list row Open
is defined by UIPQB-82 [Query Builder] Support querying base... Open
is defined by MODFQMMGR-130 Support searching for any overlapping... Open
is defined by MODFQMMGR-131 Support matching on all value(s) in a... Open
is defined by UIPQB-76 Build queries that search for null / ... Open
is defined by MODFQMMGR-141 Add queryable flag for entity type co... Open
is defined by MODFQMMGR-151 Add nested object queries to FQL In Progress
is defined by MODFQMMGR-95 Spike: Consolidating fund distributio... Closed
is defined by MODFQMMGR-113 Rework array operators to avoid subst... Closed
is defined by MODFQMMGR-119 Create new operators to support searc... Closed
is defined by UIPQB-53 Add support for $contains and $not_co... Closed
is defined by UIPQB-69 UI indication for different functiona... Draft
is defined by UIPQB-79 Update available operators for arrays Draft
is defined by MODFQMMGR-150 Store rich information about array fi... In Code Review
Release: Quesnelia (R1 2024)
Development Team: Corsair
PO Rank: 0

 Description   

Current situation or problem: Only basic queries can be used to create lists, but we'll need to support more advanced queries. 

In scope 

  • Adding new 'IS NULL / EMPTY' operator to support building queries with null / empty values
  • Building queries based on simple arrays
  • Building queries based on arrays of objects
  • Viewing fields with simple arrays
  • Viewing grouped display for fields with an array of objects
  • The following operators for arrays:
    • Contains any / not contain any
    • Contains all / not contain all
    • TBD:
      • In / not in
      • = / !=

Out of scope

Use case(s){}

Proposed solution/stories

Links to additional info

Questions


Generated at Fri Feb 09 00:40:24 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.