Publicado Fri, 21 Feb 2020 21:12:25 GMT por Steve Shriver Application Specialist
When configuring a List in File Cabinet Configuration (Cloud System), the SQL Statement radio button is disabled and only the Rules Editor is available.

In previous versions there was a check box in the Admin Tool that allowed us to enable the use of SQL Statements, but it is nowhere to be found in the current version of the Admin Tool.

Is that still something that needs to be done, and where can it be done?

Or is SQL simply disabled for Lists and the option still displayed? (and why would you do that?)
Publicado Fri, 21 Feb 2020 21:27:20 GMT por Jon Weston File IT Solutions Sr Application Developer and RIM specialist
Using SQL statements for anything in DW Cloud has been disabled due to security concerns, I'm told, so if you want any kind of filtered list you'll need to setup a file cabinet for it and manage it that way.  I think there's a uservoice request to bring SQL statements in the cloud back.

You must be signed in to post in this forum.