User defined custom filter
I have a project to handle large data files, one of the features i would like to build in is a custom filter,
For example the user selects their parameters and then adds logic before running the report.
so they might choose 'region, value, average order value'
and wish to add logic that says:
If region EQUAL TO midlands AND value > 1000 AND average order value > 15
How can i take that user input and add it into my code at runtime?
Its new territory for me this kind of thing so am asking for suggestions on what i should be getting into to accomplish this.
I have done some cursory searching but the results are leading me off at too many tangents, has anybody any direct links on this?
Is it interpretation, expressions? lexical analysis? parsing? all of the above?
Any advice appreciated!