I have a list of items. Some of the items are another list and that list item
could be another list. Now I want to filter the main list by the inner list
item value based on some criteria...
My fileter criteria is, A and B and C and D and E then get the filtered
item...where A, B , C ,D, E are passed from the frong end.
How can I efficiently filter the main list. Any generic efficient logic so
that I can make it more generic code...
I was thinking if
- I can convert the list into DataView and filter by SQL queries?
- I can conver the list into XML file and use XPATH and XQuery?
Any better thoughts...
The slection of the technology is the key to the performance for our
application
THanks