Copying custom module's listview

Goody day everyone!

I have a created a module named prospect_inquiry.

Now, I need to create 2 more modules “Individual Prospect” and “Corporate Prospect”. These two modules are filtered by “individual” and “corporate” from my first module prospect_inquiry.

My problems are the following:

  1. How can I create these two modules without creating new tables.
  2. How can I override the listview’s query because I need to add another condition. // prospect_type = ‘individual/corporate’’
  3. How can I use prospect_inquiry’s table in these two modules that can still use SuiteCRM’s default listview/detailview/editview ?

Please help me. I badly need this as soon as possible. Your help is much appreciated. :frowning:

Hello!

I have to say your Data design is not sounding very well to me… but maybe it’s just me :slight_smile:

I don’t recommend going off creating new modules for such things. If you can keep your main entities in the main modules (Contacts, Accounts, Leads), then you will get a ton of functionality linked to those modules that you will find really helpful.

Also, when you need to segment, use a simple field to do it, if possible. Like “Prospect Type” to differentiate Individual from Corporate.

If these Prospects are your main business entities, have you considered keeping them simply as (companies) Accounts and Contacts (people)?