We need to prefilter our lookup by a certain date. I just don't know, how to write it out as a FilterValue.

LookupPreFilter filterEndDateSince = new LookupPreFilter();
filterEndDateSince.CondOperator = "Greater than or Equal";
filterEndDateSince.FilterValue = ???;
filterEndDateSince.LookupEntityName = "Sage.Entity.Interfaces.ILicenseOrder";
filterEndDateSince.PropertyName = "EndDate";
filterEndDateSince.PropertyType = "System.DateTime";

The actual date will be set dynamically, later. I've tried it with the following strings so far:

• 2019-01-01T00:00:00Z (the lookup returns nothing)


• 2019-01-01T00:00:00 (the lookup returns nothing)


• 2019-01-01 (the lookup returns everything unfiltered)


• 01.01.2019 (the lookup returns everything unfiltered)


• 01.01.2019 00:00:00 (this is the format, how the DialogService shows me any Datetime? value; the lookup returns nothing)


• @2019-01-01@ (the lookup returns everything unfiltered)


• @2019-01-01T00:00:00@ (the lookup returns nothing)


• @2019-01-01T00:00:00Z@ (the lookup returns nothing)


• Thu Feb 28 00:00:00 UTC+0000 2019

So: how do you specify a datetime string for a lookup prefilter?

The sames question applies to LookupPreFilters with a PropertyType of System.Boolean.

Since the SalesLogix data types are usually nullable like bool?, how do you correctly filter them, if the column in the database contains null? Should I initialize the whole column with 'F' and set the corresponding fields to a default value on creation or is there any hint on how to filter them correctly? Currently I'm trying to filter like this:

LookupPreFilter filterSalesOrderNotCreated = new LookupPreFilter();
filterSalesOrderNotCreated.CondOperator = "Not Equal to";
filterSalesOrderNotCreated.FilterValue = "True";
filterSalesOrderNotCreated.LookupEntityName = "Sage.Entity.Interfaces.ILicenseOrder";
filterSalesOrderNotCreated.PropertyName = "CreatedSalesorder";
filterSalesOrderNotCreated.PropertyType = "System.Boolean";

I'm going for not equal to true because I thought this includes being set to False or being set to null. But the resulting list will remain empty, altough there's no single LicenseOrder where the property is set to True.

So: how do you specify a LookupPreFilter filtering for nullable bools? Setting the PropertyType to System.Boolean? doesn't work either.