[FOLIO-727] Support multi-field queries in CQL2PgJSON Created: 18/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: P3
Reporter: frances.webb@cornell.edu Assignee: frances.webb@cornell.edu
Resolution: Done Votes: 0
Labels: sprint18, team1
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
Relates
relates to UIU-101 Sorting on patron-group should be by ... Closed
Sprint:

 Description   

Business logic modules are starting to need to execute join queries against multiple data sets, but the CQL2PgJSON class currently assumes that all field elements referenced in a query will be in the same jsonb field.

The new mode should:

  • Accept a list of field names (and possibly associated schemas) on instantiation
  • Require that all field elements referenced in queries be unambiguous if schema validation is in use.
  • Require that if schema validation is not in use, all field elements referenced in queries be prefixed with the appropriate jsonb field name.


 Comments   
Comment by frances.webb@cornell.edu [ 19/Jul/17 ]

Pull request is submitted... version number needs updating.

Comment by Jakub Skoczen [ 20/Jul/17 ]

Ping me when we have the PR merged, I'll make the release.

Comment by shale99 [ 20/Jul/17 ]

guys, i need this merged, the weekend is almost upon us (me) and i have a bunch of code to check in that fixes UIU-101 Closed and UIIT-33 Closed that i dont want hanging around..

Comment by Kurt Nordstrom [ 20/Jul/17 ]

Looking at this now.

Comment by shale99 [ 20/Jul/17 ]

appreciated!

Comment by frances.webb@cornell.edu [ 20/Jul/17 ]

Thanks for the merge, Kurt Nordstrom!

Comment by Jakub Skoczen [ 24/Jul/17 ]

Released as v1.2.0

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