What's New in Enesys RS Data Extension 3.6

Version 3.6.31

Fixes:
  • Fixed a bug that prevented to query a List which contained some fields with invalid properties.
  • Fixed a bug which prevented to roll up data starting from a site which contained spaces in its URL.
  • Fixed a bug which prevented the use of multivalues parameter inside the sqlData’s IN clause in some cases.

Version 3.6.28

Fixes:
  • The characters accepted inside the name of parameters are now checked for valid values (unicode letters, digits, _, - and #). This allows having a @ character inside the connection string of the sqlData statement.
  • Removed the possibility to sort the columns inside the Columns panel. This option was not only useless (considering dynamic search is available) but also confusing as there was no way of reverting to natural order.

‘XmlQuery statement User Interface has been updated to simplify the usage of report parameters for specifying a URL.‘

Version 3.6.26

Fixes:
  • Corrected a bug inside the Query Designer introduced inside the v3.6.23 that didn’t allow you to load a query with IsNull or IsNotNull conditions on Lookup and DateTime columns. Note that it was still possible to edit the query in XML mode and that the bug did not affect the proper execution of a query using such a condition.

Added support for XML namespaces to the xmlQuery statement. It’s now possible to specify a namespace when filtering the XML data through the ElementPath property (ie: //my:element).

Version 3.6.23

Fixes:
  • Corrected a bug inside the Query Designer introduced inside the v3.6.23 that didn’t allow you to load a query with IsNull or IsNotNull conditions on Lookup and DateTime columns. Note that it was still possible to edit the query in XML mode and that the bug did not affect the proper execution of a query using such a condition.
Reporting from Survey lists

Enesys RS Data Extension offers a new statement that lets you retrieve Survey lists data in a format that makes it possible to build reports. We are also offering a ready-made generic report that can be used with any Survey list.

Querying Oracle databases

Starting from the version 3.4, the sqlServerQuery statement allowed you to retrieve data from any SQL Server database. In this new version of Enesys RS Data Extension, the sqlServerQuery statement is renamed to sqlData and is extended by adding support for Oracle databases.

The behavior is similar, you just have to select between SQL Server and Oracle when you create the statement: