Dynamic Data's Data Subset Retrieval from DB

Feb 11, 2009 at 3:50 PM
To all DD warriors:

I have looked into Dynamic Data Filtering. It seems to start filtering and searching AFTER all the table data moved to the web pages. So this is probably not what I want.

I want a way to narrow down on the select BEFORE that data move occurs.

For example, one of my tables has daily Attendance information in history. So it is a huge table.  But I just want daily data every day, meaning I only want to move the data where [date] = getdate()

This can sharply reduce the amount of data we move from DB to the pages on the network. Even though I can filter by the date using Dynamic Data Filtering, it would be too late because the entire table's data has been moved already.

Please let me know if anything is not clear.

Thanks a lot.