Perforce 2003.2 P4Report User's Guide | ||
<< Previous Chapter Defect Tracking |
Table of Contents Index Perforce on the Web |
Next Chapter >> Database Schema and SQL Keywords |
select change from changes
where filespec = '//depot/main/release2.0/...';
To list changes including integrations, include the options='integrated' clause:
select change from changes
where filespec = '//depot/main/release2.0/...'
and options = 'integrated';
select count(*) from changes
where filespec = '//depot/release1.1/...';
If the release is stored in a label:
select count(*) from changes
where filespec = '//...@release1.1';
select * from changes
where filespec = '//depot/release1.1/...';
If the release is stored in a label:
select * from changes
where filespec = '//...@release1.1';
select file, count(*) from files
where file like '//depot/branch1/%' group
by file having count(*) > 1;
select fromfile, endfromrev from files, integs
where change = 123 and
file = tofile and
how in ('copy into', 'merge into') and
fromfile like '//depot/branch1/%' and
revision between starttorev and endtorev
union
select file, revision from files
where change = 123 and
file like '//depot/branch1/%';
Perforce 2003.2 P4Report User's Guide | ||
<< Previous Chapter Defect Tracking |
Table of Contents Index Perforce on the Web |
Next Chapter >> Database Schema and SQL Keywords |