Skip to main content
Solved

Define Starting ID for Service Requests and Request Work Tasks

  • March 19, 2026
  • 2 replies
  • 34 views

Forum|alt.badge.img+4

We go live in a week or so.  Is there a way in service to define the starting ID for Service Requests and Request Work Tasks.  Right now the sequencing starts at one.  With the way oracle sorts IDs, this will become a problem when there are million plus IDs… i.e. the sort sequence will look like this: 1, 10, 100, 1000, 10000 then 2, 20, 200, 2000 20000 etc.  If there were a way to define the start value, we would like to know about.  I suspect it is not possible.

 

 

 

Best answer by Alexander Heinze

I haven’t come across a way to configure this, however had the same issue multiple times, so I thought it may be worth an enhancement idea: Provide a configurable numbering pattern for Request ID and Task ID | IFS Community

2 replies

Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+25
  • Ultimate Hero (Employee)
  • Answer
  • March 20, 2026

I haven’t come across a way to configure this, however had the same issue multiple times, so I thought it may be worth an enhancement idea: Provide a configurable numbering pattern for Request ID and Task ID | IFS Community


AdrianEgley
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • March 20, 2026

@Alexander Heinze is it not possible on IFS Cloud to set the sequence values at DB level? Using FSM and a SQL database we’re doing that for custom tables we create, or setting a counter to start from a value that isn’t 1, 2, 3 etc.

Is this not possible through an Oracle DB?

Going to be going down this route soon, so would be go to know.

Ady