[MLv2] Joins

[darksciencebase]

Tasks

Beta Give feedback

1. [MLv2] Make sure adding joins generates nice join aliases and they get included in the :join-alias for joined Fields #28724
   .Backend .Team/QueryProcessor .metabase-lib +3
   
2. [MLv2] Removing a join should remove any references from that join #30093
   2 of 2
   .Backend .Team/QueryProcessor .metabase-lib +3
   
3. [MLv2] Migrate notebook join step component to MLv2 #31070
   .Frontend .Team/QueryProcessor .metabase-lib Querying/GUI Querying/Notebook +5
   
4. [MLv2] Implement/expose functions like joinFields and withJoinFields #31173
   .Backend .Team/QueryProcessor .metabase-lib +3
   
5. [MLv2] Implement/expose functions for available columns and operators for join conditions #31174
   .Backend .Team/QueryProcessor .metabase-lib +3
   
6. [MLv2] Implement/expose suggestedJoinCondition function #31175
   .Backend .Team/QueryProcessor .metabase-lib +3
   
7. [MLv2] Implement/expose with-join-conditions #31176
   .Backend .Team/QueryProcessor .metabase-lib +3
   
8. [MLv2] Implement/expose functions for join strategy (type) #31180
   .Backend .Team/QueryProcessor .metabase-lib +3
   
9. [MLv2] Expose existing join functions in JS #31664
   .Backend .Team/QueryProcessor .metabase-lib +3
   
10. [MLv2] Expose external-op in Cljs/TS #31677
    .Team/QueryProcessor .metabase-lib +2
    
11. [MLv2] Expose function for looking up TableMetadata/CardMetadata #31915
    .Backend .Team/QueryProcessor .metabase-lib +3
    
12. [MLv2] Expose functions to get CardMetadata/TableMetadata from a join; and to get "picker info" from Metadata #31920
    .Backend .Team/QueryProcessor .metabase-lib +3
13. [MLv2] join-condition-lhs-columns should have a way to filter out columns from the current join #32005
    .Backend .Team/QueryProcessor .metabase-lib +3
    
14. [MLv2] Cljs/TS wrapper for join-fields needs to handle :all and :none #32006
    .Backend .Team/QueryProcessor .metabase-lib +3
    
15. [MLv2] Add joinable-columns to return columns that you can pass to with-join-fields #32007
    .Backend .Team/QueryProcessor .metabase-lib +3
    
16. [MLv2] We should have an opaque join strategy option type #32009
    .Backend .Team/QueryProcessor .metabase-lib +3
    
17. [MLv2] Add :default true to := for join-condition-operators #32014
    .Backend .Team/QueryProcessor .metabase-lib +3
    
18. [MLv2] Add function for display name for left-hand-side of a join #32015
    .Backend .Team/QueryProcessor .metabase-lib +3
    
19. [MLv2] [Bug] replace-clause is broken with joins #32026
    .Backend .Team/QueryProcessor .metabase-lib Type:Bug +4
    
20. [MLv2] :fields :all should be added by default when creating a join #32053
    .Backend .Team/QueryProcessor .metabase-lib +3
    
21. [MLv2] Add filterOperator() function to get operator from a filter clause #32058
    .Backend .Team/QueryProcessor .metabase-lib +3
    
22. [MLv2] Add shorter display name like ≠ to display info for filter operators and change existing :display-name to :long-display-name #32060
    .Backend .Team/QueryProcessor .metabase-lib +3
    
23. [MLv2] [Bug] Error when calling available-join-strategies #32081
    .Team/QueryProcessor .metabase-lib +2
    
24. [MLv2] Mark selected join condition columns #32438
    .Team/QueryProcessor .metabase-lib +2
    
25. [MLv2] [Bug] Join fields generate unexpected field references #32437
    .Team/QueryProcessor .metabase-lib +2
    
26. [MLv2] Make joinable_columns return JS array #32443
    .Team/QueryProcessor .metabase-lib +2
    
27. [MLv2] [Bug] Error when using replace-clause with joins #32454
    .Team/QueryProcessor .metabase-lib +2
    
28. [MLv2] Add a method to get query's database ID #32480
    .Backend .Team/QueryProcessor .metabase-lib +3
    
29. [MLv2] [Bug] group-columns works incorrectly with join-condition-rhs-columns #32509
    .Backend .Team/QueryProcessor .metabase-lib +3
    
30. [MLv2] joinable-columns returns nothing if a given table isn't linked to the source table #32511
    .Frontend .Team/QueryProcessor .metabase-lib +3
31. [MLv2] It should be possible to call join-lhs-display-name without a join or a joinable #32530
    .Backend .Team/QueryProcessor .metabase-lib +3
    
32. [MLv2] [Bug] join-alias is only added to the first condition's field reference #32558
    .Backend .Team/QueryProcessor .metabase-lib +3
    
33. [MLv2] Tweaks to join-lhs-display-name method #32764
    .Team/QueryProcessor .metabase-lib +2
    
34. [MLv2] Join conditions should sync temporal units #32759
    .Backend .Team/QueryProcessor .metabase-lib +3
    
35. [MLv2] [Bug] Error when joining a saved question #32758
    .Backend .Team/QueryProcessor .metabase-lib +3
    
36. [MLv2] Fix long display name for columns from cards #32803
    .Team/QueryProcessor .metabase-lib +2
    
37. [MLv2] [Bug] Suggested condition could miss LHS column's join-alias #32897
    .Backend .Team/QueryProcessor .metabase-lib +3
    
38. [MLv2] [Bug] Datetime LHS/RHS columns are not marked as selected if they have a temporal unit #32920
    .Backend .Team/QueryProcessor .metabase-lib +3
    
39. [MLv2] Unexpected field reference option for datetime join condition columns #33012
    .Backend .Team/QueryProcessor .metabase-lib +3
    
40. [MLv2] Infinite recursion when building a custom column with joined card columns #33086
    .Backend .Team/QueryProcessor .metabase-lib +3
    
41. [MLv2] Column not found errors when joining cards #33083
    .Backend .Team/QueryProcessor .metabase-lib +3
    
42. [MLv2] Selected LHS/RHS column is missing bucket info in join-condition-columns methods #33082
    .Backend .Team/QueryProcessor .metabase-lib +3
    
43. Nominal Field Reference Causes Malli Stackoverflow #32063
    .Backend .Team/QueryProcessor .metabase-lib Type:Bug +4
    
44. Make MLv2 join more convenient for common usage patterns #33454
    .Team/QueryProcessor .metabase-lib no-backport +3
    
45. [MLv2] expression-parts tries to unwrap nth ColumnMetadata objects #34370
    .Backend .Team/QueryProcessor .metabase-lib +3
    
46. [MLv2] Error when removing a join using a column from previous stage join #34404
    .Backend .Team/QueryProcessor .metabase-lib +3
    
47. [MLv2] Unexpected suggested-condition behavior #34526
    .Backend .Team/QueryProcessor .metabase-lib +3