Awesome - Monday's job at work all sorted...

Cheers

Hey Tim

Below is my code as per your example however it's not getting hit...

I set a break point in the ApplicationStarted method and that gets hit, but I cannot step into the query building method.

using Umbraco.Core;
using Umbraco.Core.Persistence;

namespace Web
{
    public class Startup : ApplicationEventHandler
    {
        protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
        {
            UIOMatic.Controllers.PetaPocoObjectController.BuildedQuery += PetaPocoObjectController_BuildedApplicationStatusQuery;
        }

        private void PetaPocoObjectController_BuildedApplicationStatusQuery(object sender, UIOMatic.QueryEventArgs e)
        {

            if (e.TableName == "NZTR_ApplicationStatus")
            {
                e.Query = Umbraco.Core.Persistence.Sql.Builder
                    .Append("SELECT NZTR_ApplicationStatus.ApplicationStatusId, NZTR_ApplicationStatus.Name, NZTR_ApplicationStatus.Description, NZTR_ApplicationStatus.color, NZTR_ApplicationStatus.AgedAnalysisNoDaysOK, NZTR_ApplicationStatus.AgedAnalysisNoDaysWarn, NZTR_ApplicationStatus.AnalystName")
                    .Append("FROM NZTR_ApplicationStatus")
                    .Append("WHERE Archived = 0");   
            }
        }
    }
}

Any ideas ?

Cheers, Nigel

ARe you sure about the tablename? Tried setting a breakpoint on the if?

Cheers, Tim

Could you try the following, since if it's only limiting you want to do you only need to set the where https://github.com/TimGeyssens/UIOMatic/blob/master/src/Example/Startup.cs#L40

Hi Tim

Have tried setting a break point on the if statement but it isn't getting hit - very weird.

If I put a break point on the line of code within the ApplicationStarted method that gets hit, but I cannot step into the individual method - it simply steps out of the ApplicationStarted method.

Weird...

Nigel

is working on a reply...