> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Insert, update, and delete

## Other query types

### Integer insert()

`insert()` adds a new row to an existing table. Here's how you do it:

1. Populate the fields in the new record with `addData()`.
2. Call `insert()`.
3. Optionally do something with the returned ID.

<Tip>
  Consider wrapping the insert query in a `try...catch` block.
</Tip>

### Void update()

`update()` changes existing data in the database. Here's how you do it:

1. Populate the fields you want to change.
   * Use `addData()` to add a value
   * Use `addDataField()`  to add a foreign key

2. Optionally use `addCriteria()` to place restrictions on the items to modify.

3. Call `update()`.

<Warning>
  Writing to the database this way doesn't log the change to the crm7.traveltransactionlog table. It should therefore be avoided in environments with satellites and travelusers.
</Warning>

### Void delete()

`delete()` removes data from the database. Think carefully before you delete anything!

Here's how you do it:

1. Build a complete [select query][1].

2. Optionally inspect the result set to check that you are deleting what you intend to.

3. Call `delete()`.

<Note>
  Best-practice is to use the NetServer agent classes to remove data because they also remove data from related tables and log changes to the traveltransactionlog.
</Note>

## Adding data for update and insert

<Note>
  You must write field names prefixed by their table name. For example, `customer.name`.
</Note>

### Void addData(String field, String value)

Adds data for use in an update or insert query.

```crmscript theme={null}
SearchEngine se;
se.addData("ticket.status", "deleted");
se.addCriteria("ticket.status", "equals", "postponed");
se.update();
```

### Void addDataField(String field1, String field2)

Adds a data field to the SearchEngine for use in an **update** query.

A data field doesn't contain a value - it's a foreign key to another field. The target field can be within the same table or in a related table.

```crmscript theme={null}
SearchEngine se;
se.addDataField("ticket.deadline", "ticket.closed_at");
se.update();
```

### Void addDataField(String field1, String field2, String func)

A variant of `addDataField()` specifying an aggregate function to use for `field2`.

The following functions are available:

* any of the functions you can use with `addField()` - listed in the reference section for the [select query][1].

* castToVarchar

* date

* time

[1]: ./se-select


## Related topics

- [Bulk Operations](/en/api/bulk-operations/index.md)
- [Building a query](/en/automation/crmscript/searchengine/se-select.md)
- [Working with Upsert](/en/api/bulk-operations/mass-operations/upsert.md)
- [SearchEngine](/en/automation/crmscript/searchengine/index.md)
- [How to use custom objects to search for information](/en/api/web-services/howto/custom-objects/custom-objects-search.md)
- [Insert](/en/api/reference/restful/agent/databasetable_agent/insert.md)