Friday 10 June 2011

A Second NuGet Package for Dynamic Data

Dynamic Data 15 Custom Filters is now on NuGet  this package add thirteen filters to your Web Application Project see Five Cool Filters for Dynamic Data 4 I have added some more filters to that list;

  • AutoComplete – is ForeignKey filter but pre-filters results by what users has typed in.
  • Contains – equivalent to T-SQL LIKE ‘%text%’
  • DateFrom – All Dates greater than or equal to the selected date.
  • DateRange – A range of dates
  • DateTo – Less than or equal to the selected date.
  • EndsWith – Ends with entered text.
  • GreaterThan – Greater than entered value
  • LessThan – Less than entered value
  • MultiForeignKey – allows multiple ForeignKey values to be selected.
  • Range – a range of values
  • StartWith – Starts with entered text.
  • Where – is equal to entered text
  • WhereDropdownList – a dropdown list of values from column to filter by.

This has a few more exciting bits that NuGet offers Dependencies and Framework Assembly References

Dependencies, here this package there is dependency upon Ajax Control Toolkit

    <dependency id="AjaxControlToolkit" version="4.1.50508" />

Framework Assembly References – is requirement for an assembly reference from the GAC

    <frameworkAssembly assemblyName="System.Data.Entity" targetFramework="net40" />

This give great flexibility without resorting to PowerShell.

NuGet truly is awesome!


Jim said...

Very usefull, and NuGet IS truly awesome. I'm working on a couple of dynamic data projects and i just installed the 13 filters, i noticed 1 "error" though, when using the DateRange filter and choosing Today:
DateFrom: 15-06-2011
DateTo: 15-06-2011
Data Unfiltered:
14-06-2011 15:25
15-06-2011 02:15
15-06-2011 16:00
16-06-2011 14:35

Expected data would be:
15-06-2011 02:15
15-06-2011 16:00

No data.

DateFrom uses Expression.GreaterThanOrEqual, DateTo uses Expression.LessThanOrEqual. So we should get "today's data" the reason why is probably the DateTimes used in the filters are From: 15-06-2011 00:00:00
To: 15-06-2011 00:00:00
so the to date is actually not included even though we are using "OrEqualTo" the time should also be 23:59:59 (or something like that)

I'm not sure how to change this, a little help?

Stephen J. Naughton said...

Hi Jim, e-mail me direct and we will sort this out.


P.S. email is in top right hand corner of site.

Anonymous said...

Thank you very much for the nice filters collection.

I want to signal something I have found trying them, hoping it may help someone else too: with the autocomplete filter on my dev-pc with IE 9 to make the complention list appear I had to remove from the CSS the visibility:hidden attribute; otherwise the list appeared only when hovering the textbox with the pointer.

With Chrome this change was not needed.


Stephen J. Naughton said...

Hi Federico, I'll look into that soon as I want this to be cross browser with no issues, thansk for reporting it.


FishOfPrey said...

Very Helpful, thanks.

The link for Dynamic Data 13 Custom Filters is broken for me.

I think it needs the NotAClue prefix on the namespace now.

Dynamic Data 15 Custom Filters

Stephen J. Naughton said...

Thanks FishOfPrey, I've fixed it now points to the latest version I was just getting strated with NuGet and made a few mistakes