Bug 33507 - EBSCO packages - Dont list already related agreements when adding a new agreement
Summary: EBSCO packages - Dont list already related agreements when adding a new agree...
Status: ASSIGNED
Alias: None
Product: Koha
Classification: Unclassified
Component: ERM (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Pedro Amorim
QA Contact:
URL:
Keywords:
Depends on: 33483
Blocks:
  Show dependency treegraph
 
Reported: 2023-04-12 15:21 UTC by Pedro Amorim
Modified: 2023-04-13 07:07 UTC (History)
5 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 33507: WIP (3.22 KB, patch)
2023-04-12 15:23 UTC, Pedro Amorim
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Pedro Amorim 2023-04-12 15:21:41 UTC

    
Comment 1 Pedro Amorim 2023-04-12 15:23:19 UTC
Created attachment 149563 [details] [review]
Bug 33507: WIP

This is a work in progress, have not been able to get the 'not equals' query to work, its documented as a comment in the code
Comment 2 Jonathan Druart 2023-04-13 07:07:23 UTC
Try that:

{ "agreement_packages.package_id": [ {"!=": 1}, {"=": null } ] }

You want to list those that are not linked with the current one but also those that are not linked with any packages (it's a left join).