Skip to main content
Question

How to use the PROJECT_ID_NUMBER_TAB to obtain a formatted Project ID

M
Do Gooder (Customer)
Forum|alt.badge.img+4

On the IFS Cloud there is a table, 

PROJECT_ID_NUMBER_TAB

used by Project_Id_Number_API

 

But how can we use it, instead of the Project Id Numbers, we would like to uses rules for obtaining a numbering format like [AA][UUUU][NOSEQUENCE], with

  • AA Current year
  • UUUU a custom field
  • and the sequences

How can we achieve this, because when i’m using the PROJECT API 

when I’m using 

 

    Client_SYS.Clear_Attr(attr_);

    -- Add attributes
    Client_SYS.Add_To_Attr('OBJID', OBJID_, attr_);
    Client_SYS.Add_To_Attr('OBJVERSION', OBJVERSION_, attr_);
    Client_SYS.Add_To_Attr('PROJECT_ID', MCI_NEW_PROJECT_ID, attr_);
    Client_SYS.Add_To_Attr('ACTION', ACTION_, attr_);  

    -- Modify project
    PROJECT_API.Modify__(INFO_, OBJID_, OBJVERSION_, attr_, ACTION_);

Project.UPDATE: I got the message that “[PROJECT_ID] cannot be modified”

2 replies

E
Hero (Employee)
Forum|alt.badge.img+9
  • EriLNL
  • Hero (Employee)
  • 75 replies
  • March 21, 2025

Hi,

 

The PROJECT_ID_NUMBER_TAB is used to setup the basic data for automatic generating Project ID's

In the as is you could already achieve a large portion of your requierment.

  • If the "Custom field” you refer to can be othe program or category 1 or 2 than this setup would do the trick:

  • In my example The program defines that if it is installation the project ID starts with 25I and than a sequence

Be aware that

  • At the beginning of 2026 I would need to change this to 26I

  • The prefix can only be 3 characters so 25INST as a prefix is not possible

If this is not what you need, than you would need to modify the function that generates the Project ID
Not sure which one this is but a developer should not have a lot of issues finding is.

Be aware that the project id is MAX 10 long.

Hope this helps a bit

Regards Erik

M
1 person likes this
  • M
    MCIPSTEV
M
Do Gooder (Customer)
Forum|alt.badge.img+4
  • MCIPSTEV
  • Author
  • Do Gooder (Customer)
  • 12 replies
  • March 25, 2025

Hello 

​@EriLNL Thanks for the reply.

 

So I noticed IFS can generate Project ID using  the page: Project ID generation rules

Whithout changing the API from IFS, it is not possible to generate the 

[AA][UUUU][NOSEQUENCE], 

  • AA Current year
  • UUUU a custom field
  • and the sequences

This is a really missing feature, and we made a workaround by creating a custom field based upon, the current year, the UUUU from the ProgramID and the Sequence from the Project ID Generation.
 

It would be great if the PREFIX can be longer than 3 chars, so we we can create on the fly the project ID with the specifications.

Best Reards

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings