DataObjectLoadOptionsBaseIDataObjectLoadOptionsBaseSqlFilters 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
Assembly: Omada.OE.Model (in Omada.OE.Model.dll) Version: 15.0.0.0
SyntaxC#
IList<string> IDataObjectLoadOptionsBase.SqlFilters { get; }
Property Value
Type: IListStringImplements
IDataObjectLoadOptionsBaseSqlFiltersExamples
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