Scheduled Reporting - Calculated Date Parameters

Donate to this project

Development Project Status: Completed

Total cost estimate (ex-Tax): 
Due date for completion of this stage: 
Current Percentage Funded: 
Project funding: 

You can donate money to this project by entering the amount above and clicking the 'Add to cart' button. In the Checkout process you can either choose to pay now (via Bank Transfer, Cheque or Pay Pal) or you can pledge the amount by choosing the 'Pledge a payment for a Development Project' method. If you make a pledge, then when we have 100% funding commitments, you will be notified by email and you can then action your payment. Note that development will not commence until all funds are received.

Project description: 

This project will extend the Scheduled Reporting functionality included in OpenVPMS 2.0 to support calculated date parameters.

This will allow standard OpenVPMS reports to be easily scheduled. Currently these must either:

  • be modified to calculate the date range to query
  • have the parameters configured manually, before the report is scheduled to run

For each date parameter, the following list of options will be available:

  • Today  - the current date
  • Yesterday - yesterday's date
  • Tomorrow - tomorrow's date
  • Now - the current date/time
  • Start Of Month - the first day of the current month
  • End Of Month - the last day of the current month
  • Start Of Last Month - the first day of the previous month
  • End Of Last Month - the last day of the previous month
  • Date - a specific date, to support the existing behaviour

With the exception of the Now option, the date will be calculated and supplied to the report with a 00:00:00 time component.

User Interface

Each date parameter will have a dropdown next to it, allowing the user to select from one of the above options. If Date is selected, a date-chooser will be displayed to select the date.

Archetype Changes

The entity.jobScheduledReport archetype needs new hidden paramExprType1...paramExprType14 and paramExprValue1...paramExprValue14 nodes to store the expression type and value.
The expression type will be 'date', but could be expanded to support jxpath expressions in future.


Existing Scheduled Reports will need to be migrated




Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Scheduled Reporting - Calculated Date Parameters

thanks tim. we will fund this

Re: Scheduled Reporting - Calculated Date Parameters

Thanks very much Adrian

Syndicate content