Skip to main content
Solved

How to set the primary key for an IAL object?

  • November 7, 2024
  • 3 replies
  • 95 views

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 326 replies

Hi,

 

I created a partially replicable IAL object.

For some time later a problem occurred. There were duplicate rows. Then we understand there is a problem with the IAL. While setting partially replicable IAL. The app threw information about duplicate rows. I didn’t care about it before. Now I need to set the primary key for this IAL.

The IAL includes only the INVENTORY_PART_IN_STOCK view. And for this table (INVENTORY_PART_IN_STOCK_TAB) primary key is “PART_NO, CONTRACT, CONFIGURATION_ID, LOCATION_NO, LOT_BATCH_NO, SERIAL_NO, ENG_CHG_LEVEL, WAIV_DEV_REJ_NO, ACTIVITY_SEQ, HANDLING_UNIT_ID”. How can I set the primary key for the IAL object?

Best answer by dsj

Hi @hhy38 

When you are creating the IAL, you can mention which columns from the SQL to be used as PK Index.

Hope it helps!

Damith

3 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 905 replies
  • Answer
  • November 7, 2024

Hi @hhy38 

When you are creating the IAL, you can mention which columns from the SQL to be used as PK Index.

Hope it helps!

Damith


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 326 replies
  • November 7, 2024

Thank you Damith @dsj :) I didn’t read this section. 🙈


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 905 replies
  • November 7, 2024

Thank you Damith @dsj :) I didn’t read this section. 🙈

@hhy38  You are not alone 😆. Here’s a quote I live by: When all else fails, read the instructions.