Need to fetch specific rating table by effective date
Open
@rma-psmorris is already working on this.
Since Apr 13, 2026.
bug
- Dominant language
- Java
- Stars
- 28
- Forks
- 25
- Avg merge
- 4d 22h
- Merged PRs (30d)
- 20
Description
It doesn't seem possible to fetch a specific rating table that isn't the latest. It's either the latest, or all tables.
Fetching all tables takes a long time and frequently returns an Oracle XML error, so I'd rather not do that.
Describe the solution you'd like
Something that operates as the equivalent of this SQL query:
SELECT IND_VALUE_1, DEP_VALUE FROM CWMS_20.AV_RATING_VALUES_NATIVE where rating_code=? order by ind_value_1 asc
Something like /ratings/{rating-id}/{effective-date}.
I use the rating code internally, which is unique. However that's not exposed in any of the CDA methods, so I guess rating-id and effective-date have to work.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.