ODataDB Change History

ODataDB Change History

Version 3.8, August 21, 2020

New features:

  • ODataDB allows using fields of tables and views as WHERE filters.
    To create a field parameter, check the field in the field setup dialog box.
  • ODataDB creates functions for handlers that select data from tables and views and have specified columns in the HANDLER_CODE.
    For example, if the handler selects values from the s02.companies table and has a value like "id,+name",
    ODataDB creates the s02_companies_select_id_name_order_by_name function that select id and name and sorts data by name.
    For the value like "id,+name,@item_id", ODataDB creates a function like s02_companies_select_id_name_where_item_id_order_by_name.
  • ODataDB supports the DoNotChange handler at the object and column levels.
    You can use it to make columns read-only.
  • ODataDB allows using the calendar dialog box for date parameters.
  • ODataDB allows stopping the application using the /v4/$stop request.
    You can use this feature when embedding ODataDB to single-user applications or for development purposes.
    To enable it, set the StopEnabled option in the application settings to true.

Improvements:

  • ODataDB supports the odata.include-annotations=* and odata.include-annotations=-* options of the Prefer header.
    Also, ODataDB has a new IncludeAnnotations configuration option that allows defining the default option of including annotations to the metadata.
  • ODataDB supports the odata.metadata=none option of the Accept header.
  • ODataDB hides columns of unsupported data types in metadata and does not select such columns.
  • ODataDB marks function result types with the OpenType attribute.
  • ODataDB replaces dots and dashes in database object names with _x002E_ and _x002D_ to avoid issues with URLs and parameters.
  • Metadata contains ODataDB.DisplayName values in the Annotation nodes with PropertyPath attributes.

Bug fixes:

  • Microsoft PowerQuery cannot load ODataDB feeds due to metadata errors.
    Note that PowerPivot cannot load JSON feeds anyway. Use PowerQuery to load data.
  • ODataDB metadata contains the Annotations nodes in the EntityType nodes that do not follow the standard.
    Such nodes are moved to the Schema node.
  • ODataDB metadata uses the wrong Boolean words in several nodes instead of the correct Bool.
  • ODataDB returns DateTimeOffset values for Date type columns in JSON feeds.
  • ODataDB does not return the content type for metadata and service documents.
  • ODataDB does not generate the ROWNUM pseudo-primary key column for views in MySQL, Oracle, and DB2.
  • ODataDB has issues with schemas in SQLite.
  • ODataDB has broken the @odata.context value for URLs that include cultures.
  • The odatadb-control CSS has an issue with overflow.

Version 3.7, August 5, 2020

Bug fixes:

  • ODataDB does not return the entity when the return=representation header specified.
  • ODataDB raises "Object reference not set to an instance of an object" on executing MySQL procedures.

Version 3.6, July 31, 2020

Bug fixes:

  • A browser cannot open a page on IIS and shows the ERR_SSL_PROTOCOL_ERROR error.
  • The client returns "Incorrect syntax near ')'" on saving changes.
  • The server does not save changes of data from stored procedures to base tables.

Version 3.5, July 27, 2020

Improvements:

  • ODataDB allows testing samples in a free version.

Version 3.4, July 24, 2020

Improvements:

  • Improved CSS and JavaScript files
  • Improved pages of samples

Bug fixes:

  • ODataDB resets the selection on the right mouse button click and breaks the range copy/paste feature.
  • ODataDB does not send the application/json ContentType header in several cases.
  • ODataDB ignores the document base URL in API roots.

Version 3.3, July 22, 2020

New features:

  • ODataDB supports copy/paste and cell range operations.
  • ODataDB supports dynamic parameter values and drop-down value lists.
    For example, if a procedure has a parameter like @company_id, ODataDB executes it to reload values when a user changes the company.
  • ODataDB supports filtered drop-down value values.
    For example, if a value list has three columns like id, name, and item_id, ODataDB filters values using the cell value in the item_id column.
  • ODataDB supports JSON forms that return parameter values, column and row headers, and table cells in one JSON result.
    See the new "Sample 20 - Cube App" for details.
  • ODataDB supports the non-OData standard /$definition operation to returns the object SQL definition.
    It returns the definition only if a user has the VIEW DEFINITION permission in a database.
    You can find a code browser sample in the ODataDB samples.
  • The connection string section allows defining a default query list in the "QueryList" parameter.
    Use this feature to configure the entity container and keep the service root clear.
  • The DefaultValue handler allows setting default values of parameters in the HANDLER_CODE field.
  • The DoNotSort handler allows disabling the translation for the specified column or the entire table.
  • The DoNotTranslate handler allows disabling the translation for the specified column or the entire table.
  • The following handlers allow specifying data types of columns and parameters on unknown types:
    DataTypeBit, DataTypeBoolean, DataTypeDate, DataTypeDateTime, DataTypeDateTimeOffset,
    DataTypeDouble, DataTypeInt, DataTypeGuid, DataTypeString, and DataTypeTime.
    Use these handlers, for example, to specify data types of SQL code parameters or stored procedure columns.
  • ODataDB supports database schemas in the endpoints.
    For example, /edit/mssql/xls27/ returns the objects of the xls27 schema with database names
    while /edit/mssql/xls27/en-GB/ returns the objects with translated names and the en-GB culture.

Improvements:

  • ODataDB includes a new set of pages with complete descriptions of ODataDB samples.
  • ODataDB JavaScript client includes a lot of improvements.
    It has the same look in Chrome, Firefox, Opera, Safari, IE, and Edge.
    It has new classes and element ids to style ODataDB elements.
  • ODataDB data service always creates derived EntityTypes for results of stored procedures adding the _result suffix.
    For example, if a dbo.usp_cashbook procedure has the code like SELECT * FROM dbo.cashbook, ODataDB creates the usp_cashbook_result EntityType with the cashbook base type.
    This change makes the model consistent with all types of procedures.
  • ODataDB data service includes improvements in detecting and creating navigation properties.
  • ODataDB keeps parameter values with the same name but changed ids.
    For example, the Budget item can have different ids for different companies.
    When a user changes the company_id, ODataDB keeps the Budget item as a parameter.

Bug fixes:

  • ODataDB allows saving changes for objects that have the merge operations only (not supported in ODataDB).
  • ODataDB does not translate checkbox parameter names.

Version 3.2, May 15, 2020

Improvements:

  • ODataDB migrated to ASP.NET Core 3.1.
  • ODataDB supports installing as a Windows service.
    Use install-odatadb-service.cmd to install it.
  • The JavaScript client has several minor improvements.

Bug fixes:

  • Fixed bug with a connection using SQLite ODBC drivers

Version 3.1, February 28, 2020

New features:

  • The JavaScript client supports conditional formatting specified with the Format handlers in the xls.handlers table.
  • The JavaScript client uses xls.formats table formats to hide hidden columns loaded for the first time.
  • The JavaScript client allows sorting columns.
  • The data service supports the /$table_format suffix and returns table formats defined with the Format handlers in the xls.handlers table.
  • The data service supports the /$excel_format suffix and returns Excel table formats defined in the xls.formats table saved using the SaveToDB add-in.

Improvements:

  • The JavaScript client shows parameters of the bit and boolean datatypes as three-state checkboxes.

Version 3.0, December 12, 2019

New features:

  • ODataDB is an ASP.NET Core 3.0 application.
  • ODataDB includes a JavaScript client that allows viewing and editing data.
  • ODataDB supports Windows, Linux, and Mac OS.
  • ODataDB supports views and stored procedures.
  • ODataDB supports SaveToDB Framework.
  • ODataDB includes a new command-line product activation tool.

Removed Features:

  • Support of OData-Atom
  • Support of OData 1.0-3.0
  • Support of Microsoft SQL Server Compact