This PR creates four new SQL query files. Each one queries for the projects (and respective project attributes) needed for each tab of the LUP dashboard: upcoming, to review, reviewed, and archive.
The queries expect the LUP user's contactid to be fed in as '${id:value}'.
To test the performance of these queries, it's helpful to use the contactid of a BP who has many projects in the system. BKBP (2a231d14-693e-e811-8133-1458d04d06c0) currently has the most.
Notes:
The disposition json blob includes fields that are commented out. These are fields we will need, but they don't exist in the production ZAP CRM data tables yet.
We'll want to update the attribute names to match the front-end model.
This PR creates four new SQL query files. Each one queries for the projects (and respective project attributes) needed for each tab of the LUP dashboard: upcoming, to review, reviewed, and archive.
The queries expect the LUP user's contactid to be fed in as
'${id:value}'
.To test the performance of these queries, it's helpful to use the contactid of a BP who has many projects in the system. BKBP (
2a231d14-693e-e811-8133-1458d04d06c0
) currently has the most.Notes: