Good morning. I have a requirements where the rows should be filtered dynamically based on the filter conditions specified in a excel/text file.
i.e. Say today, the text/excel file contain the filter condition as "row1.field == '3' "
The user will keep on adding/updating conditions in this excel file based on the requirements.
As per the added/updated filter conditions, the rows should be selected/filtered with no code changes.
The tFilterRows accepts only the hardcoded conditions. And I do not see any other component which will satisfy my requirements. Have anyone encountered such scenarios earlier? If yes, can you please suggest how this can be achieved? Thanks and have a great day.
The problem here is, the conditions in tFileRow will be set at the design time of the job and therefore the condition can be become part of the job code. You need something what can be applied at the runtime. Probably you take a look at the Drools facility. Drools allows to read the rules from an Excel file and the rules will be applied at runtime.