Another exciting release full of improvements that make it easier to work with content, expand retention options, improve storage efficiency, and enhance the APIs.

Grid View Improvements

• Editing - It is now possible to edit content items directly from Grid View, making it easier to work on multiple items at once, without the need to open each item individually.
• Formatting - Data formats are improved to show check marks, formatted dates, images, references and more.
• Column Widths - Automatic column widths are improved to improve readability and access.
• Footer Aggregates - Columns can be configured to display the sum, min, max, avg where appropriate.

Improved Storage Efficiency & Retention Settings

Building on improvements in the previous release, content item updates are now stored more efficiently.  Only the individual content items that are changed are stored with the version, dramatically reducing storage required to maintain past versions when content has many embedded items.

Content Log Settings have been merged into Version Settings with improved options:

• Versions - Retain past content items up to a specific number of versions and/or for a specific duration of time.
• Content Logs - Retain content logs up to a specific number of versions and/or for a specific duration of time.
• Deleted Content - Retain deleted content items for a specific amount of time, including the option to purge immediately.

API Improvements

• More Metadata - The cQuery META() and .META() functions, and cObject::meta() method have many new options to access much more metadata about each object, including embedded objects, the greater-object and top-level object information.
• Object Locking - Added object-level locking, unlocking and validation to cObject class, making it available to application logic.

Query Engine Improvements

• Performance - Query performance has been improved for many types of queries, including when accessing and selecting content metadata.
• Attributes - Attribute queries for unauthorized fields now return NULL attributes instead of no result.

Additional Updates

• Content Search - Properly search for cPath reserved keywords such as "WORKFLOW" and "AS OF" when not part of a cPath expression.
• Content Type Fields - New options to control the default view and Grid View footer aggregation per field.
• Pending Approvals - Improved performance of Pending Approvals view within the Users App, and resolved issue with toolbar options on refresh.
• Form View - Improve initial load performance by only populating the visible sidebar, and loading others on-demand.  Fix issue so that the workflow menu is activated when items are deleted from an embedded list.  Optimize Save/Approve to only return new Metadata/Versions sidebar information if the sidebars are visible.
• Related Sidebar - Now includes 3 stages to reveal (1) related content types, (2) specific fields within the content types (when more than one) and (3) specific items of the content type related through the field.  This provides more specific results and improves performance.  New export and open view in full browser options added.
• Unique Fields - Fix issue that allowed new objects to violate uniqueness constraints when assigned a UUID value.
• File Fields - File fields now detect Personal Information Exchange (PFX) certificate files, also known as PKCS #12 archive files.
• Socket Server - View listeners and dynamic updates to the UI are lighter weight and more responsive.
• Pull Settings - Introduce a new 'pull' CLI tool for the import package that invokes existing Pull Settings.  Fix to exclude importing a content type field definition that is itself excluded.
• Import - Fix imports to be performed as the user invoking the action in the UI.
• Restore - Update the content item restore process to properly delete embedded objects of content that was never approved.
• Backups - Add command-line interface tool for adding backups to S3 storage.
• cPath - Apply workflow query elements globally, and recognize workflow and revision clauses with internal clause cQL.  Fix issue where selected variants of related objects through a non-variant field were not preferring the variants of their parent object.
• cScript - Parser now recognizes variable names with more than two numbers at the end (i.e. $Var123)
• Login Security Logs - New default Login Policy clean up rules to remove past Login Security Logs.
• Web Service Activity Logs - Add EndTime field for Web Service Activity Logs for tracking service duration.
• Optimize Repository - The Optimize Repository Scheduled Task can now be configured to skip certain tables.
• Diagnose Repository - Many new repository database integrity checks added, including ensuring top parent records include deleted embedded content.  Virtually eliminate locking of tables with FULLTEXT index (keywords table).  Also provide more information to help troubleshoot reported issues.