Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
);
@Hi @scottduthie - It took us a little longer to get this release out but you should now see filter and fields parameters - as shown for example here:
Note there is a link in the description at the top to a page which will give some support on constructing the filter string.
Will this be released on the on premise Web Connectors as well? My SugarCRM opportunity table has over 400,000 records and it would be great to filter by a date field.