Bug 33507

Summary: EBSCO packages - Dont list already related agreements when adding a new agreement
Product: Koha Reporter: Pedro Amorim <pedro.amorim>
Component: ERMAssignee: Pedro Amorim <pedro.amorim>
Status: ASSIGNED --- QA Contact:
Severity: enhancement    
Priority: P5 - low CC: jonathan.druart, jonathan.field, martin.renvoize, matt.blenkinsop, pedro.amorim
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 33483    
Bug Blocks:    
Attachments: Bug 33507: WIP

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).