Yup that's possible, you can use the event model for that and basically override the query , this should get you started http://www.nibble.be/?p=493, https://github.com/TimGeyssens/UIOMatic/blob/master/src/Example/Startup.cs

Hi.

I did implement as suggested. But I have a problem with pagination I guess.

SQL Server does return 164 record, but with the same query in UI-O-Matic I do get back only 40 record (4pages)

Any idea?

   UIOMatic.Controllers.PetaPocoObjectController.BuildedQuery += SendSatateLogFilteredHelper.CreatedQuery;

And the method.

public static void CreatedQuery(object sender, QueryEventArgs e)
        {
            if (e.CurrentType == typeof(SendSatateLogFiltered))
            {
                e.Query = new Sql(@"

                SELECT *
                FROM [mSendStateLog] as i1
                inner join (
                SELECT MAX([ID]) as mId
                    FROM [mSendStateLog] as i1
                    where i1.Created > @0
                    group by [MM]
                    having MAX(cast(Synced as int)) = 0
                    ) as i3
                on i1.ID = i3.mId
              ", DateTime.Now.ToString("yyyy-MM-dd"));
            }
        }

is working on a reply...