on your question:

Is there a way from an eholdings provider record to make a call to get all agreements tied to any package tied to that provider?

Sample decode package look up request

Based on the current API it is not directly available – only way I see it may be possible is by doing a query using the first part of packageId (which is providerId) – per below question. Not sure if this is recommended/suggested -

– wondering on this question – could we do a query for items.reference that starts with '19-' for example (which is the provider id portion of the package id) items.reference==19-1615?
Note – above query would pull in packages and title+packages both. Naming convention for title+packages (resource) is providerId-packageId-titleId.

Is there a cleaner way to indicate providerId at the point when we establish the link to a package or title+package?

- regarding this bullet "Ability to access attached agreement record via eholdings provider/package/title+package detail records"

• Is there a way from an eholdings provider record to make a call to get all agreements tied to any package tied to that provider?

Determine if current Agreement App functionality supports

1. Ability to search for Agreements (yes)

Below request observed from ERM UI (network traffic) when searching for agreements (by name and status) and sorting by name (asc or descending)

2. Ability to create an Agreement (yes)

Sample link to example POST request which creates an agreement with a single linked eHoldings package

https://github.com/folio-org/mod-agreements/blob/ed710822f9ead110f8eb2639d2cfc9f0bbd9322c/scripts/eholdings/create_agreement.sh#L13

3. Ability to attach an agreement to eholdings package/ title+package (yes)

Sample PUT request to add a package

https://github.com/folio-org/mod-agreements/blob/ed710822f9ead110f8eb2639d2cfc9f0bbd9322c/scripts/eholdings/create_agreement.sh#L36

4. Ability to access attached agreement record via eholdings provider/package/title+package detail records - (package and title/package - yes, provider -no)

Sample code to search for an agreement based on package or package title

https://github.com/folio-org/mod-agreements/blob/ed710822f9ead110f8eb2639d2cfc9f0bbd9322c/scripts/eholdings/create_agreement.sh#L48

https://github.com/folio-org/mod-agreements/blob/892be44b13a42379f926215965ae9e895d2b9d76/scripts/dev_submit_pkg.sh#L203

5. Ability to unassign an agreement from a package/title+package (yes)

https://github.com/folio-org/mod-agreements/blob/ed710822f9ead110f8eb2639d2cfc9f0bbd9322c/scripts/eholdings/create_agreement.sh#L45

6. Ability to return # of agreements and statuses (yes) -- assuming list results

Available as part of 1 or 4 (list of results – provides count and can be filtered by status)

This can be gotten by a request such as the following

It may be possible to additionally set pagination so that it doesn't return records to do this more efficiently, But the basic query is as noted in the example

7. Determine if Agreements app can support the above screenshots

Based on current screen shot (Yes) – supports this functionality
https://drive.google.com/file/d/1B-2EkPollcCibuMT28np2-BvV8LdODcD/view?usp=sharing

Below notes are regarding prior/obsolete screen
On previous screenshots for search – only sort by name is available (no relevance)
https://drive.google.com/file/d/1KfGis8oqMfACoR3nlDvWK9mbjE9zQOrI/view
Mapping of displayed detailed fields - fields can be added where attributes are dynamic – similar to licenses (note – not in place yet)

last updated - ?
name - name
start date - startDate
end date - endDate
cancellation date - cancellationDeadline
vendor - vendor
status - agreementStatus
subscription term - ?
description - description
renewal status - renewalPriority?
auto-renew - isPerpetual?

Below reference to controller and model for SubscriptionAgreement
https://github.com/folio-org/mod-agreements/blob/892be44b13a42379f926215965ae9e895d2b9d76/service/grails-app/controllers/org/olf/SubscriptionAgreementController.groovy
https://github.com/folio-org/mod-agreements/blob/892be44b13a42379f926215965ae9e895d2b9d76/service/grails-app/domain/org/olf/erm/SubscriptionAgreement.groovy

Adding reference to script which was noted by for examples:
https://github.com/folio-org/mod-agreements/blob/master/scripts/eholdings/create_agreement.sh
https://github.com/folio-org/mod-agreements/blob/892be44b13a42379f926215965ae9e895d2b9d76/scripts/dev_submit_pkg.sh

some documentation could be found here and Java sources here