search

FHIR / sql-on-fhir-v2

This project provides the source for the SQL on FHIR v2.0 Implementation Guide
https://build.fhir.org/ig/FHIR/sql-on-fhir-v2/
MIT License
100 stars 27 forks source link

Sort and Limit element #239

Closed EvanMachusakNCQA closed 3 months ago

EvanMachusakNCQA commented 5 months ago

DataRequirement has a limit element and a sort element.

We should consider adding optional sort and row limit elements on view definitions.

Analytics use cases frequently deal in samples, so being able to use a view definition to extract a slice of, e.g., the most recent 100k resources matching the conditions in the where element could be useful.

johngrimes commented 3 months ago

We have decided to include this capability as a non-goal for this specification, as we reasoned that it is easily layered in most execution environments and it is not a problem that is specific to FHIR or for which there is value in creating a standardised solution.

Please re-open if you have any more thoughts or would like us to take another look at this.