I am creating some Transaction Groups where I want to use a Custom Index Column called ‘id’. I have found that sometimes “Ignition” will create the ‘id’ column in the DB table but it fails to create the Trigger and Underlying Sequence that does the auto increment. Usually I will drop the table and delete the Transaction Group and start over from Scratch. Does anyone know the exact order of operations to make sure a Custom Index is created for a new Transaction Group?
Next time I will make sure I have all Item Names in place, Table Name Specified, Create Table checked, and “Use Custom Index” checked.
If it still fails to create the Trigger and Underlying Sequence I will just try to create those Database objects directly. I am using an Oracle DB. Ignition 7.9.5