Generate a Rowkey while inserting a row

@Yasas Kasthuriarachchi - can you please move this topic to Framework & Experience.

Thanks @ola.nissen,
Moved to Framework & Experience forum. 

Hi @Kelum Niranjana 

it is really perfect. Thank you a lot.

Kind regards

Not sure this is the right way… the table should be rowkey enabled. Think this is done somewhere in Solution Manager. When the table is rowkey anabled all old rows will get the rowkey set and all new rowkeys will get the guid automatically by a default value function on the rowkey column.

Hi @hhanse 

if you create a new object in IFS directly then the rowkey will be generated.

But if you insert a new row with PLSQL or with an event it doesn’t create the rowkey - not in IFS APP 9.

Unless you know an other way. :-)

So you mean that Oracle treats row inserts differently depending on if its done through the framework or by PLSQL?  It says in the column definition that if the column is null when inserting a new row, it should set sys_guid()….   or?
But this requires that kowkey in enabled on the table. This is made manually in SolutionManager in older versions if IFS Applications.

 

hhanse wrote:

So you mean that Oracle treats row inserts differently depending on if its done through the framework or by PLSQL?  It says in the column definition that if the column is null when inserting a new row, it should set sys_guid()….   or?
But this requires that kowkey in enabled on the table. This is made manually in SolutionManager in older versions if IFS Applications.

 

 

Hi @hhanse 

yes, I think so. If I insert a new row (with PLSQL or an event) it doesn’t generate a rowkey. See my first screenshot.

As you can see the table hasn’t a default function:

I don’t know why.

Thank you

Again   - Table requires that rowkey in enabled on the table. This is made manually in SolutionManager in older versions if IFS Applications.
Per LU:
https://docs.ifs.com/techdocs/Foundation1/040_administration/300_system_information/010_logical_units/default.htm

Or in bulk:
https://docs.ifs.com/techdocs/Foundation1/040_administration/300_system_information/010_logical_units/enable_and_disable_rowkey.htm