Click or drag to resize

SqlAccessModifier Class

The SqlAccessModifier can be used to apply SQL filtering in views or other data object queries.

It should only be used of no other available filters can be used.

The SQL filter string is stored in an CodeMethod configuration object.

The filter string is added after an AND statement like this: "AND ([filter string])".

ParameterDescription
CONFIGUIDCode Method Configuration containing a SQL filter string.
Examples
Example of configuration: CONFIGUID=a935eac0-6e8d-4d0c-b4d7-92bba25fc653 Example of content in CodeMethod Configuration item: not exists (select 1 from sometable as st where st.doid = do.id)
Inheritance Hierarchy
SystemObject
  Omada.OE.AppLogic.AccessModifiersSqlAccessModifier

Namespace:  Omada.OE.AppLogic.AccessModifiers
Assembly:  Omada.OE.AppLogic (in Omada.OE.AppLogic.dll) Version: 15.0.0.0
Syntax
C#
Copy
public class SqlAccessModifier : IDataObjectAccessModifier, 
	IAccessModifierBase

The SqlAccessModifier type exposes the following members.

Constructors
  NameDescription
Public methodSqlAccessModifier
Top
Methods
Extension Methods
  NameDescription
Public Extension MethodToBool
Converts object to boolean.
(Defined by ObjectExtensions.)
Public Extension MethodToDateTime
Converts object to DateTime.
(Defined by ObjectExtensions.)
Public Extension MethodToInt
Converts object to integer.
(Defined by ObjectExtensions.)
Top
See Also