by itsapiens

Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.

Free 30 day trial
Try it Now

#2831 - Is it possible to filter by related module for multiple values?

Open General Question created by AIE 2 months ago

Hi. We would like to know if it is possible for a related module to filter by various options, instead of just one selection - similar to what we can do with a drop-down list allowing selection of multiple values?. Here is a scenario:

We would like to filter by Product Name (related product module) by selecting a few specific products to filter by, instead of just one specific filter. It seems currently the filed only allows one text value to be entered. Is there any functionality that would allow us to use this related module similar to how we filter values from a drop-down list? Or if there isn't a specific feature for this, should we use the "OR" between the different product names to build a list individually?

filters_for_related_modules.PNG

  1. itsapiens member avatar

    itsapiens Provider

    2 months ago

    Hello,

    Thank you for contacting us! Picklist items like 'Sales Stage' can be selected as you identified. Text fields wouldn't appear like picklists in filter, you need to write them manually.
    You can add those by using "or" criteria between filters of Product name (please ensure to use green "+" for adding new filter and not the "Add Group" in order to add several "or" for product names. Please see sample below (assuming that "Account Name" is same as "Product Name":

    Screen Shot 2020-06-04 at 18.26.36.png

    Let us know if you have any more questions or need any help!

    Best Regards,
    IT Sapiens Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...