The SQL IS NULL and IS NOT NULL operators are supported in read, update and delete requests on any columns in query parameters (row selectors). Null is also supported in form parameters in POST with form (URL Encoded) and PUT by Query methods to set a column value to null in an insert or update.
Null column values in selected rows will continue to be absent in response XML and will no longer be present in response JSON. Previous versions returned the attribute with the value null in the JSON format. The new approach is more streamlined.
See Null/Not Null Operators for more detail.
This addresses GitHub Issue #69.
Greater than, greater than or equal to, less than and less than or equal to are now supported in update and delete parameters in addition to reads. See Comparison Operators for more detail.
The SQL IN is now supported in update and delete parameters in addition to reads. See In Operator for more detail.
All columns may be queried by not equals value expression. See Equals/Not Equals Operators for more detail.
The
alias
table metadata attribute has been deprecated and replaced by the
rowAlias
and
rowSetAlias
attributes. This enables you to control the JSON object names in request/responses and Java API map child key names, whereas in previous releases the framework appended an "s" to the alias. See the aliases section in Concepts for more detail.
This addresses GitHub Issue #48.
The table metadata attribute will continue to work without errors or warnings. The alias drives the rowwAlias value and alias + "s" the rowSetAlias. Replace the alias with rowAlias and rowSetAlias at your own pace.