IBM Support

Time data in the ClearQuest Web DATETIME fields is saved in the same format as the time data in the ClearQuest for Windows and the ClearQuest Client applications.

Fix Readme


Abstract

In ClearQuest , version 7.1.1. a behavior change caused the time portion of a date-only DATETIME field to be stored using a different method than the method used in the ClearQuest for Windows and ClearQuest Client applications. This new behavior caused inconsistencies in queries defined with the associated DATETIME fields which generated APAR:PM46057. This problem has been fixed in ClearQuest versions 7.1.1.8, 7.1.2.5, and 8.0.0.1

Content

In ClearQuest Web 7.1.1, a behavior change was introduced where the time portion of a date-only DATETIME field was stored in the database as the system's current local time. Prior to ClearQuest 7.1.1, the time portion was stored as midnight (00:00:00 /12:00 AM) when selecting the date from the calendar control.

This behavior change caused the ClearQuest Web client to store different DATETIME values than the ClearQuest Client and the ClearQuest for Windows client. The different storage methods caused inconsistencies in queries defined with the associated DATETIME fields.

In ClearQuest Web 7.1.1.8, 7.1.2.5, and 8.0.0.1, the ClearQuest Web client application was updated torestore the pre- CQ Web 7.1.1 behavior so the time portion of a DATETIME field with a date-only form element is stored in the database as midnight (00:00:00 / 12:00 AM) in the user's current system timezone. This update fixes APAR:PM46057 and means that the DATETIME data is stored in the same format in the ClearQuest Clients: ClearQuest for Windows, ClearQuest for Web, and the ClearQuest Client.

Note: This new behavior does not affect any values that were stored prior to this change, in ClearQuest Web client versions between 7.1.1 and versions 7.1.1.8, 7.1.2.5, and 8.0.0.1.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Web Client (7.1)","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1.1.7;7.1.2.4;8.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21572056