Basically, I have combined 3 call logs from verizon (comma-delimited), t-mobile (comma-delimited), and a internal system (SQL Server) into one table. Built a dataview to a table that right now with test data has 300,000 rows and will have lots and
lots more and all fields are varchar() in database even date and time. Since I have 300,000 rows, I paged the data at 1000 as this would take a long time for everything to load.
So building the dataview was a challenge to get working but figured that out. Now I am trying to build searching functions so that someone can search and filter the results on date, time, and really any of the fields. I attempted a form webpart
and setup parameter for search and it kinda works when I have a few test rows. One thing I noticed was if the data was on another page it did not include those in my filter and I think if I paged over eventually I would find it.
So my ultimate question is how would I add filtering/searching into this dataview. Could I dynamically adjust the query for the dataview like on said date range based on dates in form web part? Is there a better method for anything I am trying todo?
View Complete Post