Group Creation Source View is Blank

I am trying to create a new customer group to send an email to.  It is a set customer list that is attending a tradeshow that we want to invite to dinner via separate emails.  When I select the company entity, there aren't any available source views.  How do I fix this?  Thanks!

  • 0

    Hi Zach

    Your system administrator will need to make the views available for use in groups.  You must also have permission to the entities contained in the view.

  • 0 in reply to Sage CRM

    The issue could be that the database using the default views would bring back more than one row per company.  You can allow duplicate records by updating the "custom_sysparams" table for the entry "AllowDupRecs" to Yes as by default it is set to No.

    This can be changed by using the following SQL  

    UPDATE custom_sysparams
    SET parm_value = 'Y'
    WHERE parm_name = 'AllowDupRecs'

    Then do a metadata refresh via  Administration -> System -> Metadata and you should then see views in the dropdown.

    This will allow multiple rows per result and you can always change it back by changing the 'Y' to 'N' and do a metadata refresh again.