The coming version 3.4 of Enesys RS Data Extension will provide Intellisense features for editing SQL SELECT clauses within a “sqlSquery” statement.
When joining two SharePoint lists, you will usually come up with a query that contains three statements.
Two “list” statements used to retrieve data from your SharePoint lists and a sqlQuery statement that will contain a SQL SELECT clause for joining the two SharePoint lists.
In current version, you don’t have much help when writing the SELECT clause. For simple joins, that may not really be a concern. For more complex SELECT clauses, writing down the field and list names may be a more tedious task.
Version 3.4 will provide some intellisense features that will make it unnecessary to look around for column names:
As shown in the following screen shots, you will notice that useful information is provided when navigating over the elements :
Columns are automatically filtered :
We hope you will enjoy this new feature.