Release Notes Dub Knowledge 2.2.5

Scheduled sampling :
	Possibility to use more cell counting types on the last screen of the scheduled sampling (normal cells, cell oversampling, get all). (For detailed information here)
	The default time to start is the current time for a new scheduled sample.
Features :
	Tracking survey history by "Questionnaire status counters" (system features for each survey status; filled by the system automatically).(For more information click here)
	Tracking the activity of a member by "Consecutive non-responses" (system feature which increments on invites and resets to 0 on participation; filled by the system automatically).
	"Date of last participation" feature is filled by the system automatically.
	Feature tree should show the features of "Persons" by default not the "All". It showed "Persons" on the top of the screen but the tree showed all.
	Moving a feature to one of its own children blocked the feature tree, and the browser got frozen.
Sample management:
	Faster sampling (the cell creation part saves the cell members so the sample creation part can use it and doesn't have to run heavy cell queries again)
	Link based requirements lost the link direction information. It happened when the link feature could be used in both directions. (e.g. person to person links)
Edit member data :
	Show differently (various) and (not filled) values for lists, selections and samples.
Other:
	Java-plug in download link is different for Windows and Linux clients.
	Data export download dialog didn't work in FireFox (in 2.2.4 only)
Dub Knowledge 2.2.4:
Updates:
	Blue color highlight for ready scheduled samples which contain less members than the requested amount (total sampled < total gross n)
	No warning in the database upgrade script.
	DubInt specific feature value adding sp renamed to add_feature_value_bulkmode.
Dub Knowledge 2.2.3:
Scheduled sampling:
	You can define a complete sample and assign a date and time to it as “Start” - scheduled samples (For detailed information here)
	The sample will be executed after the start time when the background sampling process is active.
	The earliest scheduled sample will be executed first when there are more scheduled samples in due (so the start time is also a priority).
Software licence checking:
	Encrypted registration information is stored and checked by the system.
	Some parts of the KnowledgeServer.properties file is provided by Nebu.
Context sensitive help:
	F1 button invokes help (no content yet).
Updates:
	All JSP files are changed to valid HTML format.
	Possibilty to show the feature_id in the feature tree of member data editing. (For detailed information here)
	Sample selection action dialog is more user friendly.
	Default button to give names to presets. (For detailed information here)
	Double click invokes edit everywhere. You do not have to select feature/item and then press button edit.
	Feature tree show the persons' features by default (not all). (For detailed information here)
Fixed problems:
	Can not delete enum value because of the wrong usage checking.
	"Disappearing samples problem".
	Deleting feature value does not work when feature stores history information.
	Temporary selection based on "one to many links" throws primary key error.
Dub Knowledge 2.2.2:
Sampling:
	You can append the contents of a sample selection or cell preset to the current condition by pressing Ctrl + Load (Append) (For detailed information here).
	Using "Other" cell conditions is an option now (a new checkbox on the cell condition panel). The default is not to use "Other" cell conditions. It makes the cell creation easier and faster. (For detailed information here)
	It's possible to follow (progress bar) and cancel the cell creation during sampling. (For detailed information here)
	Faster stored procedure to get the sample list.
	More handy distribution percent and quota values editing. Instant typing.
	Fixed: When editing an existing "link based requirement" on the sample selection screen the changes where not saved.
	Fixed: Sample selections gave sql syntax error. If the selection contained too many conditions the dynamic query was truncated and invalid.
	Fixed: The selection part of the sampling didn't work in special cases. When the selection action was "Add by participation" and there was a LBR condition in the selection.
	Fixed: If user was in the sample creation and clicked "Logout" the sample was not cleared automatically.
	Fixed: Getting the number of the reserved members during setting a new reservation date was wrong sometimes.
Features:
	New, advanced stored procedures for feature value reading.
	"get_questionnaire_feature_id" stored procedure handles any entity type, not persons only.
	Fixed: Features having higher feature_id parents were not shown in the feature tree if the parent was not on the root level.
	Fixed: Several problems in the update_read_cascade_values stored procedure (CPU 100% query plan, NULL cascades, invalid cascades).
	Fixed: Editing a link feature referencing households or other not person entities showed that it was a link to persons.
Enumeration values:
	While entering enum values, you can copy (Ctrl + V) and paste (use paste button) lists from the clipboard (text editor) into the enum value list. (For detailed information here)
Data import:
	There's a working Cancel button on the import progress dialog. For detailed information here)
Reports:
	Fixed: get_stat_condition_sql sp built an invalid SQL expression (FROM clause) when the statistics contained a feature which had sub values (sub features having the same type).
	Fixed: Updating report results caused CXPACKET deadlock sometimes on database servers having more CPU-s.
Other:
	Clustered indexes for all tables and other query helping indexes to speed up some of the selects.
	The applet handles better the case when a "Please wait..." dialog is displayed and an exception happens. No frozen browser any more.
	Small improvements in get_features and find_feature_by_name sp-s.
	Checking and improving the following stored procedures: get_features find_feature_by_name get_questionnaire_feature_id add_earned_points_by_questionnaire grant_object_policy_access
	Fixed: If one feature adding returned an error code then the next one would add a negative entity_id to the system during import.
	Fixed: Pressing many tabs on sample table tab of the data editing page caused the table cells to be selected and the buttons enabled even if the table was empty
	Fixed: Deleting enum value was not possible when a new enum type was created, it was possible only at after saving values.
Dub Knowledge 2.2.1:
Export:
	Using all kind of targets (global, samples, dynamic) in exporting data. (For detailed information here)
	Data listing sp to get the recently updated user data.
Import:
	Entity type change from the drop down list took too long on the first screen of the Import Wizard.
	CSV upload checks better the format of the uploaded file (number of columns for each row, file is empty or not, column names are unique or not).
	List of CSV files was not ordered correctly.
	Fixed: Import problem when 0 is used as entity_id to make new members.
	Fixed: Wrong SQL type was used during import validity check if float or date features were checked before importing.
	Fixed: Import validity check and the import script did not handle the empty strings correctly.
	Fixed: CSV Upload used the carriage return character as the part of the values at the end of lines.
	Fixed: "Out Of Memory Error" occurred during bigger CSV file uploads.
Screening:
	Better visualization of the compared members in the comparing table in screening.(For detailed information here)
	Compare table contained the members in an unhandy order.
	New cleaning mode: Inserting periods in between initials.
	Warning dialogs if there are no screening features defined.
	Fixed: If the screening criteria contain many features then the scr_get_next_to_compare sp fails to handle the long expression.
	Fixed: In some cases directly after starting the screening the CPU usage went to 100% and the query ran "forever".
	Fixed: "Invalid syntax" SQL error was received if the screening started but the screening features had not been defined yet.
	Fixed: Not unique members were compared to all other members even if it was another entity type.
	Fixed: Difficult editing of the screening features in the screening features table.
	Fixed: The screening stored procedure screened to every entity type so you could get one entry in the comparing table marked as not unique.
QuickLists:
	System variable for user_id ($$U) and user name ($$N) in QuickLists.
	Possibility to display feature values in the QuickList for JavaScript (backslashed quotes) by $$Jnn system variable.
User Interface:
	Faster feature tree (the whole tree is loaded in one step).
	Better left side (html) menu. Clearer names, better order, extra points for accessing statistics, reports, QuickReports.(For detailed information here)
	Tool tip texts are added to show the full contents of table headers and cells.
	Fixed: Split tables (sample distribution, screening compare) were not scrolled properly if the left part was scrolled by arrow keys.
Sample management:
	The "Clear" button cleared the entire selection at adding members. Now the default part remains. (For detailed information here)
	Label changed to "Validity is not less than" in the selection condition editor.(For detailed information here)
	Better logging of sampling events (especially the cell creation).
	Fixed: Deleting enum value was not possible when a new enum type was created, it was possible only at after saving values.
QuickReports:
	Fixed: When the statistics list is empty for an entity type and a new report is being created then we get NullPointerException on OK.
	Fixed: Clicking on the QuickReport update report link leaded to the main QuickReport listing page instead of refreshing the report.
	Fixed: When the report list is empty the QuickReport entry adding got frozen when clicking "View".
	Fixed: Not standard HTML output and style sheets causes QuickReports rendered in an ugly format in FireFox browser.
Member Data Editing:
	Fixed: Editing a member from the QuickList didn't work if the listing feature was not filled for the entity type of that member.
	Fixed: The Set and Delete button stays enabled when the root feature is selected in the Member Data Editing screen.
	Fixed: Copy/paste in Hidden Applet page (Member data editing from QuickList).
User Management:
	Fixed: Extra foreign key constraint in Recently_used_features table caused errors on removing users.
	Fixed: Mis-spelled 'rights' in tool tip of Program button corrected.
	Fixed: Changing user rights for "Selection presets" object type caused class casting exception.
Technical:
	Encryption of the database password in the properties file.
Other:
	Fixed: Some of the screens got interrupted without proper cancel if the left side HTML menu was selected.
	Fixed: After changing a feature type the value table was not correct in the database.
	Fixed: Missing text resource made impossible to use the add sample members function.
	Fixed: Adding new membership status deleted the recent changes in the "System Settings/Membership Status" table.
	Fixed: UI problems of the link based requirement filter expression table and details. "A (and B)" problem.
	Fixed: Sample having a negative number of members.
	Fixed: "QuickReport" label text in new/edit QuickList entry dialogs.
	Fixed: Write cascade initialization sp logs its activity as a "read cascade value update".
	Fixed: Using GETDATE() in write cascade expressions cut the seconds.
Dub Knowledge 2.2.0:
New:
	Sub values - new operators to build feature expressions based on sub values (only in statistics). (For detailed information here)
	Dynamic targets - a predefined selection which renews and stores its members regularly (useable in Reports and QuickLists).
	Dynamic filters - a feature based expression which can be used for filtering target groups (useable in QuickLists).
	Reports - A statistic combined with a target group (like a dynamic target or a sample) takes a report. The report results are collected and stored in the background regularly as it's specified.
	CSV upload - Possibility to upload and import comma separated lists into the panel database.
QuickReports:
	The contents of a QuickReport are manageable from the system. (no JSP editing any more).
	The data results of a QuickReport come from the predefined Reports this means that a heavy system load is omitted (no prompt queries any more).
	QuickReports are available independently from the Dub Knowledge (public or login).
	New QuickReport entry types. (For detailed information here)
	The look and the content of a QuickReport is very flexible (entry order, elements to show, style).
	Possibility of instant report refresh from a QuickList.
QuickLists:
	QuickList can be applied on every target group (global, sample, dynamic target).
	Content management includes: column feature, column order, width, alignment, hidden column, etc. (For detailed information here)
	Filtering of lists by instant, column based filters. (For detailed information here)
	Filtering of lists by predefined Dynamic filters. (For detailed information here)
	Better paging (no endless list if the database is big).
	One page QuickLists (Target, QuickList, Filter, Page selection on one integrated page).
	Customizable header and footer for a QuickList and using styles for flexible look.
	Open text columns to show user defined contents (e.g. Dub InterViewer links).
User interface:
	Button hints on every button in the system (helping the user). (For detailed information here)
	Edit button on the Feature constraint page. (For detailed information here)
	Showing the feature value of multiple members on Edit member data page. (if the values are same)
	Possibility to use the TAB key to leave text area inputs.
Others:
	Possibility to add/delete users to/from the system.
	Possibility to edit enumeration value id-s.
	Possibility to change the type of a feature.
	Between operator for strings.
	Ignoring empty strings on import.
	Project related info is hidden in the Sample management (not in use any more).
	Correct handling of distribution percents when the selection changes (no deletion).
	Cell based "net N" can be specified and followed.
	Cell based survey status can be followed by DubInterviewer.
	Preset lists can be filtered by creation date.
	Asking "overwrite?" while saving presets when the preset name is in use.
	Turning off the membership status usage clears the whole membership status table.
Fixed problems:
	Fixed: Bad formatted date picker on the new sample screen.
	Fixed: History handling was enabled for link types.
	Fixed: "Add all" remained disabled after choosing a non link type.
	Fixed: No entity type was defined for feature if a link type selected.
	Fixed: Add sample was not working because of a small problem.
	Fixed: The screening compare sp failed when the same feature was used in more screening conditions.
	Fixed: Add sample members failed to handle cell_index field in FValues6.
	Fixed: Password changing erased the username.
	Fixed: Sampling wizard had a special look. (not like the other manager windows).
	Fixed: Changing CAST to CONVERT for proper date handling.
	Fixed: INSERT into history bug in the add_value sp is fixed.