IDataObjectLoadOptionsBaseSqlFilters Property |
States a list of sql filters.
Sql filters are added to the "where" clause of the query used for loading data objects.
Using sql filters requires knowledge of how the data object query is constructed
and should be used with great caution.
Namespace: Omada.OE.Model.Public
Assembly: Omada.OE.Model (in Omada.OE.Model.dll) Version: 15.0.0.0
SyntaxExamples
This will ensure that only data objects with a number less than 100 are loaded.
IDataObjectController controller = ControllerFactory.GetController<IDataObjectController>();
IDataObjectLoadOptions loadOptions = controller.CreateLoadOptions();
loadOptions.SqlFilters.Add("do.number < 100");
IList<IDataObject> dataObjects = controller.LoadDataObjects(loadOptions);See Also