If we have a combination of two columns as primary key then can we have auto gen

If we have a combination of two columns as primary key then can we have auto generated values for the any of the column in the DB Table?

OriginalPostID-217669

OriginalPostID-217669

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    The queryEntity function can read data from tables with composite keys, however the totalCount and identifiers fields of the returned data subset will be incorrect unless a separate unique column in the table is mapped to a field in the CDT that is annotated with the @Id annotation.

    From the above suggestion, having a separate column with unique values would be preferred and the generated values can be used for the composite i suppose.
Reply
  • 0
    Certified Senior Developer
    The queryEntity function can read data from tables with composite keys, however the totalCount and identifiers fields of the returned data subset will be incorrect unless a separate unique column in the table is mapped to a field in the CDT that is annotated with the @Id annotation.

    From the above suggestion, having a separate column with unique values would be preferred and the generated values can be used for the composite i suppose.
Children
No Data