Question & Answer
Question
How do you query for all change requests that are not associated to any task in the IBM Rational Synergy database using command line interface (CLI)?
Cause
You want to query all the Change Request with no task association.
Answer
Run the following command:
- ccm query -t problem "(not has_associated_task(cvtype='task'))"
Example:
------------------
ccm query -t problem "(not has_associated_task(cvtype='task'))"
1) G#2 crbase reassign_me problem <void> G <void>
------------------
[{"Product":{"code":"SSC6Q5","label":"Rational Synergy"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Documentation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.4;6.5;7.0;7.1;7.1.0.1;7.1.0.2;7.1.0.3;7.1.0.4;7.1a;7.2;7.2.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
22 December 2020
UID
swg21573668