Release Notes Dub Knowledge 2.3.0

For detailed information about version 2.3.0 click here
Sample management:
Rim based distribution handling (e.g. 50%/50% gender; 50%/50% age categories; 40%/30%/30% area) (not yet available in the scheduled samples) (For detailed information here)
Possibility to choose a DubInterviewer project (to link with) and auto export after the sample creation, exporting standard features only, also available for scheduled samples and the link must be set when the export is initiated from DubQuest. (For detailed information here)
Using delta dates in the date type feature based expressions - relative dates (like today or yesterday or in the last two weeks). (For detailed information here)
Handling modification date like a date type feature (all operators, delta dates), and the validity as an integer feature in selection conditions.
System flag which protects a scheduled sample from starting when a direct sample in progress. Also showing a warning when someone starts a new direct sample while another scheduled or direct sample is running and blocks the members. Possibility to clear this flag at the System setting/Sample service. (Showing the id and name of the concurrent sample on the scheduler main screen, also in the popup warning in the direct sampling)
Sample selection screen. An aid to help the user to exclude the members from the current selection who participated in previous projects (samples) was added. (For detailed information here)
An option to choose/ use feature_id when pasting a feature based requirement.
New query structure is used in case of excluding samples or questionnaires in update_selection_members sp (exists sub query instead of many joins and block of IS NULL conditions).
Auto delete pending or broken samples in every two hours by a server background process. Showing (in sample service) and possibility to remove broken sample versions (Add/Remove members).
"By Participation" option is present and usable in scheduled sample management. Default state of this checkbox is a system setting.
Add/Remove sample members use the original sample's selection conditions.
Moving (up/down button) selection condition items.(For detailed information here)
DubQuest imported samples are shown differently (green highlight) in the main sample table.(possibility to filter on this attribute).
Confirmation on preset and clipboard loading or using clear not to overwrite the existing data (all preset related screens).
Possibility to use Undo on the selection screen.
Both the [feature name] and the [] syntax is available for pasting feature based requirements from the clipboard.
The finish button should is enabled only on the last screen of the scheduled sample wizard.
Assigned program rights to limit the access of the following parts: - Keeping the sample with the same name (new sample) - "Get all available" option (new sample)
Fixed: pasting a link based requirement from the clipboard didn't contain the link direction code correctly and it causes "Invalid column name 'value'" SQL error (also a problem with loading old presets).
Fixed: Color highlight stayed the same order even if the listing order changed in the scheduled samples table.
Fixed: Editing a scheduled sample without a reservation date got an unwanted reservation date if the "Auto create reservation..." system setting was turned on.
Fixed: The scheduled sample failure was not logged in details by the Dub Knowledge server (the result code of update_selection_members sp)
Fixed: Run query button becomes enabled even if the selection requirement was not valid.
Fixed: get_survey_status_by_cells calls was slow, sometime many calls were needed for one Dub project.
 
Feature management:
Possibility to use the same link feature for more entity types.
New feature type and related operators to support the storage and usage of unicode strings (called WideString).(For detailed information here)
Not to add new entity_id-s by the add_feature_value sp (import new entity creation is updated to still use 0 to generate new id-s)
New feature's default entity type comes from the feature tree's current entity type.
It is possible to delete feature even if it's referenced by a QuickList.
After editing a sample feature value_table field becomes 1 (instead of 6) in Features table, this is fixed.
 
Dub InterViewer connectivity :
New stored procedure (unsubscribe_member) to remove unsubscribed members from Dub Knowledge and DubQuest samples as soon as they unsubscribe from the panel (not to be called/emailed any more).
Possibility to add constants by the export_sample_to_filling stored procedure (export_sample_to_fillingn 'MyProject', 123, 1, 'name,gender,week,batch', '10,13,"200523","'batch1"').
Importing samples into Dub projects is faster if it's a pull and not the push way.
System feature for storing the length of the questionnaires. (the longest which is filled by the respondent), new sp for DubInt to update this value -> add_questionnaire_duration
 
Scheduled samples:
Color highlight changes order if the listing order changes in the scheduled samples table.
Scheduled sample failure is logged in details by the Dub Knowledge server (result code of update_selection_members sp).
 
QuickList:
Applying a new parameter without turning off and on the instant filtering in QuickLists, also make QuickList usable in FireFox.
 
QuickReport:
Report updates is spread, reports are not updated in one call.
QuickReport (qreport_id = 31) is editable.
It is possible to follow a QuickReport link without repeating login.
Multi target QuickReport entries can contain reports with different number of result rows. The stat changed as well as the QR entry. Fixed "Array index out of range" error.
Statistics or report changes or removals could cause problems in QuickReport entries (having invalid report_id parameters).
 
Import:
Showing a warning when import contains (non) existing entity id-s. Can be turned on and off.
 
General:
All names and descriptions in the system (features, samples, etc.) are stored as unicode strings for better adaptation of foreign languages.
Reporting client side (applet) errors in a popup window.
Naming changes (e.g. QuickList entries is columns).
General concept of targets (global, samples, dynamic) is available at every place where it’s applicable. (Edit MemberData, Export).
Member deletion by membership status didn't update the involved sample totals (members gone from the sample but the total remained).
 
Technical:
Reporting server errors of background processes to the user (like read cascade update). Now it remains mostly undiscovered as it's in the server log only.
Plug`in download link is different for Win/Linux clients in the Panel.jsp and HiddenApplet.jsp.
Defining a primary key for the table 'Data_from_dubinterviewer'.
Added a number of sp’s to simplify connection between Member site and Dub Knowledge.
Removing the linked server usage from the export_sample_to_samplenr and export_sample_to_fillingn sp-s
Questionnaire feature values is stored in a separate table (FValues8) for better performance, updating all the related sp-s (9)
Long selections do not stay in "Please wait..." state in the applet even if it's done without any problems on the server side.