We have a data type(database) every day 1Lakh new records are getting added up in that. I need to fetch those 10 records and need to generate a case id.How to configure this.
See here we can use data flow or data set maybe but how will I identify the 10 records?
In the Data Flow, use filter logic. If the filter condition returns true, route the record to a Smart Shape that creates a case. If the filter condition returns false, route it to the else path and in destination shape call an activity.
This activity can be a placeholder activity with no business logic, containing only the Exit-Activity method. This ensures the record is processed without creating a case.
You can write a Report Definition based on your filter criteria and logic and to identify the 10 records easily. Once identified, you can traverse the 10 records using the Data Page holding the Report Definition. By looping the records, you can call the OOTB activity svcAddWorkObject which generates the case ids.
Are you expecting to create ONLY 10 cases from 100,000 records in the Data type? Is this dependent on columns stored in the Data type? or run time business rules that determines each record is eligible for the case? Please provide additional context.
If the case type is applicable for straight through processing, then I recommend to use queue processor to create the case,
Hi @Gunasekaran_Baskaran can you suggest what filter criteria do i need to use here?
Hi @RameshSangili this was a scenario based question so no more insight we’re provided
Hi @SakhibHussain we have to fetch 1 lakh records from db and then create 10 cases,so i feel RD will not suffice
In when condition you want to build a logic for which all record case is not needed. Condition should be specific to your use case.