I have two products, Product A and Product B. Product A has a list of Campaigns created using M database calls and Product B also has a list of campaigns created by separate N database calls.
Important Point to be noted - Some calls are common between M and N.
Now for Product A we call the list of M Database calls and combine them into a single list and vice versa for Product B.
Now we want to apply a list of X Filters on Product A and a list of Y Filters on Product B in order to get filtered list of Product A campaigns or Product B campaigns depending on the client's call for a particular Product.
What do you suggest, how should we approach it for the design of the system? Any suggestions or link or reference to guide me in the right direction would be greatly appreciated.