<p>On occasion, I find myself wanting to search the text of changelist descriptions in Perforce.  There doesn't appear to be a way to do this in P4V.  I can do it by redirecting the output of the changes command to a file...</p>

<pre><code>p4 changes -l &gt; p4changes.txt
</code></pre>

<p>...(the -l switch tells it to dump the full text of the changelist descriptions) and then searching the file, but this is rather cumbersome.  Has anyone found a better way?</p>

I use
p4sql
and run a query on the "changes" database. Here's the
perforce database schema
The query looks something like this (untested)
```
```
select change from changes where description like '%text%' and p4options = 'longdesc'
```
```
edit: added the p4options to return more than 31 characters in the description.