Using Siebel Tools > Managing Repositories > Managing Modifications That Developers Make to Repositories >

Adding Identification Numbers to Repository Modifications

In some development environments, you might find it useful to associate an identification number with each modification that a developer makes to the repository. You can use this feature to help manage and maintain development work, particularly when your organization includes multiple developers who work across multiple development initiatives. For example, you can use this identification number to track all the modifications that your development team makes for a feature, or to help track the resolution of a bug that uses a unique identification number.

To add identification numbers to repository modifications

1. Enable the system preferences. Do Step 1.
2. Log out of, and then log back into Siebel Tools.
3. Modify an existing object, or create a new one.
4. Check in the project or object:
   1. Right-click the object that you modified in Step 3, and then click Check In.
   2. In the Check In dialog box, click Check In.
   3. In the Repository Object Check-in Description dialog box, in the Enter Feature No/Bug No/RF No field, enter a number.

      You can specify any alphanumeric number up to a maximum length of 15 characters. Siebel Tools assigns this number to all objects that you check in.

      For more information, see Checking Out and Checking In Projects and Objects.

5. (Optional) Locate all the modifications that are associated with an identification number:
   1. Start SQLPlus, connected to the Siebel Database on the Siebel Server.
   2. Run the following SQL query:

   SELECT column REL_FEATURE_TXT FROM S_TAG_OBJECT WHERE
   REL_FEATURE_TXT = 'identification_number'

   where:

   • identification_number is the number that you entered in Step 4. You must enclose this number with single quotes.
   • S_TAG_OBJECT is the Siebel CRM table that contains all of the identification numbers.
   • REL_FEATURE_TXT is the column of the S_TAG_OBJECT table that contains the identification numbers.

     For example, if you specify an identification number of myObjects123 in Step 4, then you run the following SQL query:

   SELECT column REL_FEATURE_TXT FROM S_TAG_OBJECT
   WHERE REL_FEATURE_TXT = 'myObjects123'

   Siebel Tools adds the identification number to the REL_FEATURE_TXT column the first time that you check in the object. For each subsequent checkin of this object, it saves a unique number in the same column. To do this, it appends the subsequent identification number to the existing identification number. It uses two vertical bars (||) to separate these numbers.

   To locate all identification numbers, run the following SQL query:

   SELECT * FROM S_TAG_OBJECT

   You must run this query against the Siebel database on the Siebel Server.

   For more information about SQLPlus, see the SQL*Plus® User's Guide and Reference on the Oracle Help Center at

   http://docs.oracle.com/cd/B19306_01/server.102/b14357/toc.htm