[FOLIO-705] implement intra-module joins/views to enable sorting on linked fields Created: 03/Jul/17  Updated: 12/Nov/18  Resolved: 24/Jul/17

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Task Priority: P2
Reporter: Jakub Skoczen Assignee: shale99
Resolution: Done Votes: 0
Labels: core, sprint18, team2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Blocks
blocks UIIT-33 Sorting on material-type should be by... Closed
blocks UIU-101 Sorting on patron-group should be by ... Closed
blocks UIU-33 Filter User List by Permission Sets Closed
Relates
relates to FOLIO-704 Investigate a central compound object... Draft
relates to FOLIO-677 Sorting on names (rather than IDs) of... Draft
Sprint:

 Description   

This will be applicable only in case where data for the main object and data for the related object (on which we want to sort) lives in the same storage modules. Those use cases happen to be most pressing though (see UIIT-33 Closed and UIU-101 Closed ). For inter-module sorting we need FOLIO-704 Draft resolved.



 Comments   
Comment by shale99 [ 03/Jul/17 ]

one issues i guess i have is that i do not know what the performance would be like. this would of course be a view which is a join of two tables - what is the performance impact of running a join on two separate tables? - there may not be a difference if it just using indexes - if that is the case then this sounds like a reasonable solution

Comment by shale99 [ 04/Jul/17 ]

actually, why a view, why not just run join queries where needed?

Comment by Julian Ladisch [ 15/Jul/17 ]

A view is a join than can easily be reused and makes the queries more readable.

Generated at Thu Feb 08 23:07:45 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.