# Find changesets

> Find changesets using the cm find command in Unity Version Control CLI.

Find and filter changesets and changeset comments. To retrieve more information in regards to changesets, run the [`cm log`](../../uvcs-cli/find) command.

## Filtering options

The following list displays the different filtering options (`where`) that are available to use with the `cm find changesets` command:

* `attribute`
* `attrvalue`
* `branch`
* `changesetid`
* `comment`
* `date`
* `guid`
* `id`
* `owner`
* `parent`
* `repllogid`
* `replsrcdate`
* `replsrcid`
* `replsrcrepository`
* `replsrcserver`
* `returnparent`

> **Note:**
>
> The conditions `changesetid`, `date`, and `owner`, correspond to the **Name**, **Creation date**, and **Created by** columns in the **Changesets** tab of the UVCS desktop application.

## Output options

The following list displays the different output options (`--format`) available to use with the `cm find changesets` command:

* `branch`
* `changesetid`
* `comment`
* `date`
* `guid`
* `id`
* `owner`
* `parent`

## cm find changesets examples

### Show changeset comments

The following example shows the date and comment for all changesets that belong to the branch `main/scm12800`:

```text
cm find changeset "where branch = 'main/scm12800'" --format="{date} - {comment}"
27/05/2013 13:25:53 - Updated output.
27/05/2013 13:26:45 - Changed SccPlugin with the new change.
27/05/2013 13:35:15 - Added solution.

Total: 3
```

### Filter by a specific word

To filter for changeset comments that include a specific word, use the SQL syntax `like` and use the `%` characters for an approximate search:

```text
cm find changeset "where branch = 'main/scm12800' and comment like '%solution%'" --format="{date} - {comment}"
27/05/2013 13:35:15 - Added solution.

Total: 1
```

### Find replicated changesets

Query changesets by the replication date. For information on how to find the last replication date, refer to [replication log](./find-replicationlog).

```text
cm find changeset "where branch='semanticmain' and replsrcdate > '2013/06/17'" --nototal
427425   16794   /semanticmain   07/06/2013 11:06:38 violeta  codice IntegrateMiryamtask 12838
427435   16804   /semanticmain   07/06/2013 19:25:31 violeta  codice Changeassemblyversion (0.9.28.0).
427436   16805   /semanticmain   07/06/2013 19:54:35 lrodriguez codice Updatemapall
```

### Find the parent of a specific changeset

Use the `returnparent` to get the parent of a specific changeset:

```text
cm find changeset "where changesetid = 16583 and returnparent = 'true'" --nototal
423630   16582    /main/scm12800       27/05/2013 13:25:53 roberto  codice    Updated output.
```