Specifies whether saved module filters are exposed as views in the provider.

Data Type

bool

Default Value

true

Remarks

SugarCRM allows you to create filters (also known as Saved List Views) to narrow down records within modules based on specific criteria. When this property is set to true, the provider exposes these saved filters as queryable views, allowing you to retrieve pre-filtered data directly through SQL queries.

When set to true, you can query filtered modules using the following syntax:

SELECT * FROM [Filter_Cases_Open Cases]

In this example, Cases is the module name and Open Cases is the saved filter name applied to that module.

When set to false, the provider does not expose module filters as views. You will need to manually apply filter criteria in your WHERE clauses when querying base module tables.

This property is useful when you want to:

• Leverage existing SugarCRM filters without recreating filter logic in SQL queries
• Access commonly used filtered datasets through simple view queries
• Maintain consistency with filters defined in the SugarCRM UI

Use the ModulesFiltersList connection property to control which specific filters are exposed as views for each module. This allows you to limit the number of views generated and focus only on the filters relevant to your use case.