It's all about the answers!

Ask a question

Making bulk change to date parameter - currently on CLM / CCM 6.0.4


Sam Naik (11) | asked Mar 21 '19, 4:59 p.m.
edited Mar 21 '19, 6:45 p.m. by Muralidhar Rajagopal (10114)

 Hi !

I am trying to figure if there is a way to make a bulk update to 1000+ defects where the date parameter needs to be set to empty. Currently all the defects have an expired date and it would take me a few days to get into each defect individually and manually reset the date.

I am using CLM 6.0.4.

Appreciate the help and responses.

Thanks!

One answer



permanent link
Ralph Schoon (61.4k33643) | answered Mar 22 '19, 7:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Mar 22 '19, 7:50 a.m.

You can run a work item query and then use the bulk update feature in the web UI to set a new date. Unfortunately this does not allow to delete the date. I am not sure if there is a way to remove a date that has been set.


I added a way to delete dates to WCL in version 4.6. See https://github.com/jazz-community/work-item-command-line
I added a way to set a timestamp to null/unassigned for all commands. The bulk update would be ideal if you can run a query that returns all the items. It is also possible to set a different date, if needed.
wcl -update /ignoreErrors repository="https://clm.example.com:9443/ccm" user=user password=password id=89 dueDate="unassigned"

wcl -bulkupdate /ignoreErrors repository="https://clm.example.com:9443/ccm" user=user password=password projectArea="JKE Banking (Change Management)" query="All" dueDate="unassigned"

Your answer


Register or to post your answer.