Version 3.1
Client and Server configuration tools
Section titled “Client and Server configuration tools”With the advent of version 3 of Enesys RS Data Extension , a significant step in simplifying installation process had been made. However, server installation was still a manual process.
Starting from version 3.1, you won’t have to tweak configuration files anymore for configuring your SQL Server Reporting Services server. Configuring your Report Server will be just a matter of running our installation program on the server, launch the Server Configuration tool, select the SSRS instance and click on install.
New viewScope attribute
Section titled “New viewScope attribute”New viewScope attribute was added for specifying which folders and items to return. Associated with the existing folder attribute, you can retrieve any data from a folder list.
Possible values are:
| Value | Description |
|---|---|
| Default | Shows only the files and subfolders of a specific folder (default value when a folder is specified). |
| FilesOnly | Shows only the files of a specific folder. |
| Recursive | Shows all files of all folders (default value when no folder is specified). |
| RecursiveAll | Shows all files and all subfolders of all folders. |
New administrative statements
Section titled “New administrative statements”New statements were added to get administrative data from your SharePoint sites, lists and users.
For further information on these statements, see the “
ESQD_Retrieving_administrative_data ” chapter.
New statements “mergeLists” and “rollUpLists”
Section titled “New statements “mergeLists” and “rollUpLists””We have decided to split multiList statement into two separate statements:
- mergeLists replaces the multiList where type = ” MergingList ”;
- rollUpLists replaces the multiList where type = ” RollUpList ”.
The idea behind this change is that though the multiList statement is dealing with multiple lists, the approach taken for rolling up lists and the approach taken for merging lists from a list enumeration are different enough to have their own statement. Moreover, we are expecting to add new options for rolling up lists. Those options that do not make sense when merging lists from a list enumeration would clutter the statement syntax if we were to keep both options into one multiList statement.
For compatibility reasons, multiList statement is still a valid statement.
Except for the type attribute that has been removed, both mergeLists and rollUpLists statements have the same syntax as the multiList statement.
Large lists and paging
Section titled “Large lists and paging”Version 3.1 introduces a new mechanism for retrieving list’s items in chunks of 4000 items by default. This number is configurable using a new “ paging ” attribute.
In previous versions, whatever the number of items in a list, they were retrieved all at once (items are retrieved using SharePoint Web Services). For large lists, this could cause an “out of memory” exception at the SharePoint web service level depending on your hardware and memory configuration.
This new approach makes it possible to handle very large lists.
See the “ESQ_List_Statement_paging ” chapter for more information.
Querying XML data
Section titled “Querying XML data”The new xmlQuery statement lets you retrieve XML data either embedded inline or through a URL you specify.
Because our query architecture lets you manipulate the resulting data of any statement using SQL SELECT statements, this new feature opens up quite interesting possibilities.
In fact, by using xmlQuery statements, you can use Enesys SharePoint Query to aggregate, merge and join data from disparate sources by just writing some logic available through a URL.
For more information on this statement, see the “
ESQ_xmlQuery_statement ” chapter.
Query Builder improvements
Section titled “Query Builder improvements”Query Builder needs a valid License Key to be launched. The License Key can be configured when you install the product, when you launch Query Builder or in the “License Information” menu.
Parameter management was improved.
Unicode characters (Cyrillic…) are now handled properly.
Others
Section titled “Others”- Improved stripHtml behavior.
- Fixed a bug which would cause an error when having a column’s display name containing a colon char and useDisplayName attribute set to true .
- Fixed a bug which would cause an error when using a custom list definition with a template ID greater than 32767.
- Fixed a bug which would cause an error when using a multiList (RollUpLists) statement with the relativeSiteUrl attribute set to ”/” or "" and when the root site also contains the list to roll up.
The version statement is not supported anymore. The new client and server configuration tools included in version 3.1 provide with the necessary version and license information and make this statement useless.