DataObjectController Class

Connection string for the database. Can be null.

DbCommandTimeout is applied to SqlCommand objects created using CreateSqlCommand(). The DbCommandTimeout value is (normally) passed on to other controllers created by the controller. If DbCommandTimeout is Zero then the DB default will be used as timeout.

Consider using CreateCommand() instead of accessing DbConnection directly. DbConnection and DbTransaction are either specified when constucting the controller or the controller constructs them itself (by using ConnectionString) when calling DoInConnection or DoInTransaction. If the caller specified DbConnection and DbTransaction when constucting the controller then the caller is responsible for the management of the connection.

Consider using CreateCommand() instead of accessing DbTransaction directly. DbConnection and DbTransaction are either specified when constucting the controller or the controller constructs them itself (by using ConnectionString) when calling DoInConnection or DoInTransaction. If the caller specified DbConnection and DbTransaction when constucting the controller then the caller is responsible for the management of the connection.

Factory class for creating controller instances.

Assigns a set of permissions to a data object. If the data object inherits its security then the inheritance is broken before the new permissions are assigned. All existing permissions (regardless of whether security is inherited or not) is cleared before the new permissions are assigned.

Builds a cache key for use with GetFromCacheIfPresent. The cache key is not hashed because we have experienced a collision using GetHashCode() ie. the cache keys are quite long and there is a price in dictionary size in memory and in dictionary lookups.

Returns whether the active user has a specified set of permissions to a number of specified data objects. The method only returns true if the active user has the specified set of permissions to ALL of the specified data objects. The method inspects the DOSM and any Access Modifier that applies to the data objects. If the active user is the SYSTEM user the method always returns true. Also, if the method is executed inside a SecurityOverrideContext it returns true. The active user's auth level is considered.

Returns whether the active user has a specified set of permissions to the specified data object. The method inspects the DOSM and any Access Modifier that applies to the data object. If the active user is the SYSTEM user the method always returns true. Also, if the method is executed inside a SecurityOverrideContext it returns true. The active user's auth level is considered.

Checks that the active user is allowed to perform an CRUD operation on a specific configuration object. (note: except that a Create operation is not for a specific object). Throws a SecurityException if not. Method can be used for all configuration objects that are represented by a ConfigurationObjectType (except those that have a compound key). Method checks auth role security as well as whether it is allowed to modify builtin/feature package objects.

Checks that the active user is allowed to Create a new - or Update an existing configuration object. Throws a SecurityException if not. Method can be used for all configuration objects that are represented by a ConfigurationObjectType (except those that have a compound key). Method checks auth role security as well as whether it is allowed to modify builtin/feature package objects.

Converts the integer id of an object to its transport-safe unique id (UId).

Converts a string representation of an integer or Guid id to an integer id.

Converts the transport-safe unique id (UId) of an object to its integer id.

Returns the Ids of one or more data objects from their U(nique)Ids. The UId of a data object remains the same when it is transported to another system - this is not the case with the Id of a data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the U(nique)Ids of one or more data objects from their Ids. The UId of a data object remains the same when it is transported to another system - this is not the case with the Id of a data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Converts the transport-safe unique ids (UId) of a number of objects to integer ids.

Converts the integer ids of a number of objects to their transport-safe unique ids (UId).

Method creates a new data object of the specified type. The property values of the specified template object will be copied to the new data object based on the settings of the specified copy rule.

Creates/instantiates a new data object that is ready to be assigned property values to and being saved to the database. Note that the method doesn't save the data object to the database.

Create a new SqlBulkCopy instance using the connection, transaction and timeout values from the controller

Returns whether a data object with a specified id exists in the db - regardless of whether it is marked as deleted or not!

Does at least one (non-deleted) data object of a specified type exist in the system?

The method checks if all data objects exist

Deletes all versions of a data object except the current version.

Deserializes filter expressions from an xml format.

Executes an action that doesn't return a result. If no current connection exists, it will establish a connection to the database and close it afterwards. An existing connection will be reused. Inside the action, the connection is available as DbConnection.

Executes an action that doesn't return a result. If no current connection exists, it will establish a connection to the database and close it afterwards. Connection and Transaction are passed to delegate, to allow passing to other controllers An existing connection will be reused. Inside the action, the connection is available as DbConnection. To ensure a new connection set forceNew to true.

Executes an action and returns the result. If no current connection exists, it will establish a connection to the database and close it afterwards. An existing connection will be reused. Inside the action, the connection is available as DbConnection.

Executes an action (that doesn't return a result) in a transaction. If no current connection and/or transaction exists, it will establish it and commit and close it afterwards. An existing connection/transaction will be reused. Inside the action, the connection is available as DbConnection and the transaction as DbTransaction.

Executes an action in a transaction and returns the result. If no current connection and/or transaction exists, it will establish it and commit and close it afterwards. An existing connection/transaction will be reused. Inside the action, the connection is available as DbConnection and the transaction as DbTransaction.

Executes an action in a transaction and returns the result. Connection and Transaction are passed to delegate, to allow passing to other controllers If no current connection and/or transaction exists, it will establish it and commit and close it afterwards. An existing connection/transaction will be reused. Set forceNew to true to ensure new connection and transaction Inside the action, the connection is available as DbConnection and the transaction as DbTransaction.

The method can postpone a SQL transaction implemented by action if the method returns a default number, eg. 0. If the the action method throws a SQL transitent error, then the next call to action is also postponed.

The method can postpone a method invocation if the previous call returned a default number, eg. 0.

Executes a query with a scalar result.

Loads and returns a single data object. Throws an exception if it can't be found.

Loads and returns a single data object. Throws an exception if it can't be found.

Loads and returns a single data object. Throws an exception if it can't be found. Security is respected.

Loads and returns a single data object. Throws an exception if it can't be found.

Returns a sorted list of the ids of the data objects that lie directly below a specified data object. Security is disregarded.

Returns a sorted list of the ids of the data objects that lie directly below a specified data object. Security is disregarded.

Returns the count of dataobjects.

Returns the displaynames for a number of data objects. The security model is not considered. Delete-marked data objects are also returned. Note that the names are not necessarily in the same order as the ids.

Tip: use Dictionary<int, string> GeDisplayNamesEx(IEnumerable<int>) instead.

Tip: use Dictionary<int, string> GeDisplayNamesEx(IEnumerable<int>) instead.

Returns the count of dataobjects grouped by the grouping parameters provided in the loadOptions. If an data object has an undefined value for a group it is not counted.

Use GetDataObjectIdByKeyValue(int, string, string) instead

Returns the id of a dataobject (of a specific type) based on the value of a property of datatype text. Security is overridden.

Returns the id of a dataobject (of a specific type) based on the value of a property of datatype text. The id of the first dataobject that matches the property value is returned. The property value is caseINsensitive. If no dataobject is found zero is returned.

Finds data object ids by their display names.

Finds data object ids by their display names.

Find data objects that has (one of a set of) specified values in a specified text property. The data object security model is not respected!

Returns the ids of one or more dataobjects (of a specific type) based on the values of a property of datatype text.

Returns a dictionary with data object ids and their key values. The key value of a data object is the value of the (text or integer) property specified as key property on the data object type. If no property is specified as key property on the data object type then the display name is used.

Returnerer dictionary med key values for alle dataobjekter angivet i dataObjIds. Key value er enten værdien for den (key) property som er angivet på dataobjtypen eller dataobjektets displayname.

Returns a dataobject manager object loaded with dataobjects.

Returns the ids of the data objects that refers the indicated data object through a reference property. Looks in all versions.

Returns the ids of the data objects that refers the indicated data object through a reference property.

Returns the ids of the data objects that refers the indicated data object through a reference property.

Returns the ids of the data objects that refers one or more of the indicated data objects through a reference property.

Returns type ids for a number of data objects in the form of a dictionary where the keys are data object type ids and the values are lists of ids of the data objects of the specific type. Disregards security and the deleted flag.

Returns the id of the data object type which a data object is of. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the id of the data object type which a data object is of. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returnerer et dataobjekts typenavn og (eget) nummer.

Returnerer typeids for et antal dataobjekter. Der tages ikke hensyn til security eller om objekterne er slettede.

Returns type ids for a number of data objects. Disregards security and the deleted flag.

Returns a distinct list of data object type ids for a collection of data object ids. The method doesn't consider the security model. The method doesn't consider whether the data objects are marked as deleted.

Returns the system name of a data object's data object type. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the system name of a data object's data object type. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the uids of the data objects of the specified type, that hold the specified key value. Security is overridden! Deleted objects are not considered.

Find data objects that has (one of a set of) specified values in a specified integer property.

Find data objects that has (one of a set of) specified values in a specified text property.

(Inherited from ControllerBase.)

Returns the display name of a data object. Obtaining the DisplayName using this method consumes less resources than loading the entire data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the display name of a data object. Obtaining the DisplayName using this method consumes less resources than loading the entire data object. The method doesn't consider whether the data object is marked as deleted.

Returns the display name of a data object. Obtaining the DisplayName using this method consumes less resources than loading the entire data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the displaynames for a number of data objects. The security model is not considered. Delete-marked data objects are also returned. Note that the names are not necessarily in the same order as the ids.

Returns the displaynames for a number of data objects. Delete-marked data objects are also returned. Note that the names are not necessarily in the same order as the ids.

Returns the displaynames for a number of data objects. The security model is not considered. Delete-marked data objects are also returned. The result is being cached for 2 minutes unless caching is ignore using IgnoreCacheContext

Gets file attachments from a data object.

Retrieves some data from the cache or (if it is not there) executes an action and stores the result in the cache. Caching is not applied if the IgnoreCacheContext is used (depending on the parameter for it). Note: caching should only be used with great care as there are a number of potential issues involved in using it!

Returns the Id of a data object from its UId. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Tip: Use GetSinglePropertyValue(int, int, T) instead

Gets the data version of an object.

Returns a subset of data objects that has been changed in one or more properties since a specified point in time. The method does not use snapshot reads but reads committed data (unlike the default in APIs). This is because the object ids originate from the view viewPolicyEngineObjectEvents which makes dirty reads.

Returns the id of the parent data object to a data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returnerer alle logentries for en property (med log) på et givet dataobject. Hvis den aktive bruger ikke har adgang til property returneres en tom collection.

Returnerer alle logentries for en property (med log) på et givet dataobject. Hvis den aktive bruger ikke har adgang til property returneres en tom collection.

Returnerer alle logentries for en property (med log) på et givet dataobject. Hvis den aktive bruger ikke har adgang til property returneres en tom collection.

TIP: Use GetSinglePropertyValue(int, string, T) instead! Returns a Text or Xml property value of a data object.

Returns the value of a Value property with data type 'Text' or 'MultiLangText'. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted. Throws an exception if: - The data object doesn't exist - The property doesn't exist or it is not a value property w. data type 'Text' or 'MultiLangText'. - The property is a log property.

Returns the value(s) of a Set property or a Reference property. If the property is a Set property the Ids of the selected Set Property Values are returned. If the property is a Reference property the Ids of the selected Data Objects are returned. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted. Throws an exception if: - The data object doesn't exist - The property doesn't exist or it is not a Set property or a Reference property.

Returns the value(s) for a property or a fixed field on a data object. Not all fixed fields are supported - please refer to the PropertyValuesContainer class for details. The security model is respected. Throws an exception if the data object doesn't exist or security prevents access to it.

Returns the ids of a number of data objects which found by applying a reference path to a number of source data object ids. The security model is not respected!

Returns the display values for the provided data object ids and reference path. Unless "overrideSecurity" is true, the security is respected for the referenced objects.

Returns a collection of reference property control values. If a ReferencePropertyDisplayValueResolver has been implemented this is used to "override" the display values of the referred data objects.

Returns a collection of reference property control values. The method looks up the data object type ids and display names of the referred data objects. If a ReferencePropertyDisplayValueResolver has been implemented this is used to "override" the display values of the referred data objects. The method doesn't respect the security model. Data objects are returned even if they are marked as deleted.

Returns the value of a specific reference property on a data object. If more than one value are present the first is returned. If no value are present then 'default' is returned.

Returns the value of a specific reference property on a data object. If more than one value are present the first is returned. If no value are present then 'default' is returned.

Returns data object ids that are referred by a number of data objects in a reference property. If the property has multiple values, only the first one is returned If the property has no value, a default value is returned

Returns the distinct data objects that are referred by a number of data objects in a reference property.

Returns the value of a specific set property for a list of data objects. If more than one value are present then the first is returned. If no value are present then 'default' is returned.

Return set property values for a given data object

Returns a single value for a property or a fixed field on a data object. Not all fixed fields are supported - please refer to the PropertyValuesContainer class for details. The security model is respected. Throws an exception if the data object doesn't exist or security prevents access to it.

Returns a single value for a property or a fixed field on a data object based on ODW mapping. Not all fixed fields are supported - please refer to the PropertyValuesContainer class for details. The security model is respected. Throws an exception if the data object doesn't exist or security prevents access to it.

Returns a single value for a property or a fixed field on a list of data objects. Not all fixed fields are supported - please refer to the PropertyValuesContainer class for details. The security model is respected. Throws an exception if the data object doesn't exist or security prevents access to it.

Returns ID's for the process template or instances that use the specified dataobject as target

Returns ID's for the undeleted process instances that use the specified dataobject as target

Returns ID's for the process instances that use the specified dataobject as target

Returns values for a number of properties (with datatype text) for the current version of a dataobject.

Returns values for a number of properties (with datatype text) for the current version of a dataobject.

Returns the U(nique)Id of a data object from its Id. The UId of a data object remains the same when it is transported to another system - this is not the case with the Id of a data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the U(nique)Ids of one or more data objects from their Ids. The UId of a data object remains the same when it is transported to another system - this is not the case with the Id of a data object. The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

Returns the subset of userIds which have the stated permissions to the specified data object. The method doesn't consider authentication levels. The method doesn't consider access modifiers!

Gets all versions of a dataobject. Index 0 is the current version. Index 1 is the previous version (if any). ... and so forth.

Processes a set of data object operations (create, update or delete).

Imports (creates, updates or deletes) a number of data objects as specified in a "Data Object Exchange ML" xml document.

(Inherited from ControllerBase.)

Increments the data version of an entity object. The data version is incremented in the db as well as on the object itself. Method is used to update the data version of an object when an aggregated object is created/modified/deleted. The purpose is to ensure that the id-based cache (in AppIdentity) is updated properly.

Increments the data version of an entity object in the db. Method is used to update the data version of an object when an aggregated object is created/modified/deleted. The purpose is to ensure that the id-based cache (in AppIdentity) is updated properly.

The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

The method doesn't consider the security model. The method doesn't consider whether the data object is marked as deleted.

check whether the given file is present in any data object as an attachment

The method is used for loading a collection of data objects.

Loads a number of dataobjects from the database corresponding to the specified load options.

Modifies the value of an xml property on (the current version of) a data object.

The method populates values for a dataobject version using the XML in tbldataobjectversion.propertyxml. The XMl is loaded using an XmlTextReader, this is more effecient than using a DOM object. A description of the propertyxml format can be found in OE57 'PropertyXML.doc'

Populates the property values of a data object from a set of attribute value pairs. The data object is *not* saved.

Creates a temporary db table with a single column and populates it with values.

If the action throws a transient sql error, the exception is eaten. An entry is written to the log with level Information. The entire exception is written to the log with level Debug.

Purges a chunk of obsolete data object version rows. The minimim age of object versions are configured on the object type, only object versions older than that are deleted

Purges *all* delete-marked data objects except: users, user groups, process- and activity-templates. Purging is done in several transactions to improve throughput of other threads.

Sletter et dataobjekt helt fra db. Dataobjektet skal være slettemarkeret inden metoden kaldes. Dataobjektet må ikke være af følgende typer: user, usergroup. Dataobjektet må ikke være en proces template (men gerne en instans). Samtidig slettes alle dataobjekter, der befinder sig under do i træstrukturen. Metoden håndterer sletning af specielle dataobjekter korrekt (d.v.s. activities, processes m.v.). Metoden kalder sig selv rekursivt. Såfremt et af de dataobjekter, der skal slettes, ikke kan blive det, rejses en delete exception.

Purges a chunk of obsolete data object version rows. It is safe to delete the rows for data object types which is not marked with "object versioning"

Purges a chunk of old property value rows. It is safe to delete the rows because the property values are stored in tblDataObjectVersion.PropertyXML.

Creates or updates a data object.

Creates or updates a data object.

Tip: use AssignPermissions() instead.

Produces a DataObjectExchangeML xml document with a subset of the data objects that are in a view.

Moves a data object to another location in the tree structure.

Moves a data object to another location in the tree structure.

Method "touches" a data object which stages a MIM sync import.

Method "touches" a data object which stages a MIM sync import.

Method will touch the provided data object id's which will stage an ILM delta import

Converts/transfers one or more specified uids in a loadoptions object to ids. The purpose is to enable caching as IEntityObjectsLoadOptions.IdList only works with ids (and not uids).

Indlæser ALLE dataobjects i systemet og opdaterer deres DisplayName. Anvendes i.f.m. opgradering fra 5.1->5.2 - men også i tilfælde af at db kommer ud af sync!

Updates the current version of a data object (that is, without creating a new version) with new property values.

Updates the current version of a data object with a set of property values.

Updates an existing data object in the database by assigning new values to certain properties. The calling user must have the appropriate security rights to perform the operation.

Updates the displayname of a single dataobject.

Method updates all objects of specific DataObjectType to set their DisplayName to the format specified in the DataObjectType. It also refreshes the SearchData for the data objects.

Method updates all objects of specific DataObjectType to set their DisplayName to the format specified in the DataObjectType. It also refreshes the SearchData for the data objects.

Saves a data object after having modified it. In case of an UpdateException due to someone else having updated the data object since it was loaded the method will re-load it and try again. In case of an UpdateException (for the same reason) the second time the method will either silently ignore it or re-throw the UpdateException. In case of all other types of exceptions being thrown the method will simply re-throw it.

Opdaterer displayname for et dataobjekt.

Update the UID of a dataObject

Validates that the data version of an object corresponds to the data version in the DB. Method is used for validation before saving an object.

Validates a property value towards the regular expression defined on the property.

The delegate is used to resolve display values for reference property values. Normally the DisplayName of a referred data object is used as display value. This can be altered by using a custom resolver. The resolver can decide whether to resolve display values from the property system name. If the resolver doesn't want to resolve anything it should return null. Even if the resolver decides to resolve display values it doesn't necessarily have to do it for all values.

With the DataObjectSearchDataResolver delegate it is possible to change the calculation of searchable terms in the fulltext search. As a starting point, the delegate should calculate somewhat the same result as the standard search terms, but parts of the string can be removed, added or replaced. The search data terms are separated with space.

With the WordBreaker delegate it is possible to change the calculation of searchable terms in the fulltext search, both the global search and the column search

Converts object to boolean.

Converts object to DateTime.

Converts object to integer.