I want to update the CI version automatically when we close a release record
the naming convention will be like displayName_Location_Date, this will be from cm3r table to device file .
any help to do this ?
Application Delivery Management
Application Modernization & Connectivity
CyberRes by OpenText
IT Operations Management
I want to update the CI version automatically when we close a release record
the naming convention will be like displayName_Location_Date, this will be from cm3r table to device file .
any help to do this ?
Release record is change record (cm3r) - Right ?
The new value must be inserted into device table, in what field ?
Then you need to use triggers for cm3r table (after change)
set condition for status and if it become close (or any you use) set in device table any changes you whant.
hi ALARMus,
yes it is cm3r record.
we want the version field to be sum of (CIName_CIType_Vx 1)
how we can collect all this one field ?
Trigger for cm3r table (after update), name it like cm3r.a.u.Add2Device
if (!system.functions.same(record.status,oldrecord.status) && record.status=="Closed") { var TableDevice = new SCFile("device"); if (TableDevice.doSelect("logical.name=\"" record.asset "\"") == RC_SUCCESS) { TableDevice.version= record.releaseversion } }
That's mean if the change status is changed and equel "Closed"
Then update Device table with data from cm3r table.
Hi ALARMus ,
it gives me this error:
Script <no name> line 1: ERROR SyntaxError: invalid assignment left-hand side at char 76
if (!system.functions.same(record.status,oldrecord.status) && record.status="Closed")
^
Compilation of JavaScript function or expression failed
Fixed.
see script again.
ALARMus ,
unfortunately it is not working !
So. what exactly dont work ?
the compiltation is successful but the version value is not being changed after closing the change
i added the trigger with script in cm3r table as attached
So let's make some troubleshooting.
Change part of your script to:
...
TableDevice.version = record.rc_version } }
thanks ALARMus,
still the script not updating the device file after closing the record
lets fix it.
1) So let's define what fields you use
Source Destination
table: cm3r-------------device
=========fields=========
rc.version ------------> version ?
asset ========== display.name ?
ci.rc =========== display.name ?
Do you need for this trigger start application = trigger.device.mtbf (as i see on your screenshot) ?
2) About script. Lit's add some print:
if (!system.functions.same(record.status,oldrecord.status) && record.status=="Closed") { print("(1) - cm3r.a.u.Add2Device: Status changed to Closed for Change-" record.number); var TableDevice = new SCFile("device"); if (TableDevice.doSelect("display.name=\"" record.ci_rc "\"") == RC_SUCCESS) { print("(2) - cm3r.a.u.Add2Device: Found CI with display.name = " record.ci_rc "; Updating Device, set - " record.rc_version); TableDevice.version= record.rc_version; } }
3) And finally display you FC for this version in cm3r (where you add concatenation for version)
Please answer questions to continue resolving your problem.
Please answer questions to continue resolving your problem.