Written by

VP and COO (Retired) at Healthcare Integration Consulting Group
MOD
Question Jeffrey Drumm · 3 hr ago

Business Service that Accepts Optional Properties, Executes Once on Enable/Start, and Resets after OnProcessInput()

I have a number of services that call SQL stored procedures and map their result sets to Record Map Batch objects. The stored procedures take optional start and end date parameters, but default to the prior day for their daily run.

Because the database they're running against is an asynchronously updated data repository for an EHR, there are times where the stored procedures will not capture all the data that should have been there and we need to re-execute the stored proc with a specific date (and sometimes time) range.

An option I've been considering is the inclusion of properties in the service class that support setting a date/time range, but ideally I would want those properties to "reset" to defaults (System Default Settings aka SDS) after the service completes a one-time processing cycle and re-enable for normal operation.

The workflow from an operations user's standpoint would be to access the service's properties in the Production editor, modify the (custom) start and end date fields, clear the Schedule field if necessary, apply the settings and restart the service. When the Service starts up and finds the date fields populated, it would call the stored proc with the date parameters, compose the batch from the result set, send it to the target business host, clear the custom properties and reset any fields that were populated via SDS and finally restart the service.

I'm not averse to experimentation to see what I can come up with, but was wondering if anyone has tackled something similar.

Product version: HealthShare Health Connect 2025.3