Haven't tried it but you could add a new property to the model, where you just output the year (not the full date) by fetching it from the full date and then applying the ListViewFilter attribute on that one?

Hmm, I have added succesful a filter like this:

[Required]
[UIOMaticListViewField(Name = "Datum", Config = "{'format' : '{{value | date:\"dd/MM/yyyy\"}}'}"), UIOMaticField(Name = "Begindatum", Description = "Geef de begindatum en tijd op", View = "datetime")]
public DateTime Begintime { get; set; }

[Ignore]
[UIOMaticListViewFilter(Name = "Jaar"), UIOMaticListViewField(Name = "Jaar")]
public int Year
{
    get { return Begintime.Year; }
}

Filter shows only the years, like I wanted. But now when I select a year it returns the following error:

Server error: Contact administrator, see log for full details.
Failed to get paged

Logs is saying this, like expected (column Year does not exists):

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Year'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9()
   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Umbraco.Core.Persistence.Database.ExecuteScalar[T](String sql, Object[] args)

Any other idea's?

So if you try to sort by year or what are you trying todo? So what does "select a year" mean :)

AH ok if you actually filter by a year, got it :) hmmm thought that is done in memory will check

Hmm yeah in that case you'll need to make sure that the sql statement actually returns a year, you can use the event model for that, will try to set you up with an example

Super! Maybe I have to save it in my database as extra field (What is not a really nice workaround)?

Like to see your example :)

Thanks!

Mind sharing your table create script? THen I can provide you with the code sample

The SQL to create the table is as following:

CREATE TABLE [dbo].[Event](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](255) NOT NULL,
[Location] [nvarchar](255) NOT NULL,
[Excerpt] [nvarchar](255) NOT NULL,
[Body] [text] NOT NULL,
[Begintime] [datetime] NOT NULL,
[Endtime] [datetime] NOT NULL,
[Places] [int] NOT NULL,
[AlbumId] [int] NULL,
[CoverId] [int] NULL,
CONSTRAINT [PK_Event] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

My POCO is like this:

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using UIOMatic.Attributes;
using UIOMatic.Enums;
using Umbraco.Core.Persistence;
using Umbraco.Core.Persistence.DatabaseAnnotations;

namespace Company.Models
{
    [UIOMatic("event", "Evenementen", "Evenement", FolderIcon = "icon-users", ItemIcon = "icon-user", RenderType = UIOMaticRenderType.List, ShowOnSummaryDashboard = true)]
    [System.Web.DynamicData.TableName("Event")]
    public class Event
    {
        [UIOMaticListViewField, PrimaryKeyColumn(AutoIncrement = true)]
        public int Id { get; set; }

        [Required]
        [UIOMaticListViewField(Name = "Titel"), UIOMaticField(Name = "Titel", Description = "Geef de titel op")]
        public string Title { get; set; }

        [Required]
        [UIOMaticListViewFilter(Name = "Locatie"), UIOMaticListViewField(Name = "Locatie"), UIOMaticField(Name = "Locatie", Description = "Geef de locatie op")]
        public string Location { get; set; }

        [Required]
        [UIOMaticField(Name = "Korte omschrijving", Description = "Geef een korte omschrijving op")]
        public string Excerpt { get; set; }

        [Required]
        [UIOMaticListViewField(Name = "Datum", Config = "{'format' : '{{value | date:\"dd/MM/yyyy\"}}'}"), UIOMaticField(Name = "Begindatum", Description = "Geef de begindatum en tijd op", View = "datetime")]
        public DateTime Begintime { get; set; }

        [Ignore]
        [UIOMaticListViewFilter(Name = "Jaar"), UIOMaticListViewField(Name = "Jaar")]
        public int Year
        {
            get { return Begintime.Year; }
        }

        [Required]
        [UIOMaticField(Name = "Einddatum", Description = "Geef de einddatum en tijd op", View = "datetime")]
        public DateTime Endtime { get; set; }

        [Required]
        [UIOMaticField(Name = "Beschikbare plaatsen", Description ="Aantal beschikbare plaatsen", View = "number")]
        public int Places { get; set; }

        [UIOMaticField(Name = "Hoofdfoto", Description = "Foto bevindt zich in de header", View = UIOMatic.Constants.FieldEditors.PickerMedia)]
        public int CoverId { get; set; }

        [UIOMaticField(Name= "Fotoalbum", Description = "Fotoalbum indien aanwezig", View = UIOMatic.Constants.FieldEditors.PickerMedia)]
        public int AlbumId { get; set; }

        [Ignore]
        public List<Media> Album
        {
            get
            {
                if (AlbumId != 0)
                {
                    return MediaRepository.getAlbum(AlbumId);
                }

                return null;
            }
        }

        [Ignore]
        public Media Cover
        {
            get
            {
                if (CoverId != 0)
                {
                    return MediaRepository.getMedia(CoverId);
                }

                return null;
            }
        }

        [Required]
        [UIOMaticField(Name = "Volledig bericht", Description = "Geef een volledige beschrijving op", View = "rte")]
        public string Body { get; set; }

        public List<Registration> Registrations(int statusId = -1)
        {
            if (Id != 0)
                return RegistrationRepository.getRegistrations(Id, statusId);

            return null;
        }

        [Ignore]
        public Registration Registration {
            get {
                if (Id != 0)
                {
                    Registration registration = EventRepository.getStatus(this);

                    if ((registration != null) &&  registration.Id != 0)
                        return registration;
                }

                return null;
            }
        }

        public override string ToString()
        {
            return Title;
        }
    }
}

I hope you can do something with this :)

POCO on Pastebin: http://pastebin.com/UFytV5nz

Ah awesome yeah gonna try to same as you so a filter on distinct year

Ok can confirm the behaviour :) so now looking into a way we can get this working

So when would you need this? I can then plan the 2.0.3 release :)

Awesome, thanks for this fix! I need it before next month, so not really in a hurry. It is good to know that there will be a possibility, thanks for all the work!

Cool well the release is scheduled for next Thursday (currently doing a maintenance releaase every Thursday) so that would be in time, if you need it sooner let me know

Maintenance release is out, so you should be able to update to 2.0.3 once it's indexed by nuget

Super :)

is working on a reply...