IBM Support

How to query for all change requests that are not associated to any task in Rational Synergy database using CLI

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"}}]

Document Information

Modified date:
22 December 2020

UID

swg21573668