A view is a join than can easily be reused and makes the queries more readable.
shale99 July 4, 2017 at 4:45 AM
actually, why a view, why not just run join queries where needed?
shale99 July 3, 2017 at 6:41 PM
Edited
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
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 https://folio-org.atlassian.net/browse/UIIT-33#icft=UIIT-33 and https://folio-org.atlassian.net/browse/UIU-101#icft=UIU-101). For inter-module sorting we need https://folio-org.atlassian.net/browse/FOLIO-704#icft=FOLIO-704 resolved.