[UXPROD-4457] Lists: Implement PoC to dynamically join queries Created: 06/Sep/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: Kathleen Moore
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Continues
is continued by MODFQMMGR-39 Dynamically build the FROM clause, ba... Draft
Defines
defines MODFQMMGR-80 Build the SELECT clause from field ac... Closed
defines UILISTS-13 Spike: Determine how FE lets you choo... Closed
is defined by UIPQB-74 Non-default fields that are part of t... Open
is defined by MODLISTS-81 Fields aren't saved when creating a list Closed
is defined by UILISTS-79 Add indicator when waiting for additi... Draft
is defined by UILISTS-77 New lists display with columns select... Blocked
Relates
relates to MODLISTS-81 Fields aren't saved when creating a list Closed
Release: Quesnelia (R1 2024)
Development Team: Corsair
PO Rank: 0

 Description   

Implement the proof of concept to dynamically join queries. 

  • Use complex queries built dynamically based on the query and entity type definitions 
  • Predefining relationships so we can join data and tables in a way that makes sense
  • Once those relationships are defined, we can use dynamic queries to get the views – or to retrieve the data that we’d need

Why? Our derived tables are hard-coded and difficult to maintain (especially long-term). Performance becomes a concern because these views contain a huge collection of fields/tables (even when all of the fields/tables aren't all used for a given list).

 

This proposed PoC is primarily backend, and contains minimal user facing changes. 


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