Skip to main content
Waters

How are the ID numbers in projects generated? - Tip9

Article number: 50121

OBJECTIVE or GOAL

Where do the ID numbers for methods and results come from? Why does a method take on a different ID number when you copy it from one project to another?

Metadata stored in the Oracle database behind Empower Software is assigned an ID number starting with 1000, incremented by 1 as new metadata are created, irrespective of the type of object. This means that ID 1000 could be an instrument method in project 1 and a processing method in project 2. Below are a few practical examples.

ENVIRONMENT

  • Empower

PROCEDURE

  1. Starting on the Methods tab in Browse Project, we see an instrument method called Alliance with an ID of 1115.

id-gen1.png

  1. Let’s right-click on the method and select Copy To Project.

id-gen2.png

  1. Let’s copy it to the Evaluation Project, which is a new project without any data or methods.

id-gen3.png

  1. If we go to the Methods tab of the Evaluation Project, we see the method has an ID of 1001 because that was the next available ID number in the destination project. 

id-gen4.png

  1. Back in our original project, let’s select the Result Sets tab, right-click on a Result Set, and select View As, Results. 

id-gen5.png

  1. The Result Set has six results, and we see that the ID numbers for each Result are sequential, starting at 1387 and ending at 1392. 

id-gen6.png

ADDITIONAL INFORMATION

A couple of final notes:

  • ID numbers within a project are assigned as activity happens within that project. When I processed the Result Set there was no other activity in the project at that time. Therefore, the ID numbers of the six results are sequential.
  • Remember that if you copy something from one project to another, the method or result will be assigned the next available ID in the destination project.

id50121, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP

Not able to find a solution? Click here to request help.