0 Replies Latest reply: Oct 13, 2017 7:51 PM by Fred Lee RSS

    Filtering SugarCRM Records

    Fred Lee

      How does one specify selection criteria when using the Beta Web Connector for SugarCRM in Qlik Sense Cloud?  Is there an additional parameter that must be added to the SELECT statement PROPERTIES?

       

      SELECT

           id,

           name,

           date_entered,

           date_modified


      FROM CustomModule

       

      WITH PROPERTIES (

           moduleName='MyCustomModule'

           ,max_num='10000'

           ,order_by='date_modified:DESC'

      );