Abstract: In accordance with embodiments, steps in a multi-tenant database service are approved to manually and/or automatically satisfy requests to approve various steps in the service. The ability of embodiments to provide such additional approval capabilities may lead to more flexible step approval during use of the on-demand database service.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.

Abstract: A method of establishing personalized limits on a search responsive to a key word query in an enterprise search system is described that includes receiving an object types access history for a particular user. Applying this method, the object types access history includes records of object types selected from search results returning multiple object types and records of object types selected via interfaces other than search results. The method continues with determining and storing in computer readable memory a personalized scope of object types. The personalized scope of object types sets a limit on object types initially returned by an enterprise search system for the particular user in response to key word queries by the particular user that do not specify object types to search.

Abstract: Query independent scores are prepared and applied to search results. Search results applying query term relevance criteria are combined with query independent scores to form a combined score. The combined score may alter the original ranking using only the query scores. The query independent scores can be used to increase the combined scores of important objects, where importance measurements include frequently accessed objects, objects with more connections and/or objects that are the subject of discussion.

Abstract: An embodiment of a multi-tenant database system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.

Abstract: A method for using extensible markup language (XML) for testing a process in a multi-tenant database system is disclosed. The method includes providing a user interface (UI) for a user of the multi-tenant database system, receiving the process for testing via the UI, where the process is created using the UI, receiving an indication from the UI that an XML file is to be extracted for testing the process, and extracting the XML file in response to the received indication, where the XML file is usable for testing the process. Further, sample data for the process can also be created and received. In addition, modifications of the XML file from the user via the UI can be done, the XML file can be executed for testing the process.

Abstract: A system and method for analyzing operations in a multi-tenant database system environment is provided. The system may include a database storing tenant application data and common application data, the tenant application data and common application data controlling a creation, read, update, deletion or undeletion of an object in the multi-tenant database system environment.

Abstract: A method of searching in a database of feed items enables efficient searching through a large corpus of data. Each feed item is associated with at least one object in the database. An index of feed items is generated. For each feed item in the database, the index includes a body of the feed item and at least one foreign key that identifies an object associated with the feed item. A search request with one or more search terms is received from a first user. Using the index of feed items, a pre-filtered set of feed items is generated for the first user. The search is executed, using the index of feed items and the pre-filtered set of feed items. Search results are limited to feed items in the pre-filtered set of feed items.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for versioning content in a database system using content type specific objects. These mechanisms and methods for versioning content in a database system using content type specific objects can enable embodiments to provide a database system which stores information associated with multiple versions of content. The ability of embodiments to provide a database system which supports content versioning can enable an efficient and comprehensive storage of content types having different features by the database system.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for using a database to access content stored outside of the database. These mechanisms and methods for using a database to access content stored outside of the database can enable embodiments to provide a database system which can be used to access content when the content is incapable of being stored in the database system, or is otherwise not stored in the database system. The ability of embodiments to provide access to such data via the database system can improve the usability of the database system.

Abstract: The present disclosure provides novel systems and methods for providing multi-dimensional categorization within a multi-tenant database system (“MTS”). Data items in entities stored in a MTS may be categorized along one or more category dimensions. A search query may include one or more selected categories in one or more category dimensions. Categorization methodologies include multi-selection, multi-position, and combinations thereof. Users of the MTS may also be categorized along one or more category dimensions. A filter may present a subset of data items relevant to a user in accordance with their categorization.

Abstract: In accordance with embodiments, there are provided techniques for managing functionality changes of an on-demand database system. The techniques facilitate implementing changes to the database system while minimize work flow reductions to users of the database system. To that end, one embodiment of the present invention delays implementation of the changes to provide users of the system an opportunity to adjust behavioral interaction with the database. In accordance with another embodiment of the present invention, users may implement the functional changes to determine any adverse impact on work flow, before the functional changes become permanent. In another embodiment, the user may be afforded an opportunity to selectively enable and disable the functionality changes before the duration expires.

Abstract: Methods and systems include embodiments that recursively save parent, grandparent, and other records in a database that depend from a record. User-provided code within a save event or trigger can thus call further save methods without corrupting the database. Junction objects, objects that reflect records with two or more parents, can also be recursively saved.