Commands

A Command is an action stored in the Schema that can be executed against the database either locally using Business Rules Scripting or invoked remotely by a client application. Examples of a Command include: a stored procedure, an SQL statement or a means to Inserting/Updating or Deleting records in a data table.

Each Command has a collection of parameters and statements. The Parameter can be used to filter the records retrieved from a data table for certain conditions, to pass new data to insert/update/delete statements, or to simply provide parameters that a certain operation or stored procedure requires. A Statement contains a reference to a particular database connection, it's data table or a stored procedure and may have custom sql so you can do exactly what you need. Commands can also be set to being private and only available to the server for execution.

Adding, editing or deleting a command is achieved using either the Schema Modeler (Windows) or Server Explorer (Mac OS X).

As allowing the execution of remote commands could pose a security risk, Relativity Server is configured by default to prevent the execution of arbitrary commands on the server.

To enable the execution of commands from a client, the Allow Command Execution property of the Domain must be set to true. When using Relativity Server this can be done using one of the provided tools1. It is recommended that you ensure that all published Commands in your schema are safe for execution as they execute directly on the server data.

Finally it is important to have proper authentication methods in place to prevent anonymous users from making malicious calls.