You can modify the query expression in the following ways.
Each query-related option generates a query clause. For example, the -name name option generates a query clause in the form (name='name').
When the same query option is repeated, the query clauses are combined with an or. For example, -name file1 -name file2 generates a query clause (name='file1' or name='file2').
Query clauses from different options or from the query expression are combined with an and. For example, -name file1 -owner joe generates a query clause (name='file1') and (owner='joe').
ccm finduse [-q|-query query_expression] [(-n|-name name)...]
[(-o|-owner owner)...] [(-st|-state state)...] [(-t|-type type)...]
[(-v|-version version)...] [(-i|-instance instance)...]
[(-release release_spec)...]
[-working_proj|-working_projs|-working_project|-working_projects]
[-shared_proj|-shared_projs|-shared_project|-shared_projects]
[-prep_proj|-prep_projs|-prep_project|-prep_projects]
[-released_proj|-released_projs|-released_project|-released_projects]
[-all_proj|-all_projs|-all_project|-all_projects]
[-personal_fold|-personal_folds|-personal_folder|-personal_folders]
[-shared_fold|-shared_folds|-shared_folder|-shared_folders]
[-prep_fold|-prep_folds|-prep_folder|-prep_folders]
[-non_write_fold|-non_write_folds|-non_write_folder|
-non_write_folders] [-all_fold|-all_folds|-all_folder|-all_folders]
[-all_baseline|-all_baselines]
[-wpg|-working_project_grouping|-working_project_groupings]
[-mpg|-my_project_grouping|-my_project_groupings]
[-ppg|-prep_project_grouping|-prep_project_groupings]
[-spg|-shared_project_grouping|-shared_project_groupings]
[-apg|-all_project_grouping|-all_project_groupings]
[-all_process_rule|-all_process_rules]
ccm finduse -query ""cvtype='ascii' or (cvtype='task' and status='completed')""