• State Not Answered
  • Replies 7 replies
  • Subscribers 14 subscribers
  • Views 4316 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Auto Generate primary ID using a custom prefix

Konduru Chaitanya
Certified Senior Developer

Hello,

I would like to create a CDT with a primary key which must be an Auto-generated value but with a prefixed value. 

Ex: "APP_01",

Where the number 01 must be an auto incremented value. Is it possible to do so? If yes please suggest me a possible way to do it.

I was unable to understand the following:

Generating primary keys

When using a sequence to generate ids (such as @GeneratedValue(strategy=GenerationType.SEQUENCE)), we recommend allowing the system to name the sequence instead of providing a name with the generator attribute. If you choose to define a sequence generator with the generator attribute in conjunction with the @SequenceGenerator annotation, then you must provide a name, and that name must be unique across all sequence generators in the system to avoid uniqueness constraint violations

https://docs.appian.com/suite/help/22.2/Database_Schema_Best_Practices.html

Please help me with the above.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee

    Stewart gave a good solution, but I'd also be curious how you plan to use this. Like do you actually need the value in the database or are you just hoping to have a friendly way of displaying the PK in Appian? If it's the latter, I'd recommend just storing the integer in the database and then have some method of formatting the result in Appian. For example, you could create a custom field that concatenates an app name in front of the identifer and it should work perfectly.

  • 0
    Certified Senior Developer
     in reply to Peter Lewis

    Hi Peter,

    Since I am new to Appian I've been exploring multiple ways to make a combination of Alpha-numeric values to display the User-Id. I wanted it to be stored as a combination of alphabets and numbers in the database. I have already tried the way which you have mentioned. I tried using the Alphabets and & concatenation using the PK value in the interface. Just wanted to know if there is any possible way to generate it automatically in the DB with no multiple columns. 

Reply
  • 0
    Certified Senior Developer
     in reply to Peter Lewis

    Hi Peter,

    Since I am new to Appian I've been exploring multiple ways to make a combination of Alpha-numeric values to display the User-Id. I wanted it to be stored as a combination of alphabets and numbers in the database. I have already tried the way which you have mentioned. I tried using the Alphabets and & concatenation using the PK value in the interface. Just wanted to know if there is any possible way to generate it automatically in the DB with no multiple columns. 

Children

© 2024 Appian. All rights reserved.