HS.FHIRServer.Util.FHIRQueryUtils
class HS.FHIRServer.Util.FHIRQueryUtils extends HS.FHIRMeta.MetaUtils, HS.FHIRServer.Util.RunSQLQuery
This class is intended to be inherited into other classes that work with SQL and FHIR-based data. It provides conversion utilities as well as naming conventions that are shared among Table Generation, Indexing, and QueryingMethod Inventory
Parameters
parameter PERIODENDSUFFIX = End;
Suffix to create Column Name from property name for end-of-period
parameter PERIODSTARTSUFFIX = Start;
Suffix to create Column Name from property name for start-of-period
Methods
This method is used by Indexer and by Search.
Given a date, partial date or partial timestamp, return the first instant (second), converted to UTC, that falls within that input.
For example, an input value of "1974" when the current server is in US Eastern time would return "1974-01-01T05:00:00Z".
A date/time that already has second precision will be returned with fractional seconds stripped.
Given a date, partial date or partial timestamp, return the first instant (second), converted to UTC, that falls within that input.
For example, an input value of "1974" when the current server is in US Eastern time would return "1974-01-01T05:00:00Z".
A date/time that already has second precision will be returned with fractional seconds stripped.
This method is used by Indexer and by Search. It assumes that the input value has
already been validated.
Given a date, partial date or partial timestamp, return the last instant (second), converted to UTC, that falls within that input.
For example, an input value of "1974" when the current server is in US Eastern time would return "1975-01-01T04:59:59Z".
Given a date, partial date or partial timestamp, return the last instant (second), converted to UTC, that falls within that input.
For example, an input value of "1974" when the current server is in US Eastern time would return "1975-01-01T04:59:59Z".
Normalize a phone number for indexing and search by stripping out punctuation and whitespace
Given a timestamp in YYYY-MM-DDThh:mm:ss format, return the value
of the timestamp that is one second prior