Tuesday, November 10, 2009

How do you query for objects from a particular Release pattern?

Follow the steps below to query the objects associated to a particular "release value pattern".
  1. Query for all the active releases using the command:

    ccm release -l -active

  2. Next to list all the projects pertaining to all the releases on the database run the command:

    ccm query -t project -f "%release"

  3. Query for all the projects pertaining to a particular release pattern:

    ccm query -t project "release match '*toolkit/*'" -f "%objectname %release"

    This lists only the projects.

  4. List all the objects on the database pertaining to this release pattern:

    ccm query "release match '*toolkit/*'" -f "%objectname %release"

    This will list all the objects in the database like process rules, reconfigure_templates, tasks, files, folders, baselines etc. The output can be huge depending on the size of the database.

  5. Query for the tasks of that particular release pattern:

    ccm query -t task "release match '*toolkit/*'" -f "%objectname %release"

  6. Query for all the objects associated to the queried release pattern.

    ccm query "is_associated_object_of('four_part_name_of_task')"

No comments:

Post a Comment