Issue in Write to data store entity

Question

Hi All, 
 I facing challenge in write to data store entity I have one Primary key field "ABC" of type unique(TEXT) and another field "XYZ" 
 which is of type number with auto increment now while passing the data from appian Im passing both field as blank My requiremnt is to the field "XYZ" to be auto populated

kindly help

Mike Schmitt · Answer

You should still make the PKID an auto-incrementing integer. If you require a unique identifier that's exposed to the end user, just create that as an additional column and validate its uniqueness within Appian - that could be number, text, or both as per your requirements.

Peter Lewis · Answer

Keep in mind that it's entirely up to you as the app developer to determine what fields are visible to users by choosing which fields to display on any UI - there's nothing stopping you from only showing the requestNumber and not showing the idUnique (regardless of which one is the primary key or not). In general I'd strongly recommend having an integer as your PK because queries will perform much better using an integer. If you need the "idUnique" field to be unique, you can still add an annotation in your XSD for that too: @Column(name="unique_text", unique=true, columnDefinition="VARCHAR(255)")

Issue in Write to data store entity

Top Replies