Do you want Empower Tips sent to your inbox each week?
  • Support Articles

Empower Tip: Browse Projects

Empower Tip: Browse Projects

Tip #9: How ID Numbers are Generated

Tip #9: How ID Numbers are Generated

Did you ever wonder where the ID numbers for methods and results come from? Have you wondered why a method in Project 1 has an ID number and when you copy it to Project 2 it has a different ID number? Well, metadata stored in the Oracle database is assigned an ID number starting with 1000, incremented by 1 as new metadata are created irrespective of the type of object. Now, let’s translate that into something we can all understand. This means that ID 1000 could be an instrument method in Project 1 and a processing method in Project 2. Here are a couple of practical examples.

Example 1

Step 1

Step 1

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

Step 2

Step 2

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

Step 3

Step 3

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

Step 4

Step 4

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.

Example 2

Step 1

Step 1

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

Step 2

Step 2

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

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 6 results are sequential.

Remember that if you copy something from one project to another that method or result will be assigned the next available ID in the destination project.


About the Author

About the Author
Neil Lander

Neil Lander

Neil provides internal support for Empower CDS software and is focused on developing laboratory software solutions that help organizations achieve their scientific and operational objectives.



Precisa de ajuda? Conecte-se a um especialista da Waters. 

Voltar ao início Voltar ao início