Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fredlee33
Partner - Contributor II
Partner - Contributor II

Filtering SugarCRM Records

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'

);

12 Replies
chrisbrain
Partner - Specialist II
Partner - Specialist II

@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:

chrisbrain_0-1614930964512.png


Note there is a link in the description at the top to a page which will give some support on constructing the filter string.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
scottduthie
Partner Ambassador
Partner Ambassador

Hi @chrisbrain ,

Thanks for pushing this update through. We'll go test it out.

Scott.

DGO
Contributor III
Contributor III

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.