Get Empowered: Browse Projects | Tip #9

By March 21, 2017

Tip #9: How ID Numbers are Generated

Subscribe to the Empower Tips BlogIn the last Empower Tip of the Week for Empower Chromatography Data Software (CDS), we explored how to compare calibration curves. In this blog, we are going to demonstrate how ID numbers are generated.

Here we go.

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 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. 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.

Step 1

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

Empower Software: Methods tab | Figure 1

Figure 1

Step 2

Let’s right-click on the method and select Copy To Project. (Figure 2)

Empower Software: Copy to project | Figure 2

Figure 2

Step 3

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

Empower Software: Select project | Figure 3

Figure 3

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. (Figure 4)

Empower Software: methods tab | Figure 4

Figure 4

Step 5

Example 2: Back in our original project let’s select the Result Sets tab, right click on a Result Set and select View As, Results. (Figure 5)

Empower Software: Results sets tab | Figure 5

Figure 5

Step 6

The Result Set has 6 results and we see the ID numbers for each Result are sequential starting at 1387 and ending at 1392.  (Figure 6)

Empower Software: Results | Figure 6

Figure 6

A couple of final notes:

  1. 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.
  2. 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.


Next week in Tip #10 – Using Global Project View to Search Across Multiple Projects.

More resources:

Do you want Empower Tips sent to your inbox every week?

Subscribe Now

Questions? Tips of your own? Let us know!

Categories: Empower Tips