How to reserve digit place for Sequence Number

Comments

4 comments

  • Avatar
    Andreas Blersch

    We had the similar requirement. I solved this with a separate REST service endpoint to have more format options.

    0
    Comment actions Permalink
  • Avatar
    Ch

    Hi Andreas, thanks for your idea. Will consider that

    0
    Comment actions Permalink
  • Avatar
    vaibhav brahme

    Hi Ch,

    You can create a table in SQL and write a Stored Procedure to generate a sequence number and store it in the same table. 

    1
    Comment actions Permalink
  • Avatar
    Ch

    Hi vaibhav,

    Thanks! Didn't think of that.

    --------------------------

    Alternatively, for those who faces the same problem and doesn't require that much number (thousands), can put 1000 as starting number, so that the tickets will be 1xxx

    0
    Comment actions Permalink

Please sign in to leave a comment.