| |
| Date | Build
Number | Change
Type | Description |
| 10/17/2025 | 9421 | Asana | Added
- Added the mirror column TextSearch in the PremiumWorkspaceTasks view to correctly support the text query parameter.
|
| 10/06/2025 | 9410 | General | Added
- ミリ秒とナノ秒に対応する".S" と",S" を使用したdatetime フォーマットのパースに対応しました。
|
| 10/01/2025 | 9405 | JDBC | Added
- 以下のメソッドがcdata.jdbc.asana.AsanaDriver クラスに追加されました。これらのメソッドにエラーレコードを持たない例外を渡すと、InvalidArgumentException がスローされます。
- containsErrorSource：指定されたソース名のエラーレコードが例外に含まれている場合はtrue を返し、それ以外の場合はfalse を返します。
- getErrorCodeFromSource：指定されたソースを持つエラーレコードから数値エラーコードを返します。そのソースからのエラーレコードが存在しない場合は-1 を返します。
- containsErrorCode：指定されたエラーコードを持つエラーレコードが例外に含まれている場合はtrue を返し、それ以外の場合はfalse を返します。
- findErrorProperty：指定された名前を持つプロパティの値を返します。その名前を持つプロパティが定義されていない場合はnull を返します。
- formatErrorRecords：例外のすべてのエラーレコードを含む文字列を返します。各レコードのメッセージ、コード、プロパティ、およびエラー位置を含みます。
|
| 09/12/2025 | 9386 | General | Added
- sys_tables テーブルにIsInsertable、IsUpdateable、IsDeleteable カラムが追加されました。
|
| 09/10/2025 | 9384 | General | Changed
- 静的に定義されたビューのすべてのカラムが読み取り専用としてレポ―トされるようになりました。
|
| 09/03/2025 | 9377 | General | Changed
- 射影部分でIN 条件にNULL 値が使用される際の動作が修正されました。0 ではなくNULL が返されるようになりました。例えば、"NULL IN (1,2)" は"NULL" を返します。
|
| 09/01/2025 | 9375 | General | Added
- CAST 関数で無限値を使用するサポートが追加されました。この関数は"inf" および"-inf" をDOUBLE、FLOAT、またはREAL にキャストできます。
|
| 08/21/2025 | 9364 | General | Changed
- 動作変更：
- 非テーブルクエリにおける文字列値比較の不整合が修正されました。
- 例えば、"SELECT 'A' = 'a'" は以前はfalse を返していましたが、現在はtrue を返します。
|
| 08/14/2025 | 9357 | Asana | Added
- Added the UseTypeaheadSearch connection property to support the Typeahead endpoint for the Projects, ProjectTemplates, Tasks, and Users tables. The default is false.
Changed
- Made the Public column read-only in the Projects table.
|
| 08/13/2025 | 9356 | General | Changed
- ヒープ使用量を削減するため、ページプロバイダーでメモリに保持される最大ページ数が15から5に変更されました。
|
| 07/31/2025 | 9343 | Asana | Added
- Added the Scope input parameter to the GetOAuthAccessToken and GetOAuthAuthorizationURL stored procedures.
- Added the RecurrenceType and RecurrenceData columns to the Tasks table.
|
| 07/25/2025 | 9337 | Asana | Added
- Added the Workspaces aggregate column to the Users table.
|
| 07/24/2025 | 9336 | Asana | Added
- Added the PremiumWorkspaceTasks view.
|
| 07/22/2025 | 9334 | Asana | Changed
- Made the Archived column filterable in the Projects table.
- Made the CreatedAt column filterable in the StatusUpdates table.
|
| 07/11/2025 | 9323 | Asana | Added
- Added support for the Scope connection property.
|
| 06/28/2025 | 9310 | Asana | Changed
- Changed data type for TemplateDueTime column from string type to time type in the TaskTemplates table.
Added
- Added the AccessLevel column to the PortfolioMembership table.
- Added the DefaultAccessLevel and Archived columns to the Portfolios table.
- Added the Endorsed column to the Teams table.
- Added the IsViewOnly column to the WorkspaceMembership table.
Changed
- Changed the name of column UserId to MemberId in ProjectMembership table.
|
| 06/25/2025 | 9307 | General | Removed
- ConnectionType プロパティから"ADLS Gen 1" の値が削除されました。
|
| 06/20/2025 | 9302 | General | Added
- 以下の関数が作成されました：
- TEXT_ENCODE：文字列を異なる文字セットにエンコードします（UTF8 → UTF7）。結果としてバイナリ配列を返します。
- TEXT_DECODE：バイナリ配列を受け取り、文字セットが指定された場合に文字列にデコードして戻します。
- BASE64_ENCODE：バイナリ配列を受け取り、base64 文字列（varchar）としてエンコードします。
- BASE64_DECODE：base64 エンコードされた文字列を受け取り、バイナリ配列にデコードします。
|
| 06/20/2025 | 9302 | Asana | Removed
- Removed the TextValue and NumberValue columns from the CustomFields table.
- Removed the IsTemplate, Layout, and SectionMigrationStatus columns from the Projects table.
|
| 06/18/2025 | 9300 | General | Changed
- 例外処理の内部コードがリファクタリングされました。特定のエラー条件で返される例外メッセージの表現や書式が変更されている場合があります。
|
| 06/06/2025 | 9288 | Asana | Added
- Added the ProjectId and PortfolioId pseudocolumns to the Goals table.
|
| 05/27/2025 | 9278 | General | Removed
- ProxyAuthscheme から"Proprietary" 列挙オプションが削除されました。
|
| 02/15/2025 | 9177 | General | Added
- 符号なし整数型（unsigned integer type）を、その符号なしの値を保持するのに十分な精度を持つ最も近い符号付きデータ型に変換するサポートが追加されました。これは、JDBC が符号なしデータ型をサポートしていないため、JDBC に対してのみ行われます。
|
| 01/31/2025 | 9162 | Asana | Added
- Added the AuthScheme connection property with OAuthPKCE support.
|
| 12/31/2024 | 9131 | Asana | Added
- Added the Allocations and TaskTemplates tables.
- Added the TaskDependencies, TaskDependents, and TimePeriods views.
- Added the InstantiateTaskFromTemplate stored procedure.
|
| 11/27/2024 | 9097 | General | Added
- LogModule の出力にThreadId が追加されました。Logfile の行には、実行中のアクションに関連するThread ID が含まれるようになりました。
|
| 11/11/2024 | 9081 | Asana | Added
- Added the ResourceType column to the Tags table.
- Added the CreatedAt column to the WorkspaceMembership table.
- Added the RequestedRoles column to the ProjectTemplates view.
- Added the ResourceSubtype column to the ProjectMembership table.
- Added the IsLimitedAccess and IsAdmin columns to the TeamMembership table.
- Added the CreatedById and CreatedByResourceType columns to the Tasks table.
- Added the OrganizationResourceType and OrganizationName columns to the Teams table.
- Added the following columns to the Attachments table: ResourceSubtype, PermanentURL, Size, and ConnectedToApp.
- Added the following columns to the Events view: ChangeField, ChangeAction, ChangeNewValue, and ChangeRemovedValue.
- Added the following columns to the SubTasks table: CreatedById, CreatedByResourceType, NumSubTasks, StartAt, ActualTimeMinutes, and AssigneeSection.
- Added the following columns to the Portfolios table: CurrentStatusUpdateId, CurrentStatusUpdateResourceType, CurrentStatusUpdateTitle, CurrentStatusUpdateResourceSubtype, StartOn, Public, and ProjectTemplates.
- Added the following columns to the Projects table: CurrentStatusUpdateId, CurrentStatusUpdateResourceType, CurrentStatusUpdateTitle, CurrentStatusUpdateResourceSubtype, ResourceType, DefaultAccessLevel, MinimumAccessLevelForCustomization, MinimumAccessLevelForSharing, Completed, CompletedAt, CompletedById, CompletedByResourceType, CompletedByName, Icon, ProjectBriefId, ProjectBriefResourceType, CreatedFromTemplateId, CreatedFromTemplateResourceType, and CreatedFromTemplateName.
- Added the following columns to the Stories table: StickerName, Type, Previews, OldName, NewName, OldDatesStartOn, OldDatesDueAt, OldDatesDueOn, NewDatesStartOn, NewDatesDueAt, NewDatesDueOn, OldResourceSubtype, NewResourceSubtype, StoryId, StoryResourceType, StoryCreatedAt, StoryCreatedById, StoryCreatedByResourceType, StoryCreatedByName, StoryResourceSubtype, StoryText, AssigneeId, AssigneeResourceType, AssigneeName, FollowerId, FollowerResourceType, FollowerName, OldSectionId, OldSectionResourceType, OldSectionName, NewSectionId, NewSectionResourceType, NewSectionName, StoryTaskId, StoryTaskResourceType, StoryTaskName, TaskResourceSubtype, TaskCreatedById, TaskCreatedByResourceType, ProjectId, ProjectResourceType, ProjectName, TagId, TagResourceType, TagName, CustomField, OldTextValue, NewTextValue, OldNumberValue, NewNumberValue, OldEnumValue, NewEnumValue, OldDateValue, NewDateValue, OldPeopleValue, NewPeopleValue, OldMultiEnumValues, NewMultiEnumValues, NewApprovalStatus, OldApprovalStatus, and DuplicateOf.
|
| 10/02/2024 | 9041 | Asana | Added
- Added 8 columns to the Teams table: Visibility, TeamContentManagementAccessLevel, EditTeamNameOrDescriptionAccessLevel, EditTeamVisibilityOrTrashTeamAccessLevel, MemberInviteManagementAccessLevel, GuestInviteManagementAccessLevel, JoinRequestManagementAccessLevel, and TeamMemberRemovalAccessLevel.
|
| 09/28/2024 | 9037 | Asana | Added
- Added the ItemURL column to the Workspaces table.
|
| 09/18/2024 | 9027 | Asana | Added
- Added the ItemURL column to the Projects, Portfolios, and Teams tables.
|
| 07/02/2024 | 8949 | Asana | Added
- Added StatusUpdates table.
- Added PrivacySetting column to the Project table.
|
| 05/21/2024 | 8907 | Asana | Added
- Added CurrentStatusUpdateId, CurrentStatusUpdateResourcesSubtype, CurrentStatusUpdateResourceType, and CurrentStatusUpdateResourceTitle columns in the Goals table.
Removed
- Removed the CurrentUpdateStatus column from the Goals table.
|
| 05/09/2024 | 8895 | General | Changed
- 以前はROUND 関数は負の値を受け取りませんでした。その機能は復元されました。
|
| 03/15/2024 | 8840 | General | Added
- Java のString.compare() 機能をSQL クエリに提供するSTRING_COMPARE という新しいSQL 関数が作成されました。2つの文字列の比較値を表す数値を返します。
|
| 02/27/2024 | 8823 | Asana | Changed
- Added the WorkspaceId as a composite key in the Users view to create a unique combination for retrieving values from different workspaces.
|
| 12/12/2023 | 8746 | Asana | Changed
- Changed the key column from ProjectId to Id in PortfolioItems table.
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/28/2023 | 8732 | General | Added
- Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 10/27/2023 | 8700 | JDBC | Changed
- Added support for Connection.abort() method.
|
| 09/11/2023 | 8654 | Asana | Added
- Added Goals and GoalMembership tables.
- Added VacationStartDate and VacationEndDate columns in WorkspaceMembership table.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 08/18/2022 | 8265 | Asana | Added
- Added support for bulk insert, update, and delete operations.
Modified
- Modified metadata for custom date fields to report data type as date
- Modified metadata for numeric fields to report data type as long when precision is zero.
|
| 07/07/2022 | 8223 | Asana | Added
- Added IsImportant, Format, TextValue, NumberValue, Precision, CurrencyCode, EnumOptions, CreatedBy, CreatedByName, IsGlobaltoWorkspace and HasNotificationsEnabled columns to CustomFields view.
|
| 06/13/2022 | 8199 | Asana | Added
- Added FileData output attribute and Encoding input attribute to print the response in the DownloadAttachment Stored procedure.
- Added Content and Name input attribute to add stream input in the UploadAttachment stored procedure.
|
| 06/11/2022 | 8197 | JDBC | Changed
- The method GetJDBCMinorVersion() and GetJDBCMajorVersion() return 4.2 as the supported JDBC major / minor version.
|
| 05/16/2022 | 8171 | Asana | Added
- Added Embedded OAuth support to the Driver.
|
| 04/28/2022 | 8153 | JDBC | Changed
- Removed support for JRE 1.6. JRE 1.8 and above is now required.
|
| 04/18/2022 | 8143 | Asana | Added
- Added ProjectTemplates view
|
| 02/25/2022 | 8091 | JDBC | Changed
- The method DatabaseMetaData.getTypeInfo() now returns all of the data types that the driver supports. Previously, it was returning only a portion of the data types. The types include: tinyint, smallint, int, bigint, float, double, numeric, decimal, bit, date, datetime, time, varchar, binary, uuid.
|
| 02/24/2022 | 8090 | JDBC | Changed
- Corrected the return value of method DatabaseMetaData.supportsOuterJoins(), which used to return an incorrect value.
|
| 10/27/2021 | 7970 | JDBC | Changed
|
| 09/12/2021 | 7925 | JDBC | Removed
- Removed the IS_READONLY, IS_KEY, NUMERIC_PRECISION, and DECIMAL_DIGITS columns from DatabaseMetadata.GetColumns(), as they are not part of the JDBC Specification. This information is still available via other metadata calls.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/23/2021 | 7874 | General | Changed
- Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 04/25/2021 | 7785 | General | Added
- Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|
| 04/16/2021 | 7776 | General | Changed
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|