Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a rather large table (over 2000 rows) that I need to pull into a SharePoint list. Business Data Connectivity Service has a pretty easy method to accomplish this yet their filtering is so unintuitive (I know I can increase the max rows but I'd much rather use filtering). What I REALLY want to do is only grab a few records with the most recent DateTime field but I can't even figure out how to filter by the highest integer fields much less DateTime. The Operator only seems to work with something I specify as the default value and can't compare against itself?

I could also take a limit of the highest rows since the most recent additions will be at the end of the table but I don't see how to do a limit that grabs the last items rather than the first. As long as I can retrieve a group of items that actually include the latest DateTime fields I can use linq to further the search in my web part, I'm just struggling in figuring out how to use filtering to do that.

Also, as a more general question, what is the difference between the "Data Source Element" and the "Filter Field"? It seems like the filter works on whatever I specify as the "Filter Field" so what the heck is this "Data Source Element" I have to specify when creating a new filter?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.