Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..
664 views

Update CI version Automatically

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  ?

 

0 Likes
22 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Update CI version Automatically

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.

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Update CI version Automatically

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 ?

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Update CI version Automatically

CIName_CIType_Vx+1 - is this fields from device table ?

Can you write exact name of field and table name (where this field is) ?

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Update CI version Automatically

No its not a filed  they are 3 fields !

but when we update the version of a CI the new version (version field in device table ) should contain those 3 three information .

my question is : how we can gather three fields in one field as a text ?

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Update CI version Automatically

So. You can use FC and script (as trigger)

FC:

In Calculations for calculation line:

Use field of table or temporary variable (for example - $L.Version)

$L.Version="Some text if need - "+field1 in $file+", Some more fixed text if need; "+ field2 in $file

Well now just transfer this $L.Version where you need.

*****************

Or You can use Triggers :

if (!system.functions.same(record.status,oldrecord.status) && record.status=="Closed")
{
	var TableDevice = new SCFile("device");
	if (TableDevice.doSelect("logical.name=\""+record.number+"\"") == RC_SUCCESS)
       {
        TableDevice.version= record.YOURFIELD1+"_"+record.YOURFIELD2+"_"+record.YOURFIELD3
       }
}

If this trigger for CM3R table so - record.YOURFIELD1 - field from cm3r table and

record.number field in CM3R table wich contained logical.name value

 

Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Update CI version Automatically

thank you very much ALARMus this will help me a big deal!

im trying to add this trigger on cm3r table.

could you please help me to choose the appropriate application for this trigger ? I'm attaching a screen shot 

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Update CI version Automatically

See my previous post (i fixed some script line)

What do you mean "appropriate application for this trigger" ?

If this is for change then cm3r. Fix your new script in trigger.

And dont forget to compile it.

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Update CI version Automatically

Hi ALARMus ,

i did it using FC and i could combine 3 values (fields) toghether thank you.

and my issue now that i cant update the CM with the version value .

could you help me please how i can pass this value to device table ?

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Update CI version Automatically

Describe more details what you have now (table, field, value) ?

What condition when you whant to start transfer some data to what table and what field ?

=============

KUDOS are Welcome

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Update CI version Automatically

Hi ALARMus,

i want to transfer a customized field in "cm3r" table named as "releaseversion " when i close the change record of category "Release Management " to the  "version' field in the "Device" Table .

i want a query which always update the version value from the release record for this CI

source                         Destination 

release version            version

cm3r                             device

condition : cm3r status is closed 

 

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Update CI version Automatically

what name of field in cm3r table wich contain value of logical.name for table device ?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.