Interceptor CreateQueryFilter Not Called

We have a class that derives from Inteceptor where we are overriding CreateQueryFilter so that we can filter our records by organization Id.

public class FooInterceptor : Interceptor
{
    public Guid OrganizationProfileId;
    public bool IgnoreOrganizationProfileId = false; //true to return all
    public bool IncludeNullOrganizationProfileId = false; // to allow returning records that are not associated with org

    public override IQueryFilter CreateQueryFilter(Type entityType, Type filterType, Func<IQueryFilter> baseCreator)
    {
        if (filterType == typeof (OrganizationFilter))
        {
            OrganizationFilter organizationFilter = new OrganizationFilter
                                                        {
                                                            OrganizationProfileId = OrganizationProfileId,
                                                            IgnoreOrganizationProfileId = IgnoreOrganizationProfileId,
                                                            IncludeNullOrganizationProfileId = IncludeNullOrganizationProfileId
                                                        };
            return organizationFilter;
        }
        return baseCreator();
    }
}

When we use a Lightspeed context:

        using (var uow = LightSpeedContext.CreateUnitOfWork())
        {
            Guid organizationProfileId = ProfileDictionary.OrganizationProfileId(User.Identity.Name);
            LightSpeedContext.Interceptor = new GoAbroadInterceptor
            {
                OrganizationProfileId = organizationProfileId
            };

            List<OrganizationEmailTemplate> test = uow.OrganizationEmailTemplates.Where(x => x.EmailTemplateTypeId == (int)Definitions.EmailTemplateType.NotificationParticipant && x.IsActive).ToList();

            List<PersonProfile> p = uow.PersonProfiles.Where(x => x.LastName == "Hopper").ToList();
        }

The query for OrganizationEmailTemplates does not call the CreateQueryFilter whereas the PersonProfiles does. I cannot see anything in the model XML or classes that is glaringly different.

Also, how/where can I inspect the actual SQL select statements.

TIA...Tom

Hi Tom,

Sounds like a bug - is it possible to send us through a small repro project for the above? There are cases where filtering is not applied which presumably will be whats occurring in the first statement but Id like to understand how this is being triggered based on your model and query since it does seem incorrect.

In terms of inspecting the SQL statements that are being generated you can use a logger within LightSpeed to achieve this - the statements wont be exactly what is sent as we stringify the parameter values when emitting the log entries where as they are sent to the database in typed form via the underlying ADO.NET provider but otherwise it will be the SQL which is executed.

Have a read of http://www.mindscapehq.com/documentation/lightspeed/Testing-and-Debugging/Logging for some more info on setting up a logger.

Jeremy

Hi Jeremy,

I'm working on creating a project for you. Can you email me your dropbox or other preferred method.

Thanks,

Tom

Hi Tom,

You can email it through to us at support at mindscape.co.nz or pop it up on a share somewhere and email us through a link.

Thanks!
Jeremy