If I have the following aggregates
- Clerk: Employee
- Manager : Employee
I require projections for
- ManagerSummary
- ClerkSuummary
- EmployeeSummary
I thought that I would subscribe to the category, $ce-, stream for Manager and Clerk, but what about Employ.
I could subscribe to both $ce-manager and $ce-clerk, but was hoping not to have touch the EmployeeSummary projection everytime a new Employee type is introduced to the system.
1. Does EventStore support multiple category projection if I create a stream as 'employee-manager-{AggregateId}' ?
2. If not, would it be a could practice to create a custom projection to do this or is there a better approach ?
3. When projecting to a category is the event assign the subsequent sequence number following the last event on the Category stream or does it retain this from its Original stream ?
Many thanks