|
|
| Sample management : |
 | New sample details and history screens (more detailed overview). |
| | Possibility to update exported values in DubQuest sample (new version of export_sample_... sp-s). |
| | Scheduled samples start filter supports "around" (past and future) filtering. |
 | Fixed version of the get_next_scheduled_sample_to_run sp to avoid picking and starting not fully saved scheduled samples. |
| | Fixed version of the get_selection_parts_lbr sp to use LEFT OUTER JOIN when the same feature is used, and the first condition's operator is not the "Is not filled" but some of the following one is in a link based requirement. |
| | Fixed version of the get_samples and get_scheduled_samples sp-s not to wait for access to the Samples, etc. tables (uncommitted read). |
| |
| System information pages: |
 | List of database processes (all, active, blocked, cpu usage). |
| | Detailed information about the currently running sample. |
| | Report of slow samples (link to full sample history). |
| | Yearly and monthly report of sampling (amounts and performance). |
| | Monthly report of member data (entites, feature values). |
| | SMS notification service (to report blocking situations). |
| |
| Database related: |
| | New table Panel_log_daily to store the daily summary of the panel log information (also the number of members, feature values). |
| | New index IX_Scheduled_samples__status__start to speed up the query by the get_next_scheduled_sample_to_run sp. |
| | New index IX_Sample_versions__version__sample_id__others to speed up get_samples sp calls. |
| | New index IX_Panel_log__log_type__others to speed up panel log related queries (update_daily_panel_log). |
| |
New sp "update_daily_panel_log " to update the Panel_log_daily contents (background process to call it daily). |
| | New sp-s "get_created_samples_count , " and "get_active_members_count " to get the sample creations and the number of active members from the Panel_log_daily table. |
| |
New sp "add_feature_value_binary , , , " to get the nvarchar value parameter as a varbinary type (for Delphi support). |
| |
Shifting the used scheduled sample status codes, because the new "Waiting" status is 4 (4->5, 5->6). |
| | Truncating the too long description fields before the column type conversion. |
| |
Fixed version of the update_member_states sp because it referenced a not defined temporary table, also using table variables instead of temporary tables. |
| | Fixed version of the add_value sp not to lock the FValuesN tables during the feature history handling. |
| |
Fixed version of the get_values_for_export sp to handle the multiple enum exports on a more efficient way. |
| | Fixed version of add_feature_value sp to handle the questionnaire counter features and the consecutive non responses correctly. |
| |
| Others: |
| | Handling feature history in member data editing (view, and retreive old values). |
| | Statistics, report, and dynamic target details screens. |
| | New program rights: Use the "Add Random" option (Sample management), Use the "Add by participation" option (Sample management), Use the "Remove all" option (Sample management), View System Info. |
| |
The first start time of the membership status update process is an adjustable system setting. |
| |
Using proper code page to display unicode characters in JSP pages. |
| |