I currently have a Saved Billing Rate Card Search. Unfortunately ive had no luck in getting only the latest version and its fee rates to show. Can anyone provide guidance?
You cant use SQL Max function in criteria.
Ive tried using the grouping method, but when you set version to maximum, if you set price to maximum it only shows whatever the max value is and not the value that relates to the latest version.
For example
Default rate card.
Card A - £100 on V1
Card A - £60 on V2
If you set max for version it will show V2 Card A.
If you set max for price it shows V2 Card A but price of £100 and not £60.
Ive tried to go by effective date but also no luck on achieving. Any help would be appreciated please.