This content has been marked as final. Show 6 replies
In the ApplyMRU process, under "Source: Automatic Row Processing (DML)" region, set the "Return Key Into Item" field with your page item. You can then use the page item (ID, in your case) in the next page process.
Hi, thanks for your reply. I don't think this option exists in applyMRU??
There is source: Mutli-row update and delete not no return key to item option.
Oh yes, sorry for the confusion. The option is for the Automatic Row Processing (DML) process.
Need to rethink about this. Will update you if I find something.
You can have the code in your table trigger to update the created_by field as:
if inserting or updating then select user_id into :NEW.CREATED_BY from user where upper(username) = upper(v('APP_USER')); end if;
Don't think thats possible. Trigger cannot update the same table thats firing it, it throws a "mutating table" error.
Actually sorry that might work, its not updating justting setting value on :NEW.created_by like you generate primary key from sequence.