menu_banner (2K)

Amendment History

00.001.000 June 2003
Software converted from a previous language, documentation rewritten accordingly.
01.000.000 September 2004
Initial public release. This also includes documentation on Audit Logging and the Workflow Engine.
01.000.001 November 2004
  1. Added field settings to the TASK table.
01.000.002 December 2004
  1. Amended Directory Structure to identify the different locations for standard and custom versions of CSS and XSL files.
  2. Removed the AFTER_SUBMIT field from PATTERN and TASK tables.
01.000.003 March 2005
  1. Amended Directory Structure to include a separate CLASSES subdirectory for all database table classes.
01.000.004 April 2005
  1. Amended Appendix H to include a reference to the 'new session' link on the menu bar which will generate a new session on the server for a cloned instance on the client.
01.001.000 June 2005
  1. Added Appendix N to include references to the Data Dictionary.
  2. Amended Directory Structure to include a reference to the DEFAULT and DICT subdirectories.
01.002.000 July 2005
  1. Added Appendix O to document how this application has been modified to deal with the issue of internationalisation (I18N).
  2. Amended Directory Structure to include a reference to the new TEXT directory and the language subdirectories (used for internationalisation).
  3. Amended Update Menu Control data to include DEFAULT-LANGUAGE (used for internationalisation).
  4. Added task Export Subsystem which will export data from the MENU database into a series of text files so that they can be used for internationalisation.
01.003.000 December 2005
  1. Amended Export Subsystem which will now produce an SQL file so that all the data for a selected subsystem can be exported. This will allow the same data to be imported into another database.
  2. Added Erase Subsystem which will erase all data for the selected subsystem from the menu database. These details may be recovered using the file created by the export process.
  3. Added Export Database which will produce an SQL file so that all the data for a selected application database can be exported. This will allow the same data to be imported into another data dictionary.
  4. Added Erase Database which will erase all data for the selected application database from the data dictionary. These details may be recovered using the file created by the export process.
  5. Amended the Menu Bar area to include a 'print' option which will redisplay the current page without any buttons. This enables the basic data to be printed via the browser's own print facility.
01.004.000 February 2006
  1. Amended Update Task to include new fields LOG_SQL_QUERY and SCREEN_REFRESH.
  2. Amended Update Column to include a new field NO_AUDIT.
  3. Added List ToDo and associated family of tasks to maintain the contents of the TODO table.
01.005.000 10th March 2006
  1. Amended the menu bar to include the identity of current user.
  2. Amended Update User to include new fields START_DATE, END_DATE, IP_ADDRESS and EMAIL_ADDR.
  3. Amended Update Subsystem to include a new field TASK_PREFIX.
  4. Amended Update Menu Control data to include a new PASSWORD_WARNING field.
  5. Amended Appendix L - Audit Logging to include a new screen List Logon Errors.
  6. Amended Update Task to include new field USE_HTTPS.
01.006.000 28th March 2006
  1. Amended the database model by renaming DIALOG_TYPE to PATTERN.
  2. Amended all screens and tasks to reflect this name change.
01.007.000 7th April 2006
  1. Amended Appendix M by adding Update Workflow Workitem.
  2. Added task Update Session data.
  3. Amended Menu/Home Page to include reference to task Update Session data.
01.008.000 15th April 2006
  1. Amended Menu Bar to include a "logout (all)" option.
01.009.000 21st April 2006
  1. Amended Update Menu Control data to include the specification of shutdown periods during which time the system will not be available. This is to allow database backups (or any other maintenance) to be performed.
01.010.000 30th April 2006
  1. Amended Logon screen to include a hyperlink to request a forgotten password.
  2. Added Retrieve Password screen which will e-mail the user with a forgotten password.
  3. Amended Update Column to allow "checkbox" as a control type, to allow an optional label for each checkbox, and to position the text for radio groups and checkboxes either to the left or the right of the control.
01.011.000 15th May 2006
  1. Amended Update Column to allow "hyperlink" as a control type.
01.012.000 17th June 2006
  1. Amended Directory Structure to include a single CSS directory to hold a collection of CSS files, thus making radicore/style_default.css redundant. Individual image subdirectories have been merged into a single radicore/images directory.
  2. Amended Update Session to allow the user to change the appearance of all web pages in the application by selecting one of the available theme/style (CSS) files.
01.013.000 22nd June 2006
  1. Amended Import Database so that it will ask the user to choose a database to import instead of automatically importing all available databases which do not currently exist in the Data Dictionary.
01.014.000 9th July 2006
  1. Amended Add Workflow Transition and Update Workflow Transition so that ROLE_ID is optional. If this is left empty then when the corresponding workitem entry is created the role_id of the current user will be used instead.
01.015.000 14th July 2006
  1. Amended Search Audit Detail so that the use of the FROM date/time and TO date/time fields is more logical.
01.016.000 18th July 2006
  1. Amended Update Menu Control data to include an option to keep existing user passwords hidden on all screens.
01.017.000 3rd August 2006
  1. Amended Update Column to include an option for Dropdown lists which allow multiple selections.
01.018.000 28th August 2006
  1. Amended Directory Structure to include a REPORTS subdirectory for all report structure files.
01.019.000 3rd September 2006
  1. Amended List Pattern, List Subsystem, List Task (all), List Task (proc), List Task (menu), List Role and List User to include options for producing PDF reports.
  2. Amended List Databases, List Tables, List Relationships and List Columns to include options for producing PDF reports.
01.020.000 9th September 2006
  1. Amended Update Column to include a CUSTOM_VALIDATION field.
01.021.000 15th October 2006
  1. Added Build Directory to list of available tasks.
  2. Amended Appendix N: Data Dictionary to include new functions:
01.022.000 5th December 2006
  1. Amended Update Column to allow the AUTO-UPDATE option to be used on fields of type INTEGER. This can be used in the option to prevent simultaneous updates.
01.023.000 3rd March 2007
  1. Amended Generate PHP scripts (b) to allow the list of table names for the Outer table to be obtained from a database which is different from that of the Inner table. This defaults to the current database, but can be changed by pressing the popup button.
01.024.000 1st May 2007
  1. Amended Update Column to allow a new multi-checkbox control which can be used instead of a multi-dropdown.
01.025.000 28th May 2007
  1. Added the INITIAL-VALUE-ROLE table to the MENU database.
  2. Added Maintain Initial Values (Role) via Task and Maintain Initial Values via Role.
  3. Added the INITIAL-VALUE-USER table to the MENU database.
  4. Added Maintain Initial Values (User) via Task and Maintain Initial Values via User.
01.026.000 30th June 2007
  1. Added Generate SQL to the navigation bar of List Audit details.
01.027.000 20th August 2007
  1. Updated Appendix M: Workflow Engine to include new tasks List Expired Workitems and Trigger Expired Workitem.
  2. Added tasks List Navigation Button Parents and List Menu Parents.
01.028.000 Skipped in order to keep the software and documentation versions in step.
01.029.000 1st October 2007
  1. Added the ACCOUNT table to the MENU database to implement the feature described in Appendix P.
  2. Added a new group of tasks to maintain the ACCOUNT table.
  3. Updated Add User, Delete User, Enquire User, Search User and Update User to deal with the new rdcaccount_id column.
01.030.000
01.031.000
01.032.000
Skipped in order to keep the software and documentation versions in step.
01.033.000 1st February 2008
  1. Added the LANGUAGE table to the MENU database to hold details of all languages which are supported.
  2. Added a new group of tasks to maintain the LANGUAGE table.
  3. Updated Appendix O: Internationalisation.
  4. Added Appendix Q: Radius Authentication.
  5. Added is_noedit column to Maintain Initial Values (Role) via Task, Maintain Initial Values via Role, Maintain Initial Values (User) via Task, and Maintain Initial Values via User.
  6. Amended the settings field in Appendix D: Task Parameters.
01.034.000 1st March 2008
  1. Amended Appendix I: Passing context between objects.
  2. Added column party_id to the USER table.
  3. Added column field_desc to the TASK-FIELD table.
01.035.000
01.036.000
01.037.000
01.038.000
01.039.000
Skipped in order to keep the software and documentation versions in step.
01.040.000 1st October 2008
  1. Amended Menu Control Data to allow an additional option for external authentication.
  2. Amended Appendix Q: RADIUS Authentication.
  3. Added Appendix R: LDAP Authentication.
  4. Amended the USER table to change radius_auth to external_auth.
  5. Amended the ROLE table to change radius_auth to external_auth.
  6. Added column max_execution_time to the TASK table.
01.041.000 1st November 2008
  1. Amended Menu Control Data to allow logon using email address instead of user_id.
  2. Amended Menu Control Data to allow the display of the pagination and scrolling areas to be configurable.
  3. Amended Update Column to add the STRIP TRAILING ZERO option for numeric columns.
01.042.000 1st December 2008
  1. Amended Directory Structure to include a LOGS directory.
  2. Added Show Batch Log File to show the contents of the LOGS directory.
01.043.000
01.044.000
01.045.000
Skipped in order to keep the software and documentation versions in step.
01.046.000 1st April 2009
  1. Amended Update Table to include alias names for START_DATE and END_DATE columns.
01.047.000 Skipped in order to keep the software and documentation versions in step.
01.048.000 1st June 2009
  1. Added List MOTD and associated family of tasks to maintain the contents of the MOTD table.
01.049.000 1st July 2009
  1. Modified the USER table to include a time zone.
01.050.000
01.051.000
01.052.000
01.053.000
Skipped in order to keep the software and documentation versions in step.
01.054.000 1st December 2009
  1. Added the TASK-IP-ADDRESS table and associated maintenance tasks.
  2. Added the USER-IP-ADDRESS table and associated maintenance tasks.
01.055.000
01.056.000
01.057.000
01.058.000
Skipped in order to keep the software and documentation versions in step.
01.059.000 1st May 2010
  1. Modified Update Workfow Transition to allow time_limit to be specified in hours and minutes instead of just hours.
  2. Modified Update Column to allow control to be set to 'image'.
01.060.000
01.061.000
Skipped in order to keep the software and documentation versions in step.
01.062.000 1st August 2010
  1. Modified Update Task to add the run_at_end and run_at_cancel columns.
  2. Modified Appendix D: Task Parameters.
  3. Added the FAVOURITES table and associated maintenance tasks.
01.063.000
01.064.000
01.065.000
01.066.000
01.067.000
Skipped in order to keep the software and documentation versions in step.
01.068.000 1st June 2011
  1. Added the QuickSearch area to the Title Bar.
01.069.000
01.070.000
01.071.000
01.072.000
01.073.000
01.074.000
01.075.000
01.076.000
Skipped in order to keep the software and documentation versions in step.
01.077.000 1st January 2013
  1. Added the HELP_TEXT_ALT table and associated maintenance tasks.
  2. Amended the Online Help facility to obtain help text from the database instead of from text files.
  3. Amended the Directory Structure to make the HELP directories redundant.
  4. Amended the Export Subsystem function so that it no longer writes to the <subsys_dir>/help/<default_language>/ directory.
  5. Added the TASK_ALT table and associated maintenance tasks.
01.078.000 Skipped in order to keep the software and documentation versions in step.
01.079.000 22nd June 2013
  1. Added the TIME_LIMIT_ROLE table and associated maintenance tasks.
  2. Added the TIME_LIMIT_USER table and associated maintenance tasks.
  3. Amended the Online Help facility to move the help_header.txt and help_footer.txt files to the <subsystem>/text/<language>/ directory.
01.080.000 3rd September 2013
  1. Amended the Directory Structure to include a new error_logs directory to hold log files and error dumps.
01.081.000 1st December 2013
  1. Amended the Update Relationship task to include a relationship type of 'IGNORE'.
  2. Amended the Update Relationship task to allow the ability to link to a candidate key on the parent/senior table instead of only the primary key.
01.082.000 Skipped in order to keep the software and documentation versions in step.
01.083.000 1st May 2014
  1. Amended the MNU_LANGUAGE table to include the input_date_format and output_date_format columns.
  2. Added the USER-ROLE table which allows a USER to have more than one ROLE.
  3. Added the USER-ALT table which allows a USER to have different names in different LANGUAGEs.
01.084.000 1st June 2014
  1. Amended the MNU_LANGUAGE table to increase the number of options on the input_date_format and output_date_format columns.
01.085.000
01.086.000
01.087.000
01.088.000
Skipped in order to keep the software and documentation versions in step.
01.089.000 1st May 2015
  1. Amended Update Workflow Arc to replace the single pre_condition column with condition_field, condition_operator and condition_value.
01.090.000
01.091.000
Skipped in order to keep the software and documentation versions in step.
01.092.000 12th December 2015
  1. Added the SAVED-SELECTION table which allows selections for an OUTPUT 4 pattern to be saved and restored.
01.093.000
01.094.000
Skipped in order to keep the software and documentation versions in step.
01.095.000 1st June 2016
  1. Amended the TASK-FIELD table to include the is_documentation_only column.
  2. Added the TASK-QUICKSEARCH table to replace the need for program code.
01.096.000
01.097.000
02.000.000
02.001.000
02.002.000
Skipped in order to keep the software and documentation versions in step.
02.003.000 2nd April 2017
  1. Amended the MNU_USER table to include the force_pswd_chg column.
  2. Amended the Control Data screen to include the Force Change? switch.
02.004.000 1st June 2017
  1. Amended the DICT_DATABASE table to rename columns to database_name and database_desc.
  2. Amended the DICT_TABLE table to rename columns to table_name and table_desc.
  3. Amended the DICT_COLUMN table to rename columns to column_name and column_desc.
  4. Amended the DICT_RELATIONSHIP table to rename columns to relation_name and relation_desc.
  5. Amended the MNU_ACCOUNT table to add account_desc column.
  6. Amended the MNU_FAVOURITE table to rename column task_desc to task_name.
  7. Amended the MNU_PATTERN table to rename columns to pattern_name and pattern_desc.
  8. Amended the MNU_ROLE table to rename columns to role_name and role_desc.
  9. Amended the MNU_SAVED_SELECTION table to rename column selection_desc to selection_name.
  10. Amended the MNU_SUBSYSTEM table to rename columns to subsys_name and subsys_desc.
  11. Amended the MNU_TASK table to rename columns to task_name and task_desc.
  12. Amended the MNU_TODO table to rename columns to item_name and item_desc.
  13. Amended the MNU_USER table to combine columns pswd_chg_date and pswd_chg_time into a single pswd_change_datetime column, and logon_date and logon_time into a single logon_datetime column.
02.005.000 3rd August 2017
  1. Amended Update User Role table to include start_date and end_date.

http://www.tonymarston.net
http://www.radicore.org